Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.wtt_id AS wtt_id_4,
  t0.wtt_name AS wtt_name_5,
  t0.logo AS logo_6,
  t0.config AS config_7,
  t0.apikey AS apikey_8,
  t0.login_hash AS login_hash_9,
  t0.channel AS channel_10,
  t0.mail_copy AS mail_copy_11,
  t0.active AS active_12
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = '8';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.machine_name AS machine_name_3,
  t0.description AS description_4,
  t0.widget AS widget_5,
  t0.role AS role_6,
  t0.target AS target_7,
  t0.default_value AS default_value_8,
  t0.default_url AS default_url_9
FROM
  setting t0
WHERE
  t0.target = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.machine_name AS machine_name_3, t0.description AS description_4, t0.widget AS widget_5, t0.role AS role_6, t0.target AS target_7, t0.default_value AS default_value_8, t0.default_url AS default_url_9 FROM setting t0 WHERE t0.target = 'Shop';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 11 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?
  AND t0.setting_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8 AND t0.setting_id = 12 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.rank AS rank_1,
  s0_.qty AS qty_2,
  s0_.price AS price_3,
  s0_.grade AS grade_4,
  s0_.source_grade AS source_grade_5,
  s0_.public_price AS public_price_6,
  s0_.enabled AS enabled_7,
  s0_.updated AS updated_8,
  s0_.override AS override_9,
  s0_.option_price AS option_price_10,
  s0_.shop_id AS shop_id_11,
  s0_.model_id AS model_id_12,
  s0_.color_id AS color_id_13,
  s0_.product_id AS product_id_14
FROM
  stock s0_
  INNER JOIN model m1_ ON s0_.model_id = m1_.id
  INNER JOIN manufacturer m2_ ON m1_.manufacturer_id = m2_.id
  INNER JOIN color c3_ ON s0_.color_id = c3_.id
  INNER JOIN category c4_ ON m1_.category_id = c4_.id
WHERE
  s0_.shop_id = ?
  AND s0_.qty <> ?
  AND s0_.enabled = ?
  AND s0_.price > ?
ORDER BY
  s0_.price ASC

SELECT s0_.id AS id_0, s0_.rank AS rank_1, s0_.qty AS qty_2, s0_.price AS price_3, s0_.grade AS grade_4, s0_.source_grade AS source_grade_5, s0_.public_price AS public_price_6, s0_.enabled AS enabled_7, s0_.updated AS updated_8, s0_.override AS override_9, s0_.option_price AS option_price_10, s0_.shop_id AS shop_id_11, s0_.model_id AS model_id_12, s0_.color_id AS color_id_13, s0_.product_id AS product_id_14 FROM stock s0_ INNER JOIN model m1_ ON s0_.model_id = m1_.id INNER JOIN manufacturer m2_ ON m1_.manufacturer_id = m2_.id INNER JOIN color c3_ ON s0_.color_id = c3_.id INNER JOIN category c4_ ON m1_.category_id = c4_.id WHERE s0_.shop_id = 8 AND s0_.qty <> 0 AND s0_.enabled = 1 AND s0_.price > '100' ORDER BY s0_.price ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.wtt_id AS wtt_id_2,
  c0_.type AS type_3
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.wtt_id AS wtt_id_2, c0_.type AS type_3 FROM category c0_;

SELECT
  o0_.id AS id_0,
  o0_.attribute_value AS attribute_value_1,
  o0_.name AS name_2,
  o0_.price AS price_3,
  o0_.target AS target_4,
  o0_.category_id AS category_id_5,
  o0_.attribute_id AS attribute_id_6
FROM
  option o0_
ORDER BY
  o0_.category_id ASC

SELECT o0_.id AS id_0, o0_.attribute_value AS attribute_value_1, o0_.name AS name_2, o0_.price AS price_3, o0_.target AS target_4, o0_.category_id AS category_id_5, o0_.attribute_id AS attribute_id_6 FROM option o0_ ORDER BY o0_.category_id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.wtt_id AS wtt_id_3,
  t0.type AS type_4
FROM
  category t0
  INNER JOIN shop_category ON t0.id = shop_category.category_id
WHERE
  shop_category.shop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = 8;

SELECT
  t0.id AS id_1,
  t0.attribute_value AS attribute_value_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.target AS target_5,
  t0.category_id AS category_id_6,
  t0.attribute_id AS attribute_id_7
FROM
  option t0
  INNER JOIN option_shop ON t0.id = option_shop.option_id
WHERE
  option_shop.shop_id = ?

SELECT t0.id AS id_1, t0.attribute_value AS attribute_value_2, t0.name AS name_3, t0.price AS price_4, t0.target AS target_5, t0.category_id AS category_id_6, t0.attribute_id AS attribute_id_7 FROM option t0 INNER JOIN option_shop ON t0.id = option_shop.option_id WHERE option_shop.shop_id = 8;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.url AS url_3,
  t0.shop_id AS shop_id_4,
  t0.setting_id AS setting_id_5
FROM
  shop_setting t0
WHERE
  t0.shop_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = 8;