Query Metrics

162 Database Queries
24 Different statements
189.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.44 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s1_.slug = ? GROUP BY s0_.id LIMIT 1
Parameters:
[
  "cardiology"
]
2 2.10 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.84 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.sub_category_file_name AS sub_category_file_name_3, t0.sub_category_file_size AS sub_category_file_size_4, t0.sub_category_file_updated_at AS sub_category_file_updated_at_5, t0.sub_category1_file_name AS sub_category1_file_name_6, t0.sub_category1_file_size AS sub_category1_file_size_7, t0.sub_category1_file_updated_at AS sub_category1_file_updated_at_8, t0.hide AS hide_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.category_id AS category_id_12, t0.updator_id AS updator_id_13, t0.creator_id AS creator_id_14 FROM sub_category t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
4 1.15 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  1
]
5 1.37 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 3.01 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  1
]
7 1.99 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
8 1.81 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
9 1.29 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  2
]
10 1.94 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  2
]
11 1.21 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
12 1.23 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
13 1.12 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  4
]
14 1.64 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  4
]
15 1.09 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
16 1.25 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
17 1.17 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  3
]
18 1.79 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  3
]
19 1.36 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
20 1.22 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
21 1.04 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  21
]
22 1.59 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  21
]
23 1.02 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  21
]
24 0.99 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  21
]
25 0.96 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  22
]
26 1.74 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  22
]
27 1.09 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
28 1.11 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
29 0.90 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  2
]
30 0.63 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  6
]
31 1.09 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  6
]
32 0.83 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
33 1.31 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
34 0.65 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  7
]
35 0.86 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  7
]
36 0.67 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
37 0.60 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
38 0.69 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  3
]
39 0.70 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5
]
40 0.88 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.phase_evolution_file_name AS phase_evolution_file_name_3, t0.phase_evolution_file_size AS phase_evolution_file_size_4, t0.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_5, t0.category_icon AS category_icon_6 FROM phase_evolution t0 INNER JOIN product_phase_evolution ON t0.id = product_phase_evolution.phase_evolution_id WHERE product_phase_evolution.product_id = ?
Parameters:
[
  5
]
41 0.60 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_hardware_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
42 0.61 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.product_addon_id AS product_addon_id_4 FROM product_software_product_addon t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
43 0.56 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  4
]
44 0.45 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  5
]
45 1.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM phase_evolution_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
46 0.78 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM phase_evolution_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
47 0.73 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM phase_evolution_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
48 1.97 ms
SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.category_file_name AS category_file_name_2, c0_.category_file_size AS category_file_size_3, c0_.category_file_updated_at AS category_file_updated_at_4, c0_.category1_file_name AS category1_file_name_5, c0_.category1_file_size AS category1_file_size_6, c0_.category1_file_updated_at AS category1_file_updated_at_7, c0_.category_icon_file_name AS category_icon_file_name_8, c0_.category_icon_file_size AS category_icon_file_size_9, c0_.category_icon_file_updated_at AS category_icon_file_updated_at_10, c0_.category_icon1_file_name AS category_icon1_file_name_11, c0_.category_icon1_file_size AS category_icon1_file_size_12, c0_.category_icon1_file_updated_at AS category_icon1_file_updated_at_13, c0_.updated_at AS updated_at_14, c0_.created_at AS created_at_15, c0_.updator_id AS updator_id_16, c0_.creator_id AS creator_id_17 FROM category c0_ ORDER BY c0_.position ASC
Parameters:
[]
49 2.80 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_title_publication AS meta_title_publication_4, t0.meta_description_publication AS meta_description_publication_5, t0.title AS title_6, t0.slug AS slug_7, t0.description AS description_8, t0.h1 AS h1_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
50 1.03 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_title_publication AS meta_title_publication_4, t0.meta_description_publication AS meta_description_publication_5, t0.title AS title_6, t0.slug AS slug_7, t0.description AS description_8, t0.h1 AS h1_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
51 0.81 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_title_publication AS meta_title_publication_4, t0.meta_description_publication AS meta_description_publication_5, t0.title AS title_6, t0.slug AS slug_7, t0.description AS description_8, t0.h1 AS h1_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
52 1.96 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ WHERE s0_.hide = ? ORDER BY s0_.position ASC
Parameters:
[
  0
]
53 1.51 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
54 1.01 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
55 0.97 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
56 0.88 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
57 0.88 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
58 0.91 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
59 0.87 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
60 1.16 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
61 1.07 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
62 1.00 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
63 0.87 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
64 1.08 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  3
]
65 0.64 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  4
]
66 0.57 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  5
]
67 0.59 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  6
]
68 0.56 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  2
]
69 0.55 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  8
]
70 0.53 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  9
]
71 0.71 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  10
]
72 0.58 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  11
]
73 0.58 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  18
]
74 0.67 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  17
]
75 0.51 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  19
]
76 0.58 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  1
]
77 0.62 ms
SELECT t0.id AS id_1, t0.is_hardware AS is_hardware_2, t0.product_addon_file_name AS product_addon_file_name_3, t0.product_addon_file_size AS product_addon_file_size_4, t0.product_addon_file_updated_at AS product_addon_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM product_addon t0 WHERE t0.id = ?
Parameters:
[
  21
]
78 2.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
79 1.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
80 1.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
81 1.01 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
82 1.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
83 1.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
84 0.94 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
85 0.99 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
86 0.93 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
87 0.96 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
88 0.73 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
89 0.73 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
90 0.79 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
91 0.80 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM product_addon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
92 3.88 ms
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.product_file_name AS product_file_name_2, p0_.product_file_size AS product_file_size_3, p0_.product_file_updated_at AS product_file_updated_at_4, p0_.is_hardware AS is_hardware_5, p0_.product1_file_name AS product1_file_name_6, p0_.product1_file_size AS product1_file_size_7, p0_.product1_file_updated_at AS product1_file_updated_at_8, p0_.display_demo_btn AS display_demo_btn_9, p0_.hide AS hide_10, p0_.updated_at AS updated_at_11, p0_.created_at AS created_at_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.updator_id AS updator_id_15, p0_.creator_id AS creator_id_16 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN product_sub_category p2_ ON p0_.id = p2_.product_id LEFT JOIN sub_category s3_ ON p2_.sub_category_id = s3_.id LEFT JOIN product_phase_evolution p5_ ON p0_.id = p5_.product_id LEFT JOIN phase_evolution p4_ ON p4_.id = p5_.phase_evolution_id LEFT JOIN product_hardware_product_addon p6_ ON p0_.id = p6_.product_id LEFT JOIN product_software_product_addon p7_ ON p0_.id = p7_.product_id WHERE p0_.id IS NOT NULL AND p0_.hide = ? AND p2_.sub_category_id IN (?) GROUP BY p0_.id ORDER BY p0_.position ASC LIMIT 9
Parameters:
[
  0
  [
    2
  ]
]
93 2.66 ms
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.product_file_name AS product_file_name_2, p0_.product_file_size AS product_file_size_3, p0_.product_file_updated_at AS product_file_updated_at_4, p0_.is_hardware AS is_hardware_5, p0_.product1_file_name AS product1_file_name_6, p0_.product1_file_size AS product1_file_size_7, p0_.product1_file_updated_at AS product1_file_updated_at_8, p0_.display_demo_btn AS display_demo_btn_9, p0_.hide AS hide_10, p0_.updated_at AS updated_at_11, p0_.created_at AS created_at_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.updator_id AS updator_id_15, p0_.creator_id AS creator_id_16 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN product_sub_category p2_ ON p0_.id = p2_.product_id LEFT JOIN sub_category s3_ ON p2_.sub_category_id = s3_.id LEFT JOIN product_phase_evolution p5_ ON p0_.id = p5_.product_id LEFT JOIN phase_evolution p4_ ON p4_.id = p5_.phase_evolution_id LEFT JOIN product_hardware_product_addon p6_ ON p0_.id = p6_.product_id LEFT JOIN product_software_product_addon p7_ ON p0_.id = p7_.product_id WHERE p0_.id IS NOT NULL AND p0_.hide = ? AND p2_.sub_category_id IN (?) GROUP BY p0_.id ORDER BY p0_.position ASC
Parameters:
[
  0
  [
    2
  ]
]
94 2.03 ms
SELECT t0.id AS id_1, t0.controller AS controller_2, t0.sitemap_file_name AS sitemap_file_name_3, t0.sitemap_file_size AS sitemap_file_size_4, t0.sitemap_file_updated_at AS sitemap_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM page t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\FrontController::products"
]
95 1.85 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
96 0.87 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
97 3.64 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  1
  0
]
98 6.62 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  2
  0
]
99 0.86 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  3
  0
]
100 0.52 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
101 0.43 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  1
  0
]
102 0.86 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
103 1.46 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
104 0.91 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
105 0.72 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
106 0.80 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
107 0.95 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
108 0.91 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
109 0.69 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
110 0.93 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
111 0.69 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
112 0.59 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
113 0.72 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
114 0.56 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
115 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  5
]
116 0.47 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  2
  0
]
117 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
118 0.64 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  12
]
119 0.62 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  9
]
120 0.57 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  15
]
121 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  19
]
122 0.50 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  20
]
123 0.63 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  18
]
124 1.00 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
125 1.11 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
126 1.08 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
127 1.17 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
128 1.03 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
129 0.98 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
130 1.37 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  7
]
131 1.01 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  8
]
132 1.37 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
133 1.21 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  8
]
134 1.14 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  11
]
135 1.41 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
136 1.29 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  9
]
137 1.17 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  13
]
138 1.04 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  14
]
139 2.03 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
140 1.17 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
141 0.63 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  3
  0
]
142 1.51 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  11
]
143 1.27 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  16
]
144 1.80 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
145 1.69 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  12
]
146 1.06 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  17
]
147 0.80 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  23
]
148 1.27 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
149 1.19 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
150 1.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
151 0.93 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
152 0.44 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  1
  0
]
153 0.63 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  2
  0
]
154 0.60 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  3
  0
]
155 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
156 3.04 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  "1"
  0
]
157 1.53 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  "2"
  0
]
158 1.33 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  "3"
  0
]
159 2.20 ms
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.phase_evolution_file_name AS phase_evolution_file_name_2, p0_.phase_evolution_file_size AS phase_evolution_file_size_3, p0_.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_4, p0_.category_icon AS category_icon_5 FROM phase_evolution p0_ WHERE p0_.id IS NOT NULL AND EXISTS (SELECT 1 FROM product_phase_evolution p1_ WHERE p1_.phase_evolution_id = p0_.id AND p1_.product_id IN (?)) ORDER BY p0_.position ASC
Parameters:
[
  6
]
160 1.73 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
161 1.60 ms
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.phase_evolution_file_name AS phase_evolution_file_name_2, p0_.phase_evolution_file_size AS phase_evolution_file_size_3, p0_.phase_evolution_file_updated_at AS phase_evolution_file_updated_at_4, p0_.category_icon AS category_icon_5 FROM phase_evolution p0_ WHERE p0_.id IS NOT NULL AND EXISTS (SELECT 1 FROM product_phase_evolution p1_ WHERE p1_.phase_evolution_id = p0_.id AND p1_.product_id IN (?)) ORDER BY p0_.position ASC
Parameters:
[
  7
]
162 1.64 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.product_id = ?
Parameters:
[
  7
]

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\SubCategory No errors.
App\Entity\SubCategoryTranslation No errors.
App\Entity\Category No errors.
App\Entity\User No errors.
App\Entity\Product No errors.
App\Entity\ProductSubCategory No errors.
App\Entity\ProductParagraph No errors.
App\Entity\Publication No errors.
App\Entity\CategoryPhaseEvolution No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\ProductPublication No errors.
App\Entity\PhaseEvolution No errors.
App\Entity\ProductKeyFeature No errors.
App\Entity\ProductHardwareProductAddon No errors.
App\Entity\ProductSoftwareProductAddon No errors.
App\Entity\ProductProductBrochure No errors.
App\Entity\ProductProductMedia No errors.
App\Entity\ProductProduct No errors.
App\Entity\ProductTranslation No errors.
App\Entity\PhaseEvolutionTranslation No errors.
App\Entity\ProductAddon No errors.
App\Entity\ProductAddonTranslation No errors.
App\Entity\Contact No errors.
App\Entity\Page No errors.
App\Entity\Newsletter No errors.