Query Metrics
63
Database Queries
23
Different statements
883.94 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.63 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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"pc-internal-cable-hp-for-600-g3-800-g3-dm-sata-hard-drive-cable-pn-35006n040001-35006n040011-2790009"
]
|
| 2 | 0.24 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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 36.18 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.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "pc-internal-cable-hp-for-600-g3-800-g3-dm-sata-hard-drive-cable-pn-35006n040001-35006n040011-2790009" 1 0 1 null ] |
| 4 | 3.09 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
]
|
| 5 | 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
]
|
| 6 | 0.27 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 | 2.01 ms |
SELECT p0_.id AS id_0, p0_.available AS available_1, p1_.orderable AS orderable_2, p1_.active AS active_3, p1_.discounted AS discounted_4, c2_.id AS id_5, c2_.show_badge_on_website AS show_badge_on_website_6 FROM products p0_ LEFT JOIN products__metas p1_ ON (p1_.product_id = p0_.id AND p1_.domain_id = ?) LEFT JOIN coupons c2_ ON (EXISTS (SELECT 1 FROM coupons__products c3_ WHERE c3_.coupon_id = c2_.id AND c3_.product_id IN (?)) AND c2_.domain_id = ? AND c2_.enabled = 1 AND c2_.valid_form <= ? AND (c2_.valid_to IS NULL OR c2_.valid_to >= ?)) WHERE p0_.id = ?
Parameters:
[ 1 27734 1 "2026-10-10 14:36:41" "2026-10-10 14:36:41" 27734 ] |
| 8 | 0.42 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.omega_plu AS omega_plu_5, t0.code AS code_6, t0.name AS name_7, t0.warranty AS warranty_8, t0.part_number AS part_number_9, t0.ean AS ean_10, t0.gtin AS gtin_11, t0.amazon_code AS amazon_code_12, t0.length AS length_13, t0.width AS width_14, t0.height AS height_15, t0.weight AS weight_16, t0.unit AS unit_17, t0.badges AS badges_18, t0.detail AS detail_19, t0.stock_position AS stock_position_20, t0.out_of_stock_status AS out_of_stock_status_21, t0.quality_status AS quality_status_22, t0.sold_out_date AS sold_out_date_23, t0.cache_description AS cache_description_24, t0.cache_item_last_updated AS cache_item_last_updated_25, t0.available AS available_26, t0.in_stock AS in_stock_27, t0.archived AS archived_28, t0.scannable AS scannable_29, t0.last_price AS last_price_30, t0.avg_price AS avg_price_31, t0.container AS container_32, t0.last_sale AS last_sale_33, t0.cpu_mark AS cpu_mark_34, t0.spare_part_card AS spare_part_card_35, t0.spare_part_price AS spare_part_price_36, t0.sold_during_time_frame AS sold_during_time_frame_37, t0.spare_part_created AS spare_part_created_38, t0.spare_part_updated AS spare_part_updated_39, t0.margin_level AS margin_level_40, t0.quantity_limit AS quantity_limit_41, t0.availability_paused_for_product_model AS availability_paused_for_product_model_42, t0.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_43, t0.calculated_qty_grade_new AS calculated_qty_grade_new_44, t0.calculated_qty_grade_a AS calculated_qty_grade_a_45, t0.calculated_qty_grade_b AS calculated_qty_grade_b_46, t0.calculated_qty_grade_c AS calculated_qty_grade_c_47, t0.calculated_qty_grade_d AS calculated_qty_grade_d_48, t0.calculated_qty_date AS calculated_qty_date_49, t0.created_by AS created_by_50, t0.updated_by AS updated_by_51, t0.vendor_id AS vendor_id_52, t0.type_id AS type_id_53, t0.photo_album_id AS photo_album_id_54, t0.current_alternative_product_id AS current_alternative_product_id_55, t0.product_model_id AS product_model_id_56, t0.spare_part_created_by AS spare_part_created_by_57, t0.spare_part_updated_by AS spare_part_updated_by_58, t0.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59 FROM products t0 WHERE t0.id = ?
Parameters:
[
27734
]
|
| 9 | 0.41 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 | 44.07 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.archived = ? LIMIT 1
Parameters:
[ "product_id=27734" 1 0 ] |
| 11 | 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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 12 | 0.56 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
]
|
| 13 | 0.98 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=79" 1 1 0 ] |
| 14 | 0.44 ms |
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.visitor AS visitor_3, c0_.type AS type_4, c0_.email AS email_5, c0_.name AS name_6, c0_.price AS price_7, c0_.source_price AS source_price_8, c0_.notified_price AS notified_price_9, c0_.notified AS notified_10, c0_.unsubscribe_key AS unsubscribe_key_11, c0_.domain_id AS domain_id_12, c0_.customer_id AS customer_id_13, c0_.product_id AS product_id_14, c0_.order_id AS order_id_15 FROM customers__notification c0_ WHERE c0_.product_id = ? AND c0_.domain_id = ?
Parameters:
[ 27734 1 ] |
| 15 | 5.55 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
]
|
| 16 | 0.49 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
]
|
| 17 | 2.53 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
]
|
| 18 | 0.57 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.67 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 20 | 0.36 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
]
|
| 21 | 0.50 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.91 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 ] |
| 23 | 0.69 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 | 3.77 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 ] |
| 25 | 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
]
|
| 26 | 0.41 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 ] |
| 27 | 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
]
|
| 28 | 1.43 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 ] |
| 29 | 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
]
|
| 30 | 1.06 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
]
|
| 31 | 0.34 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
]
|
| 32 | 44.95 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.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "pc-internal-cable-hp-for-600-g3-800-g3-dm-sata-hard-drive-cable-pn-35006n040001-35006n040011-2790009" 1 0 1 null ] |
| 33 | 0.61 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.omega_plu AS omega_plu_5, t0.code AS code_6, t0.name AS name_7, t0.warranty AS warranty_8, t0.part_number AS part_number_9, t0.ean AS ean_10, t0.gtin AS gtin_11, t0.amazon_code AS amazon_code_12, t0.length AS length_13, t0.width AS width_14, t0.height AS height_15, t0.weight AS weight_16, t0.unit AS unit_17, t0.badges AS badges_18, t0.detail AS detail_19, t0.stock_position AS stock_position_20, t0.out_of_stock_status AS out_of_stock_status_21, t0.quality_status AS quality_status_22, t0.sold_out_date AS sold_out_date_23, t0.cache_description AS cache_description_24, t0.cache_item_last_updated AS cache_item_last_updated_25, t0.available AS available_26, t0.in_stock AS in_stock_27, t0.archived AS archived_28, t0.scannable AS scannable_29, t0.last_price AS last_price_30, t0.avg_price AS avg_price_31, t0.container AS container_32, t0.last_sale AS last_sale_33, t0.cpu_mark AS cpu_mark_34, t0.spare_part_card AS spare_part_card_35, t0.spare_part_price AS spare_part_price_36, t0.sold_during_time_frame AS sold_during_time_frame_37, t0.spare_part_created AS spare_part_created_38, t0.spare_part_updated AS spare_part_updated_39, t0.margin_level AS margin_level_40, t0.quantity_limit AS quantity_limit_41, t0.availability_paused_for_product_model AS availability_paused_for_product_model_42, t0.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_43, t0.calculated_qty_grade_new AS calculated_qty_grade_new_44, t0.calculated_qty_grade_a AS calculated_qty_grade_a_45, t0.calculated_qty_grade_b AS calculated_qty_grade_b_46, t0.calculated_qty_grade_c AS calculated_qty_grade_c_47, t0.calculated_qty_grade_d AS calculated_qty_grade_d_48, t0.calculated_qty_date AS calculated_qty_date_49, t0.created_by AS created_by_50, t0.updated_by AS updated_by_51, t0.vendor_id AS vendor_id_52, t0.type_id AS type_id_53, t0.photo_album_id AS photo_album_id_54, t0.current_alternative_product_id AS current_alternative_product_id_55, t0.product_model_id AS product_model_id_56, t0.spare_part_created_by AS spare_part_created_by_57, t0.spare_part_updated_by AS spare_part_updated_by_58, t0.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59 FROM products t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
27734
]
|
| 34 | 0.46 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.price AS price_4, t0.suggested_price AS suggested_price_5, t0.current_vat_price AS current_vat_price_6, t0.discount AS discount_7, t0.discounted AS discounted_8, t0.active AS active_9, t0.listed AS listed_10, t0.orderable AS orderable_11, t0.vat AS vat_12, t0.warranty AS warranty_13, t0.bazaar AS bazaar_14, t0.best_seller AS best_seller_15, t0.re_lenovo AS re_lenovo_16, t0.hp_renew AS hp_renew_17, t0.special_promotion AS special_promotion_18, t0.detail AS detail_19, t0.sale_start AS sale_start_20, t0.sale_end AS sale_end_21, t0.activation_date AS activation_date_22, t0.discounted_date AS discounted_date_23, t0.flash_sale_date AS flash_sale_date_24, t0.domain_id AS domain_id_25, t0.product_id AS product_id_26 FROM products__metas t0 WHERE t0.product_id = ?
Parameters:
[
27734
]
|
| 35 | 0.36 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 = ?
Parameters:
[
2
]
|
| 36 | 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 = ?
Parameters:
[
4
]
|
| 37 | 0.27 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 = ?
Parameters:
[
5
]
|
| 38 | 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 = ?
Parameters:
[
7
]
|
| 39 | 0.25 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 = ?
Parameters:
[
3
]
|
| 40 | 0.27 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 = ?
Parameters:
[
9
]
|
| 41 | 0.25 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 = ?
Parameters:
[
11
]
|
| 42 | 189.91 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '1' AND `query` = 'product_id=27734'
Parameters:
[] |
| 43 | 176.86 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '2' AND `query` = 'product_id=27734'
Parameters:
[] |
| 44 | 162.37 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '3' AND `query` = 'product_id=27734'
Parameters:
[] |
| 45 | 180.68 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '4' AND `query` = 'product_id=27734'
Parameters:
[] |
| 46 | 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
]
|
| 47 | 0.25 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
]
|
| 48 | 0.43 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 ] |
| 49 | 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
]
|
| 50 | 0.50 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 ] |
| 51 | 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
]
|
| 52 | 0.57 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 ] |
| 53 | 0.27 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
]
|
| 54 | 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=37" 1 1 0 ] |
| 55 | 0.59 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
]
|
| 56 | 0.40 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 57 | 0.37 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.type AS type_5, t0.price AS price_6, t0.free_ship_limit AS free_ship_limit_7, t0.active_on_web AS active_on_web_8, t0.sort_index AS sort_index_9, t0.shipping_days AS shipping_days_10, t0.free_shipping_product_types AS free_shipping_product_types_11, t0.free_shipping_start_date AS free_shipping_start_date_12, t0.free_shipping_end_date AS free_shipping_end_date_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.domain_id AS domain_id_16 FROM domain_shipping_types t0 WHERE t0.domain_id = ? AND t0.active_on_web = ? ORDER BY t0.sort_index ASC
Parameters:
[ 1 1 ] |
| 58 | 2.57 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
]
|
| 59 | 0.47 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
]
|
| 60 | 1.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 AND d0_.type <> ?
Parameters:
[ 1 10 ] |
| 61 | 3.34 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
]
|
| 62 | 0.56 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_.active_on_web AS active_on_web_6, d0_.integrated AS integrated_7, d0_.sort_order AS sort_order_8, d0_.created_by AS created_by_9, d0_.updated_by AS updated_by_10, d0_.domain_id AS domain_id_11 FROM domain_payment_types d0_ WHERE d0_.domain_id = ? AND d0_.integrated = ? ORDER BY d0_.sort_order ASC
Parameters:
[ 1 1 ] |
| 63 | 2.43 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
]
|
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.