Symfony Profiler

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.created AS created_1,
  r0_.updated AS updated_2,
  r0_.updated_by_time AS updated_by_time_3,
  r0_.type AS type_4,
  r0_.name AS name_5,
  r0_.text AS text_6,
  r0_.stars AS stars_7,
  r0_.approved AS approved_8,
  r0_.show_at_homepage AS show_at_homepage_9,
  r0_.created_by AS created_by_10,
  r0_.updated_by AS updated_by_11,
  r0_.language_id AS language_id_12,
  r0_.product_id AS product_id_13,
  r0_.customer_id AS customer_id_14,
  r0_.order_id AS order_id_15
FROM
  reviews r0_
  LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?
  AND r1_.id IS NOT NULL
  AND r1_.approved = 1
ORDER BY
  r0_.created DESC
LIMIT
  5

SELECT DISTINCT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 1 AND r1_.id IS NOT NULL AND r1_.approved = 1 ORDER BY r0_.created DESC LIMIT 5;

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 = ?

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 = 1;

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

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 = 1 LIMIT 1;

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

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 = 'static_id=182' AND t0.language_id = 1 AND t0.domain_id = 1 AND t0.archived = 0 LIMIT 1;

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.status AS status_5,
  t0.payment_status AS payment_status_6,
  t0.invoice_code AS invoice_code_7,
  t0.payment_type AS payment_type_8,
  t0.payment_price AS payment_price_9,
  t0.shipping_type AS shipping_type_10,
  t0.shipping_price AS shipping_price_11,
  t0.billing_first_name AS billing_first_name_12,
  t0.billing_last_name AS billing_last_name_13,
  t0.billing_business_name AS billing_business_name_14,
  t0.billing_street AS billing_street_15,
  t0.billing_city AS billing_city_16,
  t0.billing_zip AS billing_zip_17,
  t0.billing_country AS billing_country_18,
  t0.billing_business_id AS billing_business_id_19,
  t0.billing_tax_id AS billing_tax_id_20,
  t0.billing_vat_id AS billing_vat_id_21,
  t0.billing_email AS billing_email_22,
  t0.billing_phone_number AS billing_phone_number_23,
  t0.shipping_first_name AS shipping_first_name_24,
  t0.shipping_last_name AS shipping_last_name_25,
  t0.shipping_business_name AS shipping_business_name_26,
  t0.shipping_street AS shipping_street_27,
  t0.shipping_city AS shipping_city_28,
  t0.shipping_zip AS shipping_zip_29,
  t0.shipping_country AS shipping_country_30,
  t0.shipping_email AS shipping_email_31,
  t0.shipping_phone_number AS shipping_phone_number_32,
  t0.message AS message_33,
  t0.coupon_code AS coupon_code_34,
  t0.ship_date AS ship_date_35,
  t0.planned_ship_date AS planned_ship_date_36,
  t0.delivery_date AS delivery_date_37,
  t0.box_count AS box_count_38,
  t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39,
  t0.full_price AS full_price_40,
  t0.presta_order_code AS presta_order_code_41,
  t0.external_order_source AS external_order_source_42,
  t0.external_order_code AS external_order_code_43,
  t0.message_done AS message_done_44,
  t0.message_done_time AS message_done_time_45,
  t0.force_free_shipping AS force_free_shipping_46,
  t0.warranty AS warranty_47,
  t0.created_by_type AS created_by_type_48,
  t0.archived AS archived_49,
  t0.discount AS discount_50,
  t0.tracking_url AS tracking_url_51,
  t0.parcelNumber AS parcelNumber_52,
  t0.dhlShipmentNumber AS dhlShipmentNumber_53,
  t0.parcelStatus AS parcelStatus_54,
  t0.priority AS priority_55,
  t0.base_order_id AS base_order_id_56,
  t0.vat AS vat_57,
  t0.created_by AS created_by_58,
  t0.updated_by AS updated_by_59,
  t0.domain_id AS domain_id_60,
  t0.customer_id AS customer_id_61,
  t0.message_done_by AS message_done_by_62
FROM
  orders t0
WHERE
  t0.id = ?

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.status AS status_5, t0.payment_status AS payment_status_6, t0.invoice_code AS invoice_code_7, t0.payment_type AS payment_type_8, t0.payment_price AS payment_price_9, t0.shipping_type AS shipping_type_10, t0.shipping_price AS shipping_price_11, t0.billing_first_name AS billing_first_name_12, t0.billing_last_name AS billing_last_name_13, t0.billing_business_name AS billing_business_name_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.billing_zip AS billing_zip_17, t0.billing_country AS billing_country_18, t0.billing_business_id AS billing_business_id_19, t0.billing_tax_id AS billing_tax_id_20, t0.billing_vat_id AS billing_vat_id_21, t0.billing_email AS billing_email_22, t0.billing_phone_number AS billing_phone_number_23, t0.shipping_first_name AS shipping_first_name_24, t0.shipping_last_name AS shipping_last_name_25, t0.shipping_business_name AS shipping_business_name_26, t0.shipping_street AS shipping_street_27, t0.shipping_city AS shipping_city_28, t0.shipping_zip AS shipping_zip_29, t0.shipping_country AS shipping_country_30, t0.shipping_email AS shipping_email_31, t0.shipping_phone_number AS shipping_phone_number_32, t0.message AS message_33, t0.coupon_code AS coupon_code_34, t0.ship_date AS ship_date_35, t0.planned_ship_date AS planned_ship_date_36, t0.delivery_date AS delivery_date_37, t0.box_count AS box_count_38, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39, t0.full_price AS full_price_40, t0.presta_order_code AS presta_order_code_41, t0.external_order_source AS external_order_source_42, t0.external_order_code AS external_order_code_43, t0.message_done AS message_done_44, t0.message_done_time AS message_done_time_45, t0.force_free_shipping AS force_free_shipping_46, t0.warranty AS warranty_47, t0.created_by_type AS created_by_type_48, t0.archived AS archived_49, t0.discount AS discount_50, t0.tracking_url AS tracking_url_51, t0.parcelNumber AS parcelNumber_52, t0.dhlShipmentNumber AS dhlShipmentNumber_53, t0.parcelStatus AS parcelStatus_54, t0.priority AS priority_55, t0.base_order_id AS base_order_id_56, t0.vat AS vat_57, t0.created_by AS created_by_58, t0.updated_by AS updated_by_59, t0.domain_id AS domain_id_60, t0.customer_id AS customer_id_61, t0.message_done_by AS message_done_by_62 FROM orders t0 WHERE t0.id = 202464144;

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.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.domain_id AS domain_id_10
FROM
  pages_static t0
WHERE
  t0.id = ?
LIMIT
  1

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.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.domain_id AS domain_id_10 FROM pages_static t0 WHERE t0.id = 182 LIMIT 1;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reviews r0_
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM reviews r0_ WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.directory AS directory_4,
  t0.filename AS filename_5,
  t0.mime_type AS mime_type_6,
  t0.survey_question_id AS survey_question_id_7,
  t0.order_id AS order_id_8,
  t0.domain_id AS domain_id_9
FROM
  survey_medias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.directory AS directory_4, t0.filename AS filename_5, t0.mime_type AS mime_type_6, t0.survey_question_id AS survey_question_id_7, t0.order_id AS order_id_8, t0.domain_id AS domain_id_9 FROM survey_medias t0 WHERE t0.id = 3062;

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.approved AS approved_5,
  t0.cloudflare_id AS cloudflare_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.review_id AS review_id_9,
  t0.survey_media_id AS survey_media_id_10
FROM
  review_survey_media t0
WHERE
  t0.review_id = ?

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.approved AS approved_5, t0.cloudflare_id AS cloudflare_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.review_id AS review_id_9, t0.survey_media_id AS survey_media_id_10 FROM review_survey_media t0 WHERE t0.review_id = 7949;

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.title AS title_5,
  t0.link AS link_6,
  t0.content AS content_7,
  t0.short_desc AS short_desc_8,
  t0.seo_title AS seo_title_9,
  t0.seo_desc AS seo_desc_10,
  t0.extra_seo_desc AS extra_seo_desc_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.language_id AS language_id_14,
  t0.category_page_id AS category_page_id_15,
  t0.blog_category_id AS blog_category_id_16,
  t0.static_page_id AS static_page_id_17
FROM
  pages_meta t0
WHERE
  t0.static_page_id = ?
ORDER BY
  t0.id ASC

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.title AS title_5, t0.link AS link_6, t0.content AS content_7, t0.short_desc AS short_desc_8, t0.seo_title AS seo_title_9, t0.seo_desc AS seo_desc_10, t0.extra_seo_desc AS extra_seo_desc_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.language_id AS language_id_14, t0.category_page_id AS category_page_id_15, t0.blog_category_id AS blog_category_id_16, t0.static_page_id AS static_page_id_17 FROM pages_meta t0 WHERE t0.static_page_id = 182 ORDER BY t0.id ASC;

SELECT
  updated
FROM
  domain_navigation
WHERE
  domain_id = 1
ORDER BY
  updated DESC
LIMIT
  1

SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1;

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

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 = 1 AND d0_.active_on_web = 1 AND d0_.price > 0;

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

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 = 1 LIMIT 1;

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

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 = 1 LIMIT 1;