https://www.omall.gebanalysis.cloud/header

Query Metrics

61 Database Queries
13 Different statements
20.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.48 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:
[
  "1"
]
2 0.81 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 = 1 AND p0_.is_published = 1
Parameters:
[]
3 0.45 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 = 1 AND p0_.is_published = 1 LIMIT 10
Parameters:
[]
4 0.51 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.44 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 1.35 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
7 0.95 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
8 0.15 ms
SELECT DATABASE()
Parameters:
[]
9 0.82 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.44 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.13 ms
SELECT DATABASE()
Parameters:
[]
13 0.88 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.19 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.15 ms
SELECT DATABASE()
Parameters:
[]
17 0.31 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.27 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.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:
[
  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.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:
[
  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.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:
[
  22
]
25 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:
[
  23
]
26 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:
[
  3
]
27 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:
[
  36
]
28 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:
[
  37
]
29 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:
[
  4
]
30 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:
[
  45
]
31 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:
[
  46
]
32 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:
[
  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.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:
[
  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.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:
[
  59
]
37 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:
[
  6
]
38 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:
[
  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.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:
[
  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.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:
[
  70
]
44 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:
[
  73
]
45 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:
[
  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.19 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.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:
[
  79
]
50 0.19 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.19 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.19 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.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:
[
  91
]
54 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:
[
  93
]
55 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:
[
  94
]
56 0.19 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.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:
[
  100
]
58 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:
[
  106
]
59 0.19 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.19 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.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:
[
  109
]

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.