https://omall.gebanalysis.cloud/shop/search/sideBarFilter

Query Metrics

75 Database Queries
20 Different statements
27.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.id = ?
Parameters:
[
  "24"
]
2 0.69 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id WHERE f3_.id = 24 AND p0_.is_published = 1
Parameters:
[]
3 0.39 ms
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id WHERE f3_.id = 24 AND p0_.is_published = 1 LIMIT 10
Parameters:
[]
4 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id IS NULL
Parameters:
[]
5 0.36 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.lien AS lien_3, t0.emplacement AS emplacement_4, t0.is_enabled AS is_enabled_5, t0.is_text_white AS is_text_white_6, t0.petit_titre AS petit_titre_7, t0.grand_titre AS grand_titre_8, t0.texte_prix AS texte_prix_9, t0.titre_btn AS titre_btn_10 FROM pub_banner t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
6 2.05 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
7 1.63 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
8 0.17 ms
SELECT DATABASE()
Parameters:
[]
9 1.11 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'gebcloud_omall' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
10 0.14 ms
SELECT DATABASE()
Parameters:
[]
11 1.35 ms
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'gebcloud_omall' /*!50116 AND c.CONSTRAINT_SCHEMA = 'gebcloud_omall' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
12 0.12 ms
SELECT DATABASE()
Parameters:
[]
13 0.87 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'gebcloud_omall' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
14 1.14 ms
SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
15 0.26 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
16 0.14 ms
SELECT DATABASE()
Parameters:
[]
17 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  1
]
18 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  10
]
19 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  14
]
20 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  18
]
21 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  2
]
22 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  20
]
23 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  21
]
24 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  22
]
25 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  23
]
26 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  3
]
27 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  36
]
28 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  37
]
29 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  4
]
30 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  45
]
31 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  46
]
32 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  47
]
33 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  5
]
34 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  57
]
35 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  58
]
36 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  59
]
37 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  6
]
38 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  64
]
39 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  65
]
40 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  7
]
41 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  66
]
42 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  67
]
43 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  70
]
44 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  73
]
45 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  74
]
46 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  75
]
47 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  76
]
48 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  77
]
49 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  79
]
50 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  85
]
51 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  86
]
52 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  87
]
53 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  91
]
54 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  93
]
55 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  94
]
56 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  99
]
57 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  100
]
58 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  106
]
59 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  107
]
60 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  108
]
61 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id = ?
Parameters:
[
  109
]
62 0.81 ms
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id INNER JOIN product_category_product ON t0.id = product_category_product.product_id WHERE product_category_product.category_product_id = ?
Parameters:
[
  24
]
63 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_certimage AS path_certimage_17, t0.path_cvimage AS path_cvimage_18, t0.path_rcimage AS path_rcimage_19, t0.path_ice_image AS path_ice_image_20, t0.path_ifimage AS path_ifimage_21, t0.identifiant_fiscale AS identifiant_fiscale_22, t0.identity_card AS identity_card_23, t0.bank_details AS bank_details_24, t0.address_collecte AS address_collecte_25, t0.delivery_intra AS delivery_intra_26, t0.delivery_inter AS delivery_inter_27, t0.limited_amount AS limited_amount_28, t0.num_rib AS num_rib_29, t0.user_id AS user_id_30 FROM vendor t0 WHERE t0.id = ?
Parameters:
[
  1
]
64 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  1
]
65 0.32 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.name AS name_4, t0.type AS type_5 FROM attribut t0
Parameters:
[]
66 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM brand t0 ORDER BY t0.name ASC
Parameters:
[]
67 0.35 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.attribut_id AS attribut_id_7, t0.product_id AS product_id_8 FROM attribut_value t0 WHERE t0.attribut_id = ?
Parameters:
[
  1
]
68 0.39 ms
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  1
]
69 0.34 ms
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  2
]
70 0.33 ms
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  11
]
71 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.attribut_id AS attribut_id_7, t0.product_id AS product_id_8 FROM attribut_value t0 WHERE t0.attribut_id = ?
Parameters:
[
  2
]
72 0.33 ms
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  7
]
73 0.22 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.attribut_id AS attribut_id_7, t0.product_id AS product_id_8 FROM attribut_value t0 WHERE t0.attribut_id = ?
Parameters:
[
  3
]
74 0.20 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.attribut_id AS attribut_id_7, t0.product_id AS product_id_8 FROM attribut_value t0 WHERE t0.attribut_id = ?
Parameters:
[
  4
]
75 0.21 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.attribut_id AS attribut_id_7, t0.product_id AS product_id_8 FROM attribut_value t0 WHERE t0.attribut_id = ?
Parameters:
[
  5
]

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\Flexy\ShopBundle\Entity\Product\CategoryProduct No errors.
App\Flexy\ShopBundle\Entity\Product\Product No errors.
App\Flexy\ShopBundle\Entity\Product\Attribut No errors.
App\Flexy\StockBundle\Entity\Article No errors.
App\Flexy\ShopBundle\Entity\Product\ProductShop No errors.
App\Flexy\FrontBundle\Entity\PubBanner No errors.
App\Flexy\ShopBundle\Entity\Product\AttributValue No errors.
App\Flexy\ShopBundle\Entity\Product\ImageProduct No errors.
App\Flexy\ShopBundle\Entity\Product\ProductVariant No errors.
App\Flexy\ShopBundle\Entity\Order\OrderItem No errors.
App\Flexy\ShopBundle\Entity\Promotion\Promotion No errors.
App\Flexy\ShopBundle\Entity\Vendor\Vendor No errors.
App\Flexy\ShopBundle\Entity\Brand No errors.
App\Flexy\ShopBundle\Entity\Product\Comment No errors.
App\Flexy\ShopBundle\Entity\Customer\Customer No errors.
App\Flexy\StockBundle\Entity\Stock No errors.
App\Flexy\ShopBundle\Entity\Order\Order No errors.
App\Flexy\ShopBundle\Entity\Promotion\Coupon No errors.
App\Flexy\ShopBundle\Entity\Promotion\PromotionRule No errors.
App\Flexy\ShopBundle\Entity\Promotion\PromotionAction No errors.
App\Entity\User No errors.
App\Flexy\ShopBundle\Entity\Product\ImportExcel No errors.
App\Flexy\ShopBundle\Entity\Vendor\deliverycity No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerGroup No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerAddress No errors.
App\Flexy\ShopBundle\Entity\Order\ReturnOrder No errors.
App\Flexy\StockBundle\Entity\Document No errors.