https://sofel-legal-consulting.com/codes-lois/9

Query Metrics

19 Database Queries
7 Different statements
6.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.name_eng AS name_eng_6 FROM section t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
2 0.37 ms
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM law l0_ INNER JOIN section s1_ ON l0_.section_id = s1_.id WHERE s1_.id = ?
Parameters:
[
  9
]
3 0.30 ms
SELECT DISTINCT l0_.id AS id_0, l0_.created_at AS created_at_1 FROM law l0_ INNER JOIN section s1_ ON l0_.section_id = s1_.id WHERE s1_.id = ? ORDER BY l0_.created_at DESC LIMIT 3
Parameters:
[
  9
]
4 0.59 ms
SELECT l0_.id AS id_0, l0_.author AS author_1, l0_.date AS date_2, l0_.image_name AS image_name_3, l0_.title AS title_4, l0_.link AS link_5, l0_.file_details_name AS file_details_name_6, l0_.description AS description_7, l0_.created_at AS created_at_8, s1_.name AS name_9, s1_.name_eng AS name_eng_10 FROM law l0_ INNER JOIN section s1_ ON l0_.section_id = s1_.id WHERE s1_.id = ? AND l0_.id IN (?) ORDER BY l0_.created_at DESC
Parameters:
[
  9
  [
    56
    55
    54
  ]
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.name_eng AS name_eng_6 FROM section t0
Parameters:
[]
6 0.33 ms
SELECT l0_.id AS id_0, l0_.author AS author_1, l0_.title AS title_2, l0_.description AS description_3, l0_.date AS date_4, l0_.link AS link_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.image_name AS image_name_8, l0_.image_original_name AS image_original_name_9, l0_.image_mime_type AS image_mime_type_10, l0_.image_size AS image_size_11, l0_.image_dimensions AS image_dimensions_12, l0_.file_details_name AS file_details_name_13, l0_.file_details_original_name AS file_details_original_name_14, l0_.file_details_mime_type AS file_details_mime_type_15, l0_.file_details_size AS file_details_size_16, l0_.file_details_dimensions AS file_details_dimensions_17, l0_.user_id AS user_id_18, l0_.section_id AS section_id_19 FROM law l0_ ORDER BY l0_.created_at DESC LIMIT 10
Parameters:
[]
7 0.33 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  1
]
8 0.32 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  2
]
9 0.28 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  3
]
10 0.28 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  4
]
11 0.28 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  5
]
12 0.26 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  6
]
13 0.26 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  7
]
14 0.27 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  8
]
15 0.27 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  9
]
16 0.26 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  10
]
17 0.40 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  11
]
18 0.53 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  12
]
19 0.49 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.description AS description_4, t0.date AS date_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13, t0.file_details_name AS file_details_name_14, t0.file_details_original_name AS file_details_original_name_15, t0.file_details_mime_type AS file_details_mime_type_16, t0.file_details_size AS file_details_size_17, t0.file_details_dimensions AS file_details_dimensions_18, t0.user_id AS user_id_19, t0.section_id AS section_id_20 FROM law t0 WHERE t0.section_id = ?
Parameters:
[
  13
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Law\Section No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Law\Law No errors.
App\Entity\User No errors.