http://www.pruvost-numismatique.com/menu

Query Metrics

46 Database Queries
10 Different statements
30.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.initial_stock AS initial_stock_7, t0.status AS status_8, t0.featured AS featured_9, t0.reassortable AS reassortable_10, t0.km AS km_11, t0.db AS db_12, t0.is_published AS is_published_13, t0.weight AS weight_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.tax_id AS tax_id_17, t0.category_id AS category_id_18 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 3680]
2 2.19 ms
SELECT ABS(p0_.price - ?) AS sclr_0, p0_.id AS id_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.deleted_at AS deleted_at_4, p0_.price AS price_5, p0_.quantity AS quantity_6, p0_.initial_stock AS initial_stock_7, p0_.status AS status_8, p0_.featured AS featured_9, p0_.reassortable AS reassortable_10, p0_.km AS km_11, p0_.db AS db_12, p0_.is_published AS is_published_13, p0_.weight AS weight_14, c1_.id AS id_15, c1_.lft AS lft_16, c1_.lvl AS lvl_17, c1_.rgt AS rgt_18, c1_.root AS root_19, c1_.created_at AS created_at_20, c1_.updated_at AS updated_at_21, c1_.deleted_at AS deleted_at_22, c1_.active AS active_23, p2_.id AS id_24, p2_.title AS title_25, p2_.description AS description_26, p2_.head AS head_27, p2_.reverse AS reverse_28, p2_.comment AS comment_29, p2_.notes AS notes_30, p2_.head_caption AS head_caption_31, p2_.reverse_caption AS reverse_caption_32, p2_.culture AS culture_33, p0_.created_by AS created_by_34, p0_.updated_by AS updated_by_35, p0_.tax_id AS tax_id_36, p0_.category_id AS category_id_37, c1_.parent_id AS parent_id_38, p2_.langage_id AS langage_id_39, p2_.product_id AS product_id_40 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id WHERE c1_.id = ? AND p2_.culture = ? ORDER BY sclr_0 ASC LIMIT 4
Parameters: [0 => 25, 1 => 33, 2 => fr]
3 0.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.head AS head_4, t0.reverse AS reverse_5, t0.comment AS comment_6, t0.notes AS notes_7, t0.head_caption AS head_caption_8, t0.reverse_caption AS reverse_caption_9, t0.culture AS culture_10, t0.langage_id AS langage_id_11, t0.product_id AS product_id_12 FROM product_translation t0 WHERE t0.product_id = ?
Parameters: [0 => 3680]
4 0.64 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.carac_id AS carac_id_5 FROM caracteristic_value t0 INNER JOIN product_caracteristicvalue ON t0.id = product_caracteristicvalue.carac_value_id WHERE product_caracteristicvalue.product_id = ?
Parameters: [0 => 3680]
5 0.49 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 32]
6 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 32]
7 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 200]
8 0.42 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 33]
9 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 33]
10 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 2429]
11 0.37 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 34]
12 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 34]
13 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 6819]
14 0.42 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 39]
15 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 39]
16 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 9433]
17 0.43 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 76]
18 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 76]
19 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 33643]
20 0.42 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 150]
21 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 150]
22 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 56327]
23 0.33 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 159]
24 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 159]
25 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 57326]
26 0.43 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 170]
27 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 170]
28 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 144361]
29 0.41 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.is_book AS is_book_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.parent_id AS parent_id_7 FROM caracteristic t0 WHERE t0.id = ?
Parameters: [0 => 197]
30 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.culture AS culture_3, t0.carac_id AS carac_id_4, t0.langage_id AS langage_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM caracteristic_translation t0 WHERE t0.carac_id = ?
Parameters: [0 => 197]
31 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.sort_order AS sort_order_6, t0.culture AS culture_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.carac_value_id AS carac_value_id_10, t0.langage_id AS langage_id_11 FROM caracteristic_value_translation t0 WHERE t0.carac_value_id = ?
Parameters: [0 => 145663]
32 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_id AS product_id_3 FROM image t0 WHERE t0.product_id = ?
Parameters: [0 => 3680]
33 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.metaTitle AS metaTitle_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.culture AS culture_8, t0.category_id AS category_id_9, t0.langage_id AS langage_id_10 FROM category_translation t0 WHERE t0.category_id = ?
Parameters: [0 => 33]
34 0.94 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 24]
35 0.96 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 19]
36 1.06 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 20]
37 0.98 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 30]
38 0.79 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 1]
39 1.00 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 3]
40 1.00 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 15]
41 1.02 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 16]
42 1.02 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 14]
43 1.26 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 38]
44 1.18 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 43]
45 1.29 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 27]
46 1.29 ms
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 28]

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
BaseBundle\Entity\User No errors.
ProductBundle\Entity\Product No errors.
ProductBundle\Entity\Tax No errors.
ProductBundle\Entity\Category No errors.
ProductBundle\Entity\CaracteristicValue No errors.
ProductBundle\Entity\Image No errors.
ProductBundle\Entity\ProductTranslation No errors.
ProductBundle\Entity\ProductLot No errors.
ProductBundle\Entity\ProductMarket No errors.
ProductBundle\Entity\ServiceToItem No errors.
InvoiceBundle\Entity\OrderItem No errors.
InvoiceBundle\Entity\MarketTransaction No errors.
EbayBundle\Entity\EbayStockAllocator No errors.
InvoiceBundle\Entity\InvoiceItem No errors.
DepositBundle\Entity\DepositItem No errors.
InvoiceBundle\Entity\ItemShipment No errors.
BaseBundle\Entity\Langage No errors.
ProductBundle\Entity\CategoryTranslation No errors.
ProductBundle\Entity\CaracteristicCategory No errors.
ProductBundle\Entity\MarketCategory No errors.
EbayBundle\Entity\MarketStore No errors.
ProductBundle\Entity\Caracteristic No errors.
ProductBundle\Entity\CaracteristicValueTranslation No errors.
ProductBundle\Entity\CaracteristicTranslation No errors.
ProductBundle\Entity\CategoryTitle No errors.
EbayBundle\Entity\CategorySpecifics No errors.