https://www.saisimmo.gebanalysis.cloud/account/login-register

Query Metrics

12 Database Queries
8 Different statements
7.05 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.32 ms
(32.93%)
2
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
1.01 ms
(14.32%)
1
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:
[]
0.88 ms
(12.48%)
1
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:
[]
0.75 ms
(10.66%)
1
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:
[]
0.74 ms
(10.55%)
1
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:
[]
0.59 ms
(8.36%)
1
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:
[]
0.53 ms
(7.58%)
4
SELECT DATABASE()
Parameters:
[]
0.22 ms
(3.14%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]

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\Vendor\Vendor No errors.
App\Flexy\ShopBundle\Entity\Customer\Customer No 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\Entity\User No errors.
App\Flexy\ShopBundle\Entity\Product\ImportExcel No errors.
App\Flexy\ShopBundle\Entity\Vendor\deliverycity No errors.
App\Flexy\ShopBundle\Entity\Order\Order No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerGroup No errors.
App\Flexy\ShopBundle\Entity\Product\Comment No errors.
App\Flexy\ShopBundle\Entity\Customer\CustomerAddress No errors.
App\Flexy\ShopBundle\Entity\Order\ReturnOrder 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\Brand No errors.