Symfony Profiler

SELECT
  t0.enabled AS enabled_1,
  t0.name AS name_2,
  t0.relative_path AS relative_path_3,
  t0.host AS host_4,
  t0.enabled_from AS enabled_from_5,
  t0.enabled_to AS enabled_to_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.locale AS locale_10,
  t0.title AS title_11,
  t0.meta_keywords AS meta_keywords_12,
  t0.meta_description AS meta_description_13,
  t0.id AS id_14
FROM
  page__site t0
WHERE
  t0.host IN (?, ?)
  AND t0.enabled = ?
ORDER BY
  t0.is_default DESC

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN ('www.shipflick.io', 'localhost') AND t0.enabled = 1 ORDER BY t0.is_default DESC;

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = true
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-05-15 16:59:11' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-05-15 16:59:11')) AND p0_.enabled = true AND p0_.site_id = 4 AND p0_.url = '/webhooks/delhivery/sync' LIMIT 1;

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = true
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-05-15 16:59:11' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-05-15 16:59:11')) AND p0_.enabled = true AND p0_.site_id = 4 AND p0_.url = '/webhooks/delhivery/sync' LIMIT 1;

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = true
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-05-15 16:59:11' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-05-15 16:59:11')) AND p0_.enabled = true AND p0_.site_id = 4 AND p0_.url = '/webhooks/delhivery/sync' LIMIT 1;

SELECT
  p0_.route_name AS route_name_0,
  p0_.page_alias AS page_alias_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.enabled AS enabled_4,
  p0_.decorate AS decorate_5,
  p0_.name AS name_6,
  p0_.url AS url_7,
  p0_.parent_id AS parent_id_8,
  p0_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
FROM
  page__snapshot p0_
WHERE
  (
    p0_.publication_date_start <= ?
    AND (
      p0_.publication_date_end IS NULL
      OR p0_.publication_date_end >= ?
    )
  )
  AND p0_.enabled = true
  AND p0_.site_id = ?
  AND p0_.url = ?
LIMIT
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-05-15 16:59:11' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-05-15 16:59:11')) AND p0_.enabled = true AND p0_.site_id = 4 AND p0_.url = '/webhooks/delhivery/sync' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lrno AS lrno_2,
  t0.product_description AS product_description_3,
  t0.client_reference_id AS client_reference_id_4,
  t0.e_way_bill AS e_way_bill_5,
  t0.amount AS amount_6,
  t0.invoice_no AS invoice_no_7,
  t0.hsncode AS hsncode_8,
  t0.shipper_gstn AS shipper_gstn_9,
  t0.consignee_gstin AS consignee_gstin_10,
  t0.consignee_company_name AS consignee_company_name_11,
  t0.consignee_customer_name AS consignee_customer_name_12,
  t0.consignee_phone_number AS consignee_phone_number_13,
  t0.consignee_email AS consignee_email_14,
  t0.consignee_address AS consignee_address_15,
  t0.manifested_date AS manifested_date_16,
  t0.awb_number AS awb_number_17,
  t0.status AS status_18,
  t0.consignee_address2 AS consignee_address2_19,
  t0.consignee_address3 AS consignee_address3_20,
  t0.delivered_at AS delivered_at_21,
  t0.seller_name AS seller_name_22,
  t0.seller_mobile AS seller_mobile_23,
  t0.seller_email AS seller_email_24,
  t0.pickup_date AS pickup_date_25,
  t0.starred AS starred_26,
  t0.bill_generated AS bill_generated_27,
  t0.charged_weight AS charged_weight_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.pickup_point_id AS pickup_point_id_31,
  t0.consignee_city_id AS consignee_city_id_32,
  t0.consignment_id AS consignment_id_33,
  t0.customer_id AS customer_id_34,
  t0.carrier_id AS carrier_id_35,
  t36.id AS id_37,
  t36.invoice_number AS invoice_number_38,
  t36.invoice_date AS invoice_date_39,
  t36.customer_gstin AS customer_gstin_40,
  t36.status AS status_41,
  t36.zoho_invoice_id AS zoho_invoice_id_42,
  t36.customer_id AS customer_id_43,
  t36.company_id AS company_id_44,
  t36.state_of_supply_id AS state_of_supply_id_45,
  t36.shipping_order_id AS shipping_order_id_46,
  t0.consignee_id AS consignee_id_47,
  t0.pickup_time_slot_id AS pickup_time_slot_id_48,
  t0.commodity_id AS commodity_id_49
FROM
  "order" t0
  LEFT JOIN invoice t36 ON t36.shipping_order_id = t0.id
WHERE
  t0.lrno = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lrno AS lrno_2, t0.product_description AS product_description_3, t0.client_reference_id AS client_reference_id_4, t0.e_way_bill AS e_way_bill_5, t0.amount AS amount_6, t0.invoice_no AS invoice_no_7, t0.hsncode AS hsncode_8, t0.shipper_gstn AS shipper_gstn_9, t0.consignee_gstin AS consignee_gstin_10, t0.consignee_company_name AS consignee_company_name_11, t0.consignee_customer_name AS consignee_customer_name_12, t0.consignee_phone_number AS consignee_phone_number_13, t0.consignee_email AS consignee_email_14, t0.consignee_address AS consignee_address_15, t0.manifested_date AS manifested_date_16, t0.awb_number AS awb_number_17, t0.status AS status_18, t0.consignee_address2 AS consignee_address2_19, t0.consignee_address3 AS consignee_address3_20, t0.delivered_at AS delivered_at_21, t0.seller_name AS seller_name_22, t0.seller_mobile AS seller_mobile_23, t0.seller_email AS seller_email_24, t0.pickup_date AS pickup_date_25, t0.starred AS starred_26, t0.bill_generated AS bill_generated_27, t0.charged_weight AS charged_weight_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.pickup_point_id AS pickup_point_id_31, t0.consignee_city_id AS consignee_city_id_32, t0.consignment_id AS consignment_id_33, t0.customer_id AS customer_id_34, t0.carrier_id AS carrier_id_35, t36.id AS id_37, t36.invoice_number AS invoice_number_38, t36.invoice_date AS invoice_date_39, t36.customer_gstin AS customer_gstin_40, t36.status AS status_41, t36.zoho_invoice_id AS zoho_invoice_id_42, t36.customer_id AS customer_id_43, t36.company_id AS company_id_44, t36.state_of_supply_id AS state_of_supply_id_45, t36.shipping_order_id AS shipping_order_id_46, t0.consignee_id AS consignee_id_47, t0.pickup_time_slot_id AS pickup_time_slot_id_48, t0.commodity_id AS commodity_id_49 FROM "order" t0 LEFT JOIN invoice t36 ON t36.shipping_order_id = t0.id WHERE t0.lrno = '281316983' LIMIT 1;