https://esorus-shop.woodenizr.com/

Query Metrics

46 Database Queries
20 Different statements
52.98 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.02 ms
SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.created AS created_4, t0.creator AS creator_5, t0.modified AS modified_6, t0.modified_by AS modified_by_7 FROM redirect_404 t0 WHERE t0.`from` = ? LIMIT 1
Parameters:
[
  "https://esorus-shop.woodenizr.com/"
]
2 1.53 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.brief AS brief_2, s0_.type AS type_3, s0_.created AS created_4, s0_.creator AS creator_5, s0_.modified AS modified_6, s0_.modified_by AS modified_by_7, s1_.title AS title_8, s1_.slug AS slug_9, s1_.meta_description AS meta_description_10, s1_.focus_keyword AS focus_keyword_11, s1_.meta_keyword AS meta_keyword_12, s1_.meta_tags AS meta_tags_13, s1_.state AS state_14, s1_.last_modified AS last_modified_15, s1_.deleted AS deleted_16, s1_.id AS id_17, s2_.title AS title_18, s2_.slug AS slug_19, s2_.meta_description AS meta_description_20, s2_.focus_keyword AS focus_keyword_21, s2_.meta_keyword AS meta_keyword_22, s2_.meta_tags AS meta_tags_23, s2_.state AS state_24, l3_.id AS id_25, l3_.locale AS locale_26, l3_.title AS title_27, l3_.flag_asset AS flag_asset_28, s4_.id AS id_29, s4_.title AS title_30, s4_.description AS description_31, s4_.image_url AS image_url_32, s4_.social_network AS social_network_33, s0_.seo_id AS seo_id_34, s1_.seo_base_route_id AS seo_base_route_id_35, s2_.translatable_id AS translatable_id_36, s2_.language_id AS language_id_37 FROM seo_page s0_ LEFT JOIN seo s1_ ON s0_.seo_id = s1_.id LEFT JOIN seo_translations s2_ ON s1_.id = s2_.translatable_id LEFT JOIN language l3_ ON s2_.language_id = l3_.id LEFT JOIN seo_seo_social s5_ ON s1_.id = s5_.seo_id LEFT JOIN seo_social s4_ ON s4_.id = s5_.seo_social_id WHERE s0_.type = ?
Parameters:
[
  "home-page"
]
3 1.67 ms
SELECT -b0_.tarteb AS sclr_0, b0_.id AS id_1, b0_.title AS title_2, b0_.sub_title AS sub_title_3, b0_.placement AS placement_4, b0_.placementName AS placementName_5, b0_.url AS url_6, b0_.text AS text_7, b0_.action_button_name AS action_button_name_8, b0_.action_button_position AS action_button_position_9, b0_.tarteb AS tarteb_10, b0_.publish AS publish_11, b0_.openInNewTab AS openInNewTab_12, b0_.created AS created_13, b0_.creator AS creator_14, b0_.modified AS modified_15, b0_.modified_by AS modified_by_16, i1_.name AS name_17, i1_.base_path AS base_path_18, i1_.alt AS alt_19, i1_.width AS width_20, i1_.height AS height_21, i1_.size AS size_22, i1_.tarteb AS tarteb_23, i1_.image_type AS image_type_24, i1_.created AS created_25, i1_.id AS id_26, b2_.title AS title_27, b2_.sub_title AS sub_title_28, b2_.url AS url_29, b2_.text AS text_30, b2_.actionButton AS actionButton_31, l3_.id AS id_32, l3_.locale AS locale_33, l3_.title AS title_34, l3_.flag_asset AS flag_asset_35, b0_.image_id AS image_id_36, b2_.translatable_id AS translatable_id_37, b2_.language_id AS language_id_38 FROM banner b0_ LEFT JOIN image i1_ ON b0_.image_id = i1_.id LEFT JOIN banner_translations b2_ ON b0_.id = b2_.translatable_id LEFT JOIN language l3_ ON b2_.language_id = l3_.id WHERE b0_.image_id IS NOT NULL AND b0_.placement = ? AND b0_.publish = ? ORDER BY RAND() ASC LIMIT 6
Parameters:
[
  1
  1
]
4 0.61 ms
SELECT DATABASE()
Parameters:
[]
5 2.28 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
6 0.31 ms
SELECT DATABASE()
Parameters:
[]
7 1.52 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
8 0.38 ms
SELECT DATABASE()
Parameters:
[]
9 2.22 ms
SELECT t.TABLE_NAME,
           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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
10 0.29 ms
SELECT DATABASE()
Parameters:
[]
11 2.59 ms
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!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_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'esorus_db' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
12 3.73 ms
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'esorus_db'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "esorus_db"
  "esorus_db"
  "doctrine_migration_versions"
]
13 0.55 ms
SELECT DATABASE()
Parameters:
[]
14 0.79 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_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
15 1.08 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
16 0.72 ms
SELECT DATABASE()
Parameters:
[]
17 1.04 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  8
]
18 0.80 ms
SELECT t0.name AS name_1, t0.base_path AS base_path_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.tarteb AS tarteb_7, t0.image_type AS image_type_8, t0.created AS created_9, t0.id AS id_10 FROM image t0 INNER JOIN dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  8
]
19 0.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  11
]
20 0.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  12
]
21 0.50 ms
SELECT t0.name AS name_1, t0.base_path AS base_path_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.tarteb AS tarteb_7, t0.image_type AS image_type_8, t0.created AS created_9, t0.id AS id_10 FROM image t0 INNER JOIN dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  12
]
22 0.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  13
]
23 0.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  14
]
24 0.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  15
]
25 0.47 ms
SELECT t0.name AS name_1, t0.base_path AS base_path_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.tarteb AS tarteb_7, t0.image_type AS image_type_8, t0.created AS created_9, t0.id AS id_10 FROM image t0 INNER JOIN dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  15
]
26 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  16
]
27 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  17
]
28 1.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  18
]
29 1.00 ms
SELECT t0.name AS name_1, t0.base_path AS base_path_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.tarteb AS tarteb_7, t0.image_type AS image_type_8, t0.created AS created_9, t0.id AS id_10 FROM image t0 INNER JOIN dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  18
]
30 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  19
]
31 0.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  20
]
32 1.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  2
]
33 0.91 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  1
]
34 0.94 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  3
]
35 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  4
]
36 0.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  5
]
37 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  6
]
38 0.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  7
]
39 1.23 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.code AS code_2, c0_.symbol AS symbol_3, c0_.`default` AS default_4, c0_.deleted AS deleted_5, c0_.deleted_by AS deleted_by_6, c0_.created AS created_7, c0_.creator AS creator_8, c0_.modified AS modified_9, c0_.modified_by AS modified_by_10, c1_.title AS title_11, c1_.symbol AS symbol_12, l2_.id AS id_13, l2_.locale AS locale_14, l2_.title AS title_15, l2_.flag_asset AS flag_asset_16, c1_.translatable_id AS translatable_id_17, c1_.language_id AS language_id_18 FROM currency c0_ LEFT JOIN currency_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN language l2_ ON c1_.language_id = l2_.id WHERE c0_.`default` = ? AND c0_.deleted IS NULL GROUP BY c0_.id LIMIT 1
Parameters:
[
  1
]
40 8.95 ms
SELECT c0_.id AS id_0, c0_.created AS created_1, c1_.cookie AS cookie_2, c2_.name AS name_3, c2_.email AS email_4, c2_.address AS address_5, c2_.mobile_number AS mobile_number_6, c3_.qty AS qty_7, c3_.created AS created_8, c3_.modified AS modified_9, s4_.id AS id_10, s4_.name AS name_11, s4_.number_of_delivery_days AS number_of_delivery_days_12, s4_.deleted AS deleted_13, s5_.id AS id_14, s5_.`default` AS default_15, s5_.title AS title_16, s5_.note AS note_17, s5_.mobile_number AS mobile_number_18, s5_.full_address AS full_address_19, s5_.deleted AS deleted_20, s5_.deleted_by AS deleted_by_21, s5_.created AS created_22, s5_.creator AS creator_23, s5_.modified AS modified_24, s5_.modified_by AS modified_by_25, c6_.id AS id_26, c6_.code AS code_27, c6_.comment AS comment_28, c6_.description AS description_29, c6_.discount_type AS discount_type_30, c6_.discount_value AS discount_value_31, c6_.start_date AS start_date_32, c6_.expiry_date AS expiry_date_33, c6_.minimum_purchase_amount AS minimum_purchase_amount_34, c6_.limit_use_per_user AS limit_use_per_user_35, c6_.total_number_of_use AS total_number_of_use_36, c6_.add_discount_after_product_discount AS add_discount_after_product_discount_37, c6_.free_payment_method_fee AS free_payment_method_fee_38, c6_.first_order_only AS first_order_only_39, c6_.active AS active_40, c6_.shipping AS shipping_41, c6_.deleted AS deleted_42, c6_.deleted_by AS deleted_by_43, c6_.created AS created_44, c6_.creator AS creator_45, c6_.modified AS modified_46, c6_.modified_by AS modified_by_47, p7_.id AS id_48, p7_.title AS title_49, p7_.note AS note_50, p7_.type AS type_51, p7_.active AS active_52, p7_.fees AS fees_53, p7_.deleted AS deleted_54, p7_.deleted_by AS deleted_by_55, p7_.created AS created_56, p7_.creator AS creator_57, p7_.modified AS modified_58, p7_.modified_by AS modified_by_59, c0_.payment_method_id AS payment_method_id_60, c0_.coupon_id AS coupon_id_61, c0_.shipping_address_id AS shipping_address_id_62, c8_.cart_id AS cart_id_63, c8_.user_id AS user_id_64, c1_.cart_id AS cart_id_65, c2_.cart_id AS cart_id_66, c2_.zone_id AS zone_id_67, c3_.cart_id AS cart_id_68, c3_.product_price_id AS product_price_id_69, c3_.shipping_time_id AS shipping_time_id_70, s5_.user_id AS user_id_71, s5_.zone_id AS zone_id_72, p7_.image_id AS image_id_73 FROM cart c0_ LEFT JOIN cart_has_user c8_ ON c0_.id = c8_.cart_id LEFT JOIN cart_has_cookie c1_ ON c0_.id = c1_.cart_id LEFT JOIN cart_guest_data c2_ ON c0_.id = c2_.cart_id LEFT JOIN cart_has_product_price c3_ ON c0_.id = c3_.cart_id LEFT JOIN shipping_time s4_ ON c3_.shipping_time_id = s4_.id LEFT JOIN shipping_address s5_ ON c0_.shipping_address_id = s5_.id LEFT JOIN coupon c6_ ON c0_.coupon_id = c6_.id LEFT JOIN payment_method p7_ ON c0_.payment_method_id = p7_.id WHERE c1_.cookie = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "9769c27102bf879a5149fba1e2f8e10e"
]
41 0.67 ms
"START TRANSACTION"
Parameters:
[]
42 0.83 ms
INSERT INTO cart (created, payment_method_id, coupon_id, shipping_address_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "2026-03-06 06:49:53"
  null
  null
  null
]
43 0.33 ms
INSERT INTO cart_has_cookie (cookie, cart_id) VALUES (?, ?)
Parameters:
[
  "9769c27102bf879a5149fba1e2f8e10e"
  2329
]
44 1.40 ms
"COMMIT"
Parameters:
[]
45 1.29 ms
SELECT c0_.qty AS qty_0, c0_.created AS created_1, c0_.modified AS modified_2, c1_.id AS id_3, c1_.created AS created_4, p2_.id AS id_5, p2_.title AS title_6, p2_.stock AS stock_7, p2_.unit_price AS unit_price_8, p2_.promotional_price AS promotional_price_9, p2_.weight AS weight_10, p2_.promotional_expiry_date AS promotional_expiry_date_11, p2_.variant_option_ids AS variant_option_ids_12, p2_.deleted AS deleted_13, p2_.deleted_by AS deleted_by_14, p2_.created AS created_15, p2_.creator AS creator_16, p2_.modified AS modified_17, p2_.modified_by AS modified_by_18, p3_.id AS id_19, p3_.title AS title_20, p3_.sku AS sku_21, p3_.tarteb AS tarteb_22, p3_.search_terms AS search_terms_23, p3_.normalized_text AS normalized_text_24, p3_.featured AS featured_25, p3_.new_arrival AS new_arrival_26, p3_.enable_variants AS enable_variants_27, p3_.publish AS publish_28, p3_.deleted AS deleted_29, p3_.deleted_by AS deleted_by_30, p3_.created AS created_31, p3_.creator AS creator_32, p3_.modified AS modified_33, p3_.modified_by AS modified_by_34, p3_.uuid AS uuid_35, c0_.cart_id AS cart_id_36, c0_.product_price_id AS product_price_id_37, c0_.shipping_time_id AS shipping_time_id_38, c1_.payment_method_id AS payment_method_id_39, c1_.coupon_id AS coupon_id_40, c1_.shipping_address_id AS shipping_address_id_41, p2_.product_id AS product_id_42, p2_.currency_id AS currency_id_43, p3_.seo_id AS seo_id_44, p3_.post_id AS post_id_45, p3_.category_id AS category_id_46, p3_.vendor_id AS vendor_id_47, p3_.store_address_id AS store_address_id_48, p3_.brand_id AS brand_id_49, p3_.currency_id AS currency_id_50, p3_.main_image_id AS main_image_id_51, p3_.three_sixty_view_id AS three_sixty_view_id_52 FROM cart_has_product_price c0_ LEFT JOIN cart c1_ ON c0_.cart_id = c1_.id LEFT JOIN product_price p2_ ON c0_.product_price_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.cart_id = ? AND p3_.publish = 1 AND p2_.deleted IS NULL AND p3_.deleted IS NULL
Parameters:
[
  2329
]
46 1.36 ms
SELECT GREATEST(COALESCE(MAX(c0_.created), 0), c1_.created) AS sclr_0 FROM cart c1_ LEFT JOIN cart_has_product_price c0_ ON c1_.id = c0_.cart_id WHERE c1_.id = ? LIMIT 1
Parameters:
[
  2329
]

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
PN\SeoBundle\Entity\Redirect404 No errors.
PN\SeoBundle\Entity\SeoPage No errors.
App\SeoBundle\Entity\Seo No errors.
PN\SeoBundle\Entity\Translation\SeoTranslation No errors.
App\SeoBundle\Entity\Translation\SeoTranslation No errors.
PN\LocaleBundle\Entity\Language No errors.
PN\SeoBundle\Entity\SeoSocial No errors.
PN\SeoBundle\Entity\SeoBaseRoute No errors.
PN\SeoBundle\Entity\Translation\SeoPageTranslation No errors.
App\CMSBundle\Entity\Banner No errors.
App\MediaBundle\Entity\Image No errors.
App\CMSBundle\Entity\Translation\BannerTranslation No errors.
PN\SeoBundle\Entity\Translation\SeoSocialTranslation No errors.
PN\ContentBundle\Entity\Post No errors.
App\ContentBundle\Entity\Post No errors.
PN\ContentBundle\Entity\Translation\PostTranslation No errors.
App\ContentBundle\Entity\Translation\PostTranslation No errors.
PN\ContentBundle\Entity\DynamicContentAttribute No errors.
PN\ContentBundle\Entity\DynamicContent No errors.
PN\ContentBundle\Entity\Translation\DynamicContentAttributeTranslation No errors.
App\MediaBundle\Entity\Document No errors.
App\CurrencyBundle\Entity\Currency No errors.
App\CurrencyBundle\Entity\Translation\CurrencyTranslation No errors.
App\ECommerceBundle\Entity\Cart No errors.
App\ECommerceBundle\Entity\CartHasUser No errors.
App\ECommerceBundle\Entity\CartHasCookie No errors.
App\ECommerceBundle\Entity\CartGuestData No errors.
App\ECommerceBundle\Entity\CartHasProductPrice No errors.
App\NewShippingBundle\Entity\ShippingTime No errors.
App\ShippingBundle\Entity\ShippingAddress No errors.
App\ECommerceBundle\Entity\Coupon No errors.
App\OnlinePaymentBundle\Entity\PaymentMethod No errors.
App\UserBundle\Entity\User No errors.
App\NewShippingBundle\Entity\Zone No errors.
App\ProductBundle\Entity\ProductPrice No errors.
App\ProductBundle\Entity\Product No errors.
App\ProductBundle\Entity\Category No errors.
App\VendorBundle\Entity\Vendor No errors.
App\VendorBundle\Entity\StoreAddress No errors.
App\ProductBundle\Entity\Brand No errors.
App\ThreeSixtyViewBundle\Entity\ThreeSixtyView No errors.
App\NewShippingBundle\Entity\ShippingZonePrice No errors.
App\NewShippingBundle\Entity\Translation\ShippingTimeTranslation No errors.
App\ECommerceBundle\Entity\CouponHasProduct No errors.
App\OnlinePaymentBundle\Entity\Translation\PaymentMethodTranslation No errors.
App\NewShippingBundle\Entity\ShippingZone No errors.
App\NewShippingBundle\Entity\Translation\ZoneTranslation No errors.
App\ProductBundle\Entity\ProductFavorite No errors.
App\ProductBundle\Entity\Translation\ProductTranslation No errors.
App\ProductBundle\Entity\ProductDetails No errors.
App\ProductBundle\Entity\ProductHasAttribute No errors.
App\ProductBundle\Entity\ProductHasCollection No errors.
App\ProductBundle\Entity\ProductHasOccasion No errors.
App\ProductBundle\Entity\Translation\CategoryTranslation No errors.
App\ProductBundle\Entity\Attribute No errors.
App\VendorBundle\Entity\Translation\VendorTranslation No errors.
App\ProductBundle\Entity\Translation\BrandTranslation No errors.