Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = 'b2b_license_end_date' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.seo AS seo_7,
  t0.order AS order_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 246;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.commision_fee AS commision_fee_3,
  t0.installment AS installment_4,
  t0.is_default AS is_default_5,
  t0.virtual_pos_id AS virtual_pos_id_6
FROM
  pos_plan t0
WHERE
  t0.virtual_pos_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.commision_fee AS commision_fee_3, t0.installment AS installment_4, t0.is_default AS is_default_5, t0.virtual_pos_id AS virtual_pos_id_6 FROM pos_plan t0 WHERE t0.virtual_pos_id = 22;

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_
WHERE
  s0_.`key` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = 'maintenance_mode';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.keywords AS keywords_4,
  t0.content AS content_5,
  t0.seo AS seo_6,
  t0.sortStatus AS sortStatus_7,
  t0.page_category_id AS page_category_id_8
FROM
  page t0
WHERE
  t0.page_category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.content AS content_5, t0.seo AS seo_6, t0.sortStatus AS sortStatus_7, t0.page_category_id AS page_category_id_8 FROM page t0 WHERE t0.page_category_id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.equivalent_code AS equivalent_code_3,
  t0.name AS name_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.description AS description_8,
  t0.seo AS seo_9,
  t0.default_unit AS default_unit_10,
  t0.quantity AS quantity_11,
  t0.tax_rate AS tax_rate_12,
  t0.image AS image_13,
  t0.currency AS currency_14,
  t0.comment_count AS comment_count_15,
  t0.star_rate AS star_rate_16,
  t0.sales_number AS sales_number_17,
  t0.parent_id AS parent_id_18,
  t0.model_id AS model_id_19,
  t0.brand_id AS brand_id_20
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.comment_count AS comment_count_15, t0.star_rate AS star_rate_16, t0.sales_number AS sales_number_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.brand_id AS brand_id_20 FROM product t0 WHERE t0.id = '431';

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.warehouseId AS warehouseId_3,
  t0.date AS date_4,
  t0.warehouseName AS warehouseName_5,
  t0.inventoryId AS inventoryId_6,
  t0.productId AS productId_7
FROM
  stock_inventory t0
WHERE
  t0.productId = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = 431;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.barcode AS barcode_3,
  t0.default_price_order AS default_price_order_4,
  t0.list_price_order AS list_price_order_5,
  t0.multiplier AS multiplier_6,
  t0.length AS length_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.weight AS weight_10,
  t0.product_id AS product_id_11
FROM
  product_unit t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = 431;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.seo AS seo_7,
  t0.order AS order_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
  INNER JOIN product_to_category ON t0.id = product_to_category.category_id
WHERE
  product_to_category.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 INNER JOIN product_to_category ON t0.id = product_to_category.category_id WHERE product_to_category.product_id = 431;

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.currency AS currency_3,
  t0.price_order AS price_order_4,
  t0.product_unit_id AS product_unit_id_5
FROM
  product_price t0
WHERE
  t0.product_unit_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = 12;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.name AS name_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.name AS name_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = 431;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.whatsapp AS whatsapp_6,
  t0.social_media AS social_media_7,
  t0.email AS email_8,
  t0.description AS description_9,
  t0.logo AS logo_10,
  t0.whatsapp_control AS whatsapp_control_11
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.social_media AS social_media_7, t0.email AS email_8, t0.description AS description_9, t0.logo AS logo_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.quantity AS quantity_2,
  c0_.product_id AS product_id_3,
  c0_.user_id AS user_id_4,
  c0_.product_unit_id AS product_unit_id_5
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.quantity AS quantity_2, c0_.product_id AS product_id_3, c0_.user_id AS user_id_4, c0_.product_unit_id AS product_unit_id_5 FROM cart c0_ WHERE c0_.session_id = NULL;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.equivalent_code AS equivalent_code_3,
  t0.name AS name_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.description AS description_8,
  t0.seo AS seo_9,
  t0.default_unit AS default_unit_10,
  t0.quantity AS quantity_11,
  t0.tax_rate AS tax_rate_12,
  t0.image AS image_13,
  t0.currency AS currency_14,
  t0.comment_count AS comment_count_15,
  t0.star_rate AS star_rate_16,
  t0.sales_number AS sales_number_17,
  t0.parent_id AS parent_id_18,
  t0.model_id AS model_id_19,
  t0.brand_id AS brand_id_20
FROM
  product t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.comment_count AS comment_count_15, t0.star_rate AS star_rate_16, t0.sales_number AS sales_number_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.brand_id AS brand_id_20 FROM product t0 WHERE t0.parent_id = 431;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.brand_id AS brand_id_3
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.brand_id AS brand_id_3 FROM model t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.comment_title AS comment_title_2,
  t0.comment_description AS comment_description_3,
  t0.order_no AS order_no_4,
  t0.star AS star_5,
  t0.date AS date_6,
  t0.name AS name_7,
  t0.user_id AS user_id_8,
  t0.product_id AS product_id_9
FROM
  user_comment t0

SELECT t0.id AS id_1, t0.comment_title AS comment_title_2, t0.comment_description AS comment_description_3, t0.order_no AS order_no_4, t0.star AS star_5, t0.date AS date_6, t0.name AS name_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM user_comment t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.commision_fee AS commision_fee_3,
  t0.installment AS installment_4,
  t0.is_default AS is_default_5,
  t0.virtual_pos_id AS virtual_pos_id_6
FROM
  pos_plan t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.commision_fee AS commision_fee_3, t0.installment AS installment_4, t0.is_default AS is_default_5, t0.virtual_pos_id AS virtual_pos_id_6 FROM pos_plan t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.product_id AS product_id_2
FROM
  campaign c0_
WHERE
  c0_.product_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.product_id AS product_id_2 FROM campaign c0_ WHERE c0_.product_id = 431;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.exchangeRate AS exchangeRate_5
FROM
  currency t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0;