Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.id = 2781;

SELECT
  i0_.id AS id_0,
  i0_.zoho_id AS zoho_id_1,
  i0_.item_code AS item_code_2,
  i0_.name AS name_3,
  i0_.slug AS slug_4,
  i0_.sku AS sku_5,
  i0_.hsn_code AS hsn_code_6,
  i0_.description AS description_7,
  i0_.size AS size_8,
  i0_.unit AS unit_9,
  i0_.rate AS rate_10,
  i0_.purchase_rate AS purchase_rate_11,
  i0_.combo_product AS combo_product_12,
  i0_.taxable AS taxable_13,
  i0_.stock_on_hand AS stock_on_hand_14,
  i0_.available_stock AS available_stock_15,
  i0_.actual_available_stock AS actual_available_stock_16,
  i0_.committed_stock AS committed_stock_17,
  i0_.actual_committed_stock AS actual_committed_stock_18,
  i0_.available_for_sale_stock AS available_for_sale_stock_19,
  i0_.actual_available_for_sale_stock AS actual_available_for_sale_stock_20,
  i0_.active AS active_21,
  i0_.imported AS imported_22,
  i0_.meta_title AS meta_title_23,
  i0_.meta_description AS meta_description_24,
  i0_.meta_keywords AS meta_keywords_25,
  i0_.featured AS featured_26,
  i0_.trending AS trending_27,
  i0_.show_in_portal AS show_in_portal_28,
  i0_.gender AS gender_29,
  i0_.created_at AS created_at_30,
  i0_.updated_at AS updated_at_31,
  IFNULL(
    i0_.group_id,
    UUID_SHORT()
  ) AS sclr_32,
  i0_.category_id AS category_id_33,
  i0_.group_id AS group_id_34,
  i0_.grade_id AS grade_id_35,
  i0_.intra_tax_id AS intra_tax_id_36,
  i0_.inter_tax_id AS inter_tax_id_37,
  i0_.created_by AS created_by_38,
  i0_.updated_by AS updated_by_39
FROM
  item i0_
WHERE
  i0_.active = ?
  AND i0_.show_in_portal = ?
  AND i0_.category_id = ?
  AND EXISTS (
    SELECT
      1
    FROM
      school_item s1_
    WHERE
      s1_.item_id = i0_.id
      AND s1_.school_id IN (?)
  )
GROUP BY
  i0_.id,
  sclr_32
ORDER BY
  CASE WHEN i0_.actual_available_for_sale_stock <= 0 THEN
    1
  ELSE
    0
  END ASC,
  i0_.combo_product DESC,
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.zoho_id AS zoho_id_1, i0_.item_code AS item_code_2, i0_.name AS name_3, i0_.slug AS slug_4, i0_.sku AS sku_5, i0_.hsn_code AS hsn_code_6, i0_.description AS description_7, i0_.size AS size_8, i0_.unit AS unit_9, i0_.rate AS rate_10, i0_.purchase_rate AS purchase_rate_11, i0_.combo_product AS combo_product_12, i0_.taxable AS taxable_13, i0_.stock_on_hand AS stock_on_hand_14, i0_.available_stock AS available_stock_15, i0_.actual_available_stock AS actual_available_stock_16, i0_.committed_stock AS committed_stock_17, i0_.actual_committed_stock AS actual_committed_stock_18, i0_.available_for_sale_stock AS available_for_sale_stock_19, i0_.actual_available_for_sale_stock AS actual_available_for_sale_stock_20, i0_.active AS active_21, i0_.imported AS imported_22, i0_.meta_title AS meta_title_23, i0_.meta_description AS meta_description_24, i0_.meta_keywords AS meta_keywords_25, i0_.featured AS featured_26, i0_.trending AS trending_27, i0_.show_in_portal AS show_in_portal_28, i0_.gender AS gender_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, IFNULL(i0_.group_id, UUID_SHORT()) AS sclr_32, i0_.category_id AS category_id_33, i0_.group_id AS group_id_34, i0_.grade_id AS grade_id_35, i0_.intra_tax_id AS intra_tax_id_36, i0_.inter_tax_id AS inter_tax_id_37, i0_.created_by AS created_by_38, i0_.updated_by AS updated_by_39 FROM item i0_ WHERE i0_.active = 1 AND i0_.show_in_portal = 1 AND i0_.category_id = 4 AND EXISTS (SELECT 1 FROM school_item s1_ WHERE s1_.item_id = i0_.id AND s1_.school_id IN (126)) GROUP BY i0_.id, sclr_32 ORDER BY CASE WHEN i0_.actual_available_for_sale_stock <= 0 THEN 1 ELSE 0 END ASC, i0_.combo_product DESC, i0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  item_category t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  grade t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_code AS school_code_3,
  t0.brand_code AS brand_code_4,
  t0.zone AS zone_5,
  t0.slug AS slug_6,
  t0.active AS active_7,
  t0.party_user_code AS party_user_code_8,
  t0.tax_region AS tax_region_9
FROM
  school t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_code AS school_code_3, t0.brand_code AS brand_code_4, t0.zone AS zone_5, t0.slug AS slug_6, t0.active AS active_7, t0.party_user_code AS party_user_code_8, t0.tax_region AS tax_region_9 FROM school t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.tagline AS tagline_3,
  t0.logo_footer AS logo_footer_4,
  t0.footer_description AS footer_description_5,
  t0.facebook_link AS facebook_link_6,
  t0.x_link AS x_link_7,
  t0.instagram_link AS instagram_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.whatsapp_link AS whatsapp_link_10,
  t0.contact_phone AS contact_phone_11,
  t0.contact_email AS contact_email_12,
  t0.address AS address_13,
  t0.map_link AS map_link_14,
  t0.home_banner_title AS home_banner_title_15,
  t0.home_banner_description AS home_banner_description_16,
  t0.home_banner_image AS home_banner_image_17,
  t0.trending_products_title AS trending_products_title_18,
  t0.trending_products_description AS trending_products_description_19,
  t0.combined_kit_title AS combined_kit_title_20,
  t0.combined_kit_description AS combined_kit_description_21,
  t0.how_works_title AS how_works_title_22,
  t0.how_works_description AS how_works_description_23,
  t0.contact_us_image AS contact_us_image_24,
  t0.contact_us_title AS contact_us_title_25,
  t0.contact_us_description AS contact_us_description_26,
  t0.contact_us_map AS contact_us_map_27,
  t0.google_analytics_id AS google_analytics_id_28,
  t0.google_tag_manager_code AS google_tag_manager_code_29,
  t0.google_site_verification_code AS google_site_verification_code_30,
  t0.zoho_token AS zoho_token_31,
  t0.zoho_token_created_at AS zoho_token_created_at_32,
  t0.safex_token AS safex_token_33,
  t0.safex_token_created_at AS safex_token_created_at_34,
  t0.blue_dart_token AS blue_dart_token_35,
  t0.blue_dart_token_created_at AS blue_dart_token_created_at_36,
  t0.invoice_cc AS invoice_cc_37,
  t0.meta_title AS meta_title_38,
  t0.meta_description AS meta_description_39,
  t0.meta_keywords AS meta_keywords_40
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.trending_products_title AS trending_products_title_18, t0.trending_products_description AS trending_products_description_19, t0.combined_kit_title AS combined_kit_title_20, t0.combined_kit_description AS combined_kit_description_21, t0.how_works_title AS how_works_title_22, t0.how_works_description AS how_works_description_23, t0.contact_us_image AS contact_us_image_24, t0.contact_us_title AS contact_us_title_25, t0.contact_us_description AS contact_us_description_26, t0.contact_us_map AS contact_us_map_27, t0.google_analytics_id AS google_analytics_id_28, t0.google_tag_manager_code AS google_tag_manager_code_29, t0.google_site_verification_code AS google_site_verification_code_30, t0.zoho_token AS zoho_token_31, t0.zoho_token_created_at AS zoho_token_created_at_32, t0.safex_token AS safex_token_33, t0.safex_token_created_at AS safex_token_created_at_34, t0.blue_dart_token AS blue_dart_token_35, t0.blue_dart_token_created_at AS blue_dart_token_created_at_36, t0.invoice_cc AS invoice_cc_37, t0.meta_title AS meta_title_38, t0.meta_description AS meta_description_39, t0.meta_keywords AS meta_keywords_40 FROM setting t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t0.body AS body_5,
  t0.featured_image AS featured_image_6,
  t0.footer_nav AS footer_nav_7,
  t0.`position` AS position_8,
  t0.publish AS publish_9,
  t0.public AS public_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.publish = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = 'products' AND t0.publish = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.mobile AS mobile_7,
  t0.avatar AS avatar_8,
  t0.token AS token_9,
  t0.token_date AS token_date_10,
  t0.last_login AS last_login_11,
  t0.email_verified AS email_verified_12,
  t0.mobile_verified AS mobile_verified_13,
  t0.enabled AS enabled_14,
  t0.date_of_birth AS date_of_birth_15,
  t0.gender AS gender_16,
  t0.zoho_id AS zoho_id_17,
  t0.display_name AS display_name_18,
  t0.company AS company_19,
  t0.location AS location_20,
  t0.type AS type_21,
  t0.phone AS phone_22,
  t0.pan AS pan_23,
  t0.gst_number AS gst_number_24,
  t0.gst_treatment AS gst_treatment_25,
  t0.place_of_contact AS place_of_contact_26,
  t0.imported AS imported_27,
  t0.additional_email AS additional_email_28,
  t0.offline_payment AS offline_payment_29,
  t0.logic_code AS logic_code_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.school_id AS school_id_33
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = 286;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  item_category t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.slug = 'kit' AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t0.body AS body_5,
  t0.featured_image AS featured_image_6,
  t0.footer_nav AS footer_nav_7,
  t0.`position` AS position_8,
  t0.publish AS publish_9,
  t0.public AS public_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = 'kit' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.item_id AS item_id_3,
  t0.group_id AS group_id_4
FROM
  item_mandatory t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 3681;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.composite_item_id AS composite_item_id_3,
  t0.item_id AS item_id_4
FROM
  composite_item t0
WHERE
  t0.composite_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 3681;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.item_id AS item_id_5,
  t0.parent_id AS parent_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  cart t0
WHERE
  t0.created_by = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = 286;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.`position` AS position_3,
  t0.item_id AS item_id_4
FROM
  item_image t0
WHERE
  t0.item_id = ?
ORDER BY
  t0.`position` ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 3681 ORDER BY t0.`position` ASC;