Query Metrics
46
Database Queries
9
Different statements
5.86 ms
Query time
0
Invalid entities
89
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.23 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.flag AS flag_2, s0_.content AS content_3, s0_.content2 AS content2_4, s0_.timeout AS timeout_5, s0_.fade AS fade_6, s0_.bydefault AS bydefault_7, s0_.activ AS activ_8, s0_.priority AS priority_9, c1_.id AS id_10, c1_.title AS title_11, c1_.slug AS slug_12, c1_.lft AS lft_13, c1_.lvl AS lvl_14, c1_.rgt AS rgt_15, c1_.for_visitor AS for_visitor_16, c1_.for_product AS for_product_17, c1_.type AS type_18, c1_.txt_depose AS txt_depose_19, c1_.txt_repose AS txt_repose_20, c1_.txt_install AS txt_install_21, c1_.txt_delivery AS txt_delivery_22, c1_.txt_delivery_new AS txt_delivery_new_23, c1_.txt_time_workshop AS txt_time_workshop_24, c1_.txt_finish AS txt_finish_25, s0_.cat1_id AS cat1_id_26, c1_.root_id AS root_id_27, c1_.parent_id AS parent_id_28, c1_.color_id AS color_id_29 FROM slideshown s0_ LEFT JOIN categoryn c1_ ON s0_.cat1_id = c1_.id WHERE s0_.bydefault = 1 AND s0_.activ = 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.21 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE f0_.parent_type = ? AND f0_.parent_id = ? ORDER BY f0_.priority ASC
Parameters:
[ "slideshow" 1 ]
|
||||||||||||||||||||||||||||
| 3 | 0.21 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activ AS activ_2, w0_.slug AS slug_3, w0_.priority AS priority_4, w1_.id AS id_5, w1_.name AS name_6, w1_.slug AS slug_7, w1_.link AS link_8, w1_.link_title AS link_title_9, w1_.googleDesc AS googleDesc_10, w1_.content AS content_11, w1_.content2 AS content2_12, w1_.timeout AS timeout_13, w1_.fade AS fade_14, w1_.activ AS activ_15, w1_.priority AS priority_16, w1_.main_dealer AS main_dealer_17, w1_.ref_dealer AS ref_dealer_18, w1_.min_price AS min_price_19, w1_.max_price AS max_price_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w1_.cat1_id AS cat1_id_38, w1_.group_id AS group_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_product_groupn w0_ LEFT JOIN web_productn w1_ ON w0_.id = w1_.group_id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 ORDER BY w0_.priority ASC, w1_.priority ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 0.16 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 AND w1_.slug = ?
Parameters:
[
"store-pour-terrasse-jardin"
]
|
||||||||||||||||||||||||||||
| 5 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 17 ]
|
||||||||||||||||||||||||||||
| 6 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 18 ]
|
||||||||||||||||||||||||||||
| 7 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 19 ]
|
||||||||||||||||||||||||||||
| 8 | 0.12 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 AND w1_.slug = ?
Parameters:
[
"store-extrieur-pour-fentre"
]
|
||||||||||||||||||||||||||||
| 9 | 0.13 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 7 ]
|
||||||||||||||||||||||||||||
| 10 | 0.11 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 8 ]
|
||||||||||||||||||||||||||||
| 11 | 0.10 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 9 ]
|
||||||||||||||||||||||||||||
| 12 | 0.15 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 10 ]
|
||||||||||||||||||||||||||||
| 13 | 0.15 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 11 ]
|
||||||||||||||||||||||||||||
| 14 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 12 ]
|
||||||||||||||||||||||||||||
| 15 | 0.12 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 AND w1_.slug = ?
Parameters:
[
"store-intrieur"
]
|
||||||||||||||||||||||||||||
| 16 | 0.14 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 1 ]
|
||||||||||||||||||||||||||||
| 17 | 0.11 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 2 ]
|
||||||||||||||||||||||||||||
| 18 | 0.14 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 3 ]
|
||||||||||||||||||||||||||||
| 19 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 4 ]
|
||||||||||||||||||||||||||||
| 20 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 5 ]
|
||||||||||||||||||||||||||||
| 21 | 0.12 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 6 ]
|
||||||||||||||||||||||||||||
| 22 | 0.12 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 AND w1_.slug = ?
Parameters:
[
"automatisme"
]
|
||||||||||||||||||||||||||||
| 23 | 0.11 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 14 ]
|
||||||||||||||||||||||||||||
| 24 | 0.10 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 15 ]
|
||||||||||||||||||||||||||||
| 25 | 0.09 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 16 ]
|
||||||||||||||||||||||||||||
| 26 | 0.10 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 AND w1_.slug = ?
Parameters:
[
"moustiquaire"
]
|
||||||||||||||||||||||||||||
| 27 | 0.11 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.content AS content_2, f0_.content2 AS content2_3, f0_.creation_date AS creation_date_4, f0_.priority AS priority_5, f0_.parent_type AS parent_type_6, f0_.parent_id AS parent_id_7, f0_.other_url AS other_url_8, f0_.original_name AS original_name_9, f0_.extension AS extension_10, f0_.alt AS alt_11, f0_.sizes AS sizes_12, f0_.width AS width_13, f0_.height AS height_14, f0_.bydefault AS bydefault_15, f0_.lock_name AS lock_name_16, f0_.role AS role_17, f1_.id AS id_18, f1_.title AS title_19, f1_.content AS content_20, f1_.lft AS lft_21, f1_.lvl AS lvl_22, f1_.rgt AS rgt_23, f1_.public_scope AS public_scope_24, f1_.role AS role_25, f1_.slug AS slug_26, f1_.old_slug AS old_slug_27, f0_.folder1_id AS folder1_id_28, f1_.root_id AS root_id_29, f1_.parent_id AS parent_id_30 FROM filen f0_ LEFT JOIN foldern f1_ ON f0_.folder1_id = f1_.id WHERE (f0_.parent_type = ? AND f0_.parent_id = ?) AND f0_.bydefault = 1
Parameters:
[ "web_product" 13 ]
|
||||||||||||||||||||||||||||
| 28 | 0.08 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.title_link AS title_link_3, c0_.content AS content_4, c0_.activ AS activ_5, c0_.center AS center_6, c0_.priority AS priority_7 FROM custompagen c0_ WHERE c0_.activ = 1 ORDER BY c0_.priority ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 29 | 0.26 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activ AS activ_2, w0_.slug AS slug_3, w0_.priority AS priority_4, w1_.id AS id_5, w1_.name AS name_6, w1_.slug AS slug_7, w1_.link AS link_8, w1_.link_title AS link_title_9, w1_.googleDesc AS googleDesc_10, w1_.content AS content_11, w1_.content2 AS content2_12, w1_.timeout AS timeout_13, w1_.fade AS fade_14, w1_.activ AS activ_15, w1_.priority AS priority_16, w1_.main_dealer AS main_dealer_17, w1_.ref_dealer AS ref_dealer_18, w1_.min_price AS min_price_19, w1_.max_price AS max_price_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w1_.cat1_id AS cat1_id_38, w1_.group_id AS group_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_product_groupn w0_ LEFT JOIN web_productn w1_ ON w0_.id = w1_.group_id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 ORDER BY w0_.priority ASC, w1_.priority ASC
Parameters:
[] |
||||||||||||||||||||||||||||
| 30 | 0.16 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
| 31 | 0.12 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 32 | 0.10 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 33 | 0.11 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
| 34 | 0.12 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
| 35 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ral AS ral_3, t0.vsr AS vsr_4, t0.hexa AS hexa_5, t0.pvalue AS pvalue_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
137
]
|
||||||||||||||||||||||||||||
| 36 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ral AS ral_3, t0.vsr AS vsr_4, t0.hexa AS hexa_5, t0.pvalue AS pvalue_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
139
]
|
||||||||||||||||||||||||||||
| 37 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ral AS ral_3, t0.vsr AS vsr_4, t0.hexa AS hexa_5, t0.pvalue AS pvalue_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
136
]
|
||||||||||||||||||||||||||||
| 38 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ral AS ral_3, t0.vsr AS vsr_4, t0.hexa AS hexa_5, t0.pvalue AS pvalue_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
125
]
|
||||||||||||||||||||||||||||
| 39 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ral AS ral_3, t0.vsr AS vsr_4, t0.hexa AS hexa_5, t0.pvalue AS pvalue_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
138
]
|
||||||||||||||||||||||||||||
| 40 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.public_scope AS public_scope_7, t0.role AS role_8, t0.slug AS slug_9, t0.old_slug AS old_slug_10, t0.root_id AS root_id_11, t0.parent_id AS parent_id_12 FROM foldern t0 WHERE t0.id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||
| 41 | 0.15 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activ AS activ_2, w0_.slug AS slug_3, w0_.priority AS priority_4, w1_.id AS id_5, w1_.name AS name_6, w1_.slug AS slug_7, w1_.link AS link_8, w1_.link_title AS link_title_9, w1_.googleDesc AS googleDesc_10, w1_.content AS content_11, w1_.content2 AS content2_12, w1_.timeout AS timeout_13, w1_.fade AS fade_14, w1_.activ AS activ_15, w1_.priority AS priority_16, w1_.main_dealer AS main_dealer_17, w1_.ref_dealer AS ref_dealer_18, w1_.min_price AS min_price_19, w1_.max_price AS max_price_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w1_.cat1_id AS cat1_id_38, w1_.group_id AS group_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_product_groupn w0_ LEFT JOIN web_productn w1_ ON w0_.id = w1_.group_id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w0_.activ = 1 ORDER BY w0_.priority ASC, w1_.priority ASC
Parameters:
[] |
||||||||||||||||||||||||||||
| 42 | 0.11 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
| 43 | 0.11 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 44 | 0.09 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 45 | 0.11 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
| 46 | 0.16 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.link AS link_3, w0_.link_title AS link_title_4, w0_.googleDesc AS googleDesc_5, w0_.content AS content_6, w0_.content2 AS content2_7, w0_.timeout AS timeout_8, w0_.fade AS fade_9, w0_.activ AS activ_10, w0_.priority AS priority_11, w0_.main_dealer AS main_dealer_12, w0_.ref_dealer AS ref_dealer_13, w0_.min_price AS min_price_14, w0_.max_price AS max_price_15, w1_.id AS id_16, w1_.name AS name_17, w1_.activ AS activ_18, w1_.slug AS slug_19, w1_.priority AS priority_20, c2_.id AS id_21, c2_.title AS title_22, c2_.slug AS slug_23, c2_.lft AS lft_24, c2_.lvl AS lvl_25, c2_.rgt AS rgt_26, c2_.for_visitor AS for_visitor_27, c2_.for_product AS for_product_28, c2_.type AS type_29, c2_.txt_depose AS txt_depose_30, c2_.txt_repose AS txt_repose_31, c2_.txt_install AS txt_install_32, c2_.txt_delivery AS txt_delivery_33, c2_.txt_delivery_new AS txt_delivery_new_34, c2_.txt_time_workshop AS txt_time_workshop_35, c2_.txt_finish AS txt_finish_36, w0_.cat1_id AS cat1_id_37, w0_.group_id AS group_id_38, w1_.cat1_id AS cat1_id_39, c2_.root_id AS root_id_40, c2_.parent_id AS parent_id_41, c2_.color_id AS color_id_42 FROM web_productn w0_ LEFT JOIN web_product_groupn w1_ ON w0_.group_id = w1_.id LEFT JOIN categoryn c2_ ON w0_.cat1_id = c2_.id WHERE w1_.id = ? ORDER BY w0_.priority ASC
Parameters:
[
6
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\AD\ExplorerBundle\Entity\File | 30 |
| App\AD\CustomBundle\Entity\Category | 26 |
| App\AD\WebBundle\Entity\Product | 19 |
| App\AD\WebBundle\Entity\ProductGroup | 5 |
| App\AD\CoreBundle\Entity\Color | 5 |
| App\AD\ExplorerBundle\Entity\Folder | 3 |
| App\AD\WebBundle\Entity\Slideshow | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\AD\WebBundle\Entity\Slideshow | No errors. |
| App\AD\WebBundle\Entity\ProductGroup | No errors. |
| App\AD\WebBundle\Entity\Product | No errors. |
| App\AD\WebBundle\Entity\CustomPage | No errors. |
| App\AD\ExplorerBundle\Entity\File | No errors. |
| App\AD\CustomBundle\Entity\Category | No errors. |
| App\AD\CoreBundle\Entity\Color | No errors. |
| App\AD\ExplorerBundle\Entity\Folder | No errors. |
| App\AD\CustomBundle\Entity\Field | No errors. |
| App\AD\CoreBundle\Entity\SwatchColor | No errors. |