Query Metrics
66
Database Queries
10
Different statements
221.73 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 149.92 ms |
SELECT a0_.id AS id_0, a0_.public AS public_1, a0_.publication_date AS publication_date_2, a0_.creation_date AS creation_date_3, a0_.require_user AS require_user_4, a0_.is_model AS is_model_5, a0_.template AS template_6, a0_.sort AS sort_7, a0_.is_template AS is_template_8, u2_.type AS type_9, c3_.is_recommandation AS is_recommandation_10, p9_.id AS id_11, p9_.version_date AS version_date_12, p9_.title AS title_13, p9_.description AS description_14, p9_.image AS image_15, p9_.link AS link_16, e10_.id AS id_17, e10_.template AS template_18, e10_.sort AS sort_19, e11_.id AS id_20, e11_.name AS name_21, e11_.template AS template_22, e11_.description AS description_23, e11_.editor_display AS editor_display_24, e11_.overridable AS overridable_25, a0_.discr AS discr_26, a0_.parent_id AS parent_id_27, a0_.model_id AS model_id_28, u2_.user_id AS user_id_29, c3_.user_id AS user_id_30, p9_.page_id AS page_id_31, e10_.type_id AS type_id_32, e10_.page_version_id AS page_version_id_33 FROM abstract_page a0_ LEFT JOIN static_page s1_ ON a0_.id = s1_.id LEFT JOIN user_page u2_ ON a0_.id = u2_.id LEFT JOIN contract c3_ ON a0_.id = c3_.id LEFT JOIN contract_page c4_ ON a0_.id = c4_.id LEFT JOIN service s5_ ON a0_.id = s5_.id LEFT JOIN service_category s6_ ON a0_.id = s6_.id LEFT JOIN about_item a7_ ON a0_.id = a7_.id LEFT JOIN about_category a8_ ON a0_.id = a8_.id INNER JOIN page_version p9_ ON a0_.id = p9_.page_id LEFT JOIN element e10_ ON p9_.id = e10_.page_version_id LEFT JOIN element_type e11_ ON e10_.type_id = e11_.id INNER JOIN page_version p12_ ON a0_.id = p12_.page_id WHERE ? LIKE CONCAT(?, p12_.link) ORDER BY p9_.version_date DESC
Parameters:
[ "/" "%" ] |
2 | 3.93 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
1189
]
|
3 | 0.81 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
958
]
|
4 | 1.68 ms |
SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM service_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = ?
Parameters:
[
1
]
|
5 | 2.51 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
10
]
|
6 | 1.84 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
61
]
|
7 | 1.38 ms |
SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM about_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = ? ORDER BY t1.sort ASC
Parameters:
[
1
]
|
8 | 1.69 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
124
]
|
9 | 1.48 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
11
]
|
10 | 2.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sort AS sort_4, t0.public AS public_5, t0.update_date AS update_date_6 FROM form t0 WHERE t0.public = ?
Parameters:
[
1
]
|
11 | 2.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"home_page_dashboard"
]
|
12 | 2.11 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ? AND t0.public = ? LIMIT 1
Parameters:
[ "11" 1 ] |
13 | 0.82 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
11
]
|
14 | 1.10 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
2335
]
|
15 | 0.95 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
2335
]
|
16 | 0.81 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
2
]
|
17 | 0.66 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
783
]
|
18 | 0.66 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
783
]
|
19 | 0.78 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
10
]
|
20 | 0.61 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
10
]
|
21 | 0.66 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
10
]
|
22 | 1.55 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
61
]
|
23 | 0.76 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
304
]
|
24 | 0.65 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
304
]
|
25 | 0.94 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
3
]
|
26 | 0.72 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
947
]
|
27 | 0.67 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
947
]
|
28 | 1.04 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
4
]
|
29 | 0.68 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
946
]
|
30 | 1.34 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
946
]
|
31 | 0.93 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
5
]
|
32 | 0.74 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
925
]
|
33 | 0.76 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
925
]
|
34 | 0.85 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
6
]
|
35 | 0.77 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
883
]
|
36 | 0.67 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
883
]
|
37 | 0.95 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
7
]
|
38 | 0.63 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
874
]
|
39 | 0.82 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
874
]
|
40 | 0.89 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
8
]
|
41 | 0.65 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
816
]
|
42 | 0.79 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
816
]
|
43 | 0.88 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
9
]
|
44 | 0.79 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
862
]
|
45 | 0.86 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
862
]
|
46 | 0.90 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
91
]
|
47 | 0.69 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
856
]
|
48 | 0.74 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
856
]
|
49 | 1.10 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
99
]
|
50 | 0.66 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
850
]
|
51 | 0.83 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
850
]
|
52 | 2.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"address1"
]
|
53 | 0.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"address2"
]
|
54 | 0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"phone"
]
|
55 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"email"
]
|
56 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"email"
]
|
57 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"personal_data"
]
|
58 | 2.99 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ? AND t0.public = ? LIMIT 1
Parameters:
[ "122" 1 ] |
59 | 0.93 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
122
]
|
60 | 0.90 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
961
]
|
61 | 0.81 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
961
]
|
62 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"legal_mentions"
]
|
63 | 2.82 ms |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ? AND t0.public = ? LIMIT 1
Parameters:
[ "123" 1 ] |
64 | 0.93 ms |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
123
]
|
65 | 1.20 ms |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
1598
]
|
66 | 0.79 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
1598
]
|
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\AbstractPage | No errors. |
App\Entity\PageVersion | No errors. |
App\Entity\Element | No errors. |
App\Entity\ElementType | No errors. |
App\Entity\StaticPage | No errors. |
App\Entity\UserPage | No errors. |
App\Entity\Contract | No errors. |
App\Entity\ContractPage | No errors. |
App\Entity\Service | No errors. |
App\Entity\ServiceCategory | No errors. |
App\Entity\AboutItem | No errors. |
App\Entity\AboutCategory | No errors. |
App\Entity\User | No errors. |
App\Entity\PageVersionAttribute | No errors. |
App\Entity\Form | No errors. |
App\Entity\FormStep | No errors. |
App\Entity\Config | No errors. |