Query Metrics
41
Database Queries
10
Different statements
851.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.03 ms |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
1
]
|
| 2 | 0.55 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 2.86 ms |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
1
]
|
| 4 | 0.40 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 5 | 0.44 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 6 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 7 | 0.30 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 8 | 0.62 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=50" 1 1 0 ] |
| 9 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 10 | 1.20 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=4" 1 1 0 ] |
| 11 | 0.28 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 12 | 0.60 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=10" 1 1 0 ] |
| 13 | 0.31 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 14 | 1.40 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=203" 1 1 0 ] |
| 15 | 0.39 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 16 | 0.29 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.payment_method AS payment_method_4, t0.shipping_method AS shipping_method_5, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_6, t0.message AS message_7, t0.coupon_code AS coupon_code_8, t0.active AS active_9, t0.abandoned_cart_email AS abandoned_cart_email_10, t0.domain_id AS domain_id_11, t0.customer_id AS customer_id_12, t0.billing_address_id AS billing_address_id_13, t0.shipping_address_id AS shipping_address_id_14 FROM baskets t0 WHERE t0.id IS NULL AND t0.active = ? LIMIT 1
Parameters:
[
1
]
|
| 17 | 0.33 ms |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.updated_by_time AS updated_by_time_3, d0_.type AS type_4, d0_.price AS price_5, d0_.free_ship_limit AS free_ship_limit_6, d0_.active_on_web AS active_on_web_7, d0_.sort_index AS sort_index_8, d0_.shipping_days AS shipping_days_9, d0_.free_shipping_product_types AS free_shipping_product_types_10, d0_.free_shipping_start_date AS free_shipping_start_date_11, d0_.free_shipping_end_date AS free_shipping_end_date_12, d0_.created_by AS created_by_13, d0_.updated_by AS updated_by_14, d0_.domain_id AS domain_id_15 FROM domain_shipping_types d0_ WHERE d0_.domain_id = ? AND d0_.active_on_web = 1 AND d0_.price > 0
Parameters:
[
1
]
|
| 18 | 0.54 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 19 | 0.29 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 20 | 0.47 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=12" 1 1 0 ] |
| 21 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 22 | 0.49 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=13" 1 1 0 ] |
| 23 | 0.33 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 24 | 0.37 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=15" 1 1 0 ] |
| 25 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 26 | 0.56 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "static_id=37" 1 1 0 ] |
| 27 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 28 | 0.38 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 29 | 2.01 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 30 | 4.16 ms |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
1
]
|
| 31 | 1.44 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 32 | 0.32 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
5
]
|
| 33 | 0.38 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.name AS name_5, t0.priority AS priority_6, t0.base_manufacturer_id AS base_manufacturer_id_7 FROM vendors t0 INNER JOIN category_pages_vendors ON t0.id = category_pages_vendors.vendor_id WHERE category_pages_vendors.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
5
]
|
| 34 | 0.66 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.title AS title_5, t0.code AS code_6, t0.scannable AS scannable_7, t0.priority AS priority_8, t0.average_weight AS average_weight_9, t0.archived AS archived_10 FROM product_types t0 INNER JOIN category_pages_product_types ON t0.id = category_pages_product_types.product_type_id WHERE category_pages_product_types.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
5
]
|
| 35 | 437.92 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products__metas p1_ ON p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = ?) WHERE (p7_.id = ? OR p5_.id IS NOT NULL) AND p0_.quality_status <> ? AND p1_.domain_id = ? AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = ? AND p1_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4))
Parameters:
[ 5 5 5 9 1 1 1 ] |
| 36 | 2.87 ms |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
1
]
|
| 37 | 0.29 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 38 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4
]
|
| 39 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.name AS name_5, t0.priority AS priority_6, t0.base_manufacturer_id AS base_manufacturer_id_7 FROM vendors t0 INNER JOIN category_pages_vendors ON t0.id = category_pages_vendors.vendor_id WHERE category_pages_vendors.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
4
]
|
| 40 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.title AS title_5, t0.code AS code_6, t0.scannable AS scannable_7, t0.priority AS priority_8, t0.average_weight AS average_weight_9, t0.archived AS archived_10 FROM product_types t0 INNER JOIN category_pages_product_types ON t0.id = category_pages_product_types.product_type_id WHERE category_pages_product_types.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
4
]
|
| 41 | 382.20 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products__metas p1_ ON p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = ?) WHERE (p7_.id = ? OR p5_.id IS NOT NULL) AND p0_.quality_status <> ? AND p1_.domain_id = ? AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = ? AND p1_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4))
Parameters:
[ 4 4 4 9 1 1 1 ] |
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.