Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.`content` AS content_1,
  t0_.lastTranslationUpdate AS lastTranslationUpdate_2,
  t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3,
  t0_.lastTranslationPageToken AS lastTranslationPageToken_4,
  t0_.firstTranslationUpdate AS firstTranslationUpdate_5
FROM
  `TranslationFile` t0_
ORDER BY
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-02 05:12:01' AND m0_.ending_date > '2025-12-02 05:12:01' AND m0_.is_completed = 0;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-02 05:12:01' AND m0_.ending_date > '2025-12-02 05:12:01' AND m0_.is_completed = 0;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.isActive = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.isActive = 1;

SELECT
  c0_.id AS id_0,
  c0_.number AS number_1,
  c0_.subtotal AS subtotal_2,
  c0_.province AS province_3,
  c0_.tax AS tax_4,
  c0_.total AS total_5,
  c0_.created_at AS created_at_6,
  c0_.status AS status_7,
  c0_.payment_id AS payment_id_8,
  c0_.payer_id AS payer_id_9,
  c0_.gift AS gift_10,
  c0_.manager_id AS manager_id_11,
  c0_.type_id AS type_id_12,
  c0_.country_id AS country_id_13,
  c0_.pending_account_id AS pending_account_id_14
FROM
  `Cart` c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.subtotal AS subtotal_2, c0_.province AS province_3, c0_.tax AS tax_4, c0_.total AS total_5, c0_.created_at AS created_at_6, c0_.status AS status_7, c0_.payment_id AS payment_id_8, c0_.payer_id AS payer_id_9, c0_.gift AS gift_10, c0_.manager_id AS manager_id_11, c0_.type_id AS type_id_12, c0_.country_id AS country_id_13, c0_.pending_account_id AS pending_account_id_14 FROM `Cart` c0_ WHERE c0_.id = 2815;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.sub_total AS sub_total_3,
  t0.stripe_subscription_id AS stripe_subscription_id_4,
  t0.type_id AS type_id_5,
  t0.package_id AS package_id_6,
  t0.cart_id AS cart_id_7
FROM
  `CartItem` t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.sub_total AS sub_total_3, t0.stripe_subscription_id AS stripe_subscription_id_4, t0.type_id AS type_id_5, t0.package_id AS package_id_6, t0.cart_id AS cart_id_7 FROM `CartItem` t0 WHERE t0.cart_id = 2815;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.zoho_name AS zoho_name_2,
  p0_.stripe_product_id AS stripe_product_id_3,
  p0_.name AS name_4
FROM
  Package p0_
WHERE
  p0_.type = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.zoho_name AS zoho_name_2, p0_.stripe_product_id AS stripe_product_id_3, p0_.name AS name_4 FROM Package p0_ WHERE p0_.type = 'CLASS' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `CartItem` (
  number, sub_total, stripe_subscription_id,
  type_id, package_id, cart_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO `CartItem` (number, sub_total, stripe_subscription_id, type_id, package_id, cart_id) VALUES (1, 0, NULL, NULL, 2, 2815);

DELETE FROM
  `CartItem`
WHERE
  id = ?

DELETE FROM `CartItem` WHERE id = 2744;

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.zoho_name AS zoho_name_2,
  p0_.stripe_product_id AS stripe_product_id_3,
  p0_.name AS name_4
FROM
  Package p0_
WHERE
  p0_.type = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.zoho_name AS zoho_name_2, p0_.stripe_product_id AS stripe_product_id_3, p0_.name AS name_4 FROM Package p0_ WHERE p0_.type = 'CLASS' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tag AS tag_2,
  c0_.currency AS currency_3,
  c0_.currency_symbol AS currency_symbol_4,
  c0_.is_default AS is_default_5,
  c0_.`translations` AS translations_6,
  c0_.school_calendar_id AS school_calendar_id_7
FROM
  `Country` c0_
WHERE
  c0_.tag = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = 'US' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.environment AS environment_1,
  s0_.label AS label_2,
  s0_.url AS url_3,
  s0_.icon AS icon_4,
  s0_.flow AS flow_5,
  s0_.position AS position_6,
  s0_.is_published AS is_published_7
FROM
  `SideMenuOption` s0_
WHERE
  s0_.environment = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.environment AS environment_1, s0_.label AS label_2, s0_.url AS url_3, s0_.icon AS icon_4, s0_.flow AS flow_5, s0_.position AS position_6, s0_.is_published AS is_published_7 FROM `SideMenuOption` s0_ WHERE s0_.environment = 'ENV_CONSTELLATION' ORDER BY s0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.url AS url_2,
  t0_.route AS route_3,
  t0_.is_active AS is_active_4,
  t0_.display_on_first_time AS display_on_first_time_5
FROM
  `TutorialPanel` t0_
WHERE
  t0_.route = ?
  AND t0_.is_active = ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.url AS url_2, t0_.route AS route_3, t0_.is_active AS is_active_4, t0_.display_on_first_time AS display_on_first_time_5 FROM `TutorialPanel` t0_ WHERE t0_.route = 'admin_site_buy_class_package.fr-CA' AND t0_.is_active = 1;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.url AS url_2,
  t0_.route AS route_3,
  t0_.is_active AS is_active_4,
  t0_.display_on_first_time AS display_on_first_time_5
FROM
  `TutorialPanel` t0_
WHERE
  t0_.route = ?
  AND t0_.is_active = ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.url AS url_2, t0_.route AS route_3, t0_.is_active AS is_active_4, t0_.display_on_first_time AS display_on_first_time_5 FROM `TutorialPanel` t0_ WHERE t0_.route = 'admin_site_buy_class_package.fr-CA' AND t0_.is_active = 1;

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.text AS text_2,
  i0_.image AS image_3,
  i0_.icon_class AS icon_class_4,
  i0_.route AS route_5,
  i0_.is_active AS is_active_6,
  i0_.translations AS translations_7
FROM
  `InformationPanel` i0_
WHERE
  i0_.route = ?
  AND i0_.is_active = ?
LIMIT
  1

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.text AS text_2, i0_.image AS image_3, i0_.icon_class AS icon_class_4, i0_.route AS route_5, i0_.is_active AS is_active_6, i0_.translations AS translations_7 FROM `InformationPanel` i0_ WHERE i0_.route = 'admin_site_buy_class_package' AND i0_.is_active = 1 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.zoho_name AS zoho_name_2,
  p0_.stripe_product_id AS stripe_product_id_3,
  p0_.name AS name_4
FROM
  Package p0_
WHERE
  p0_.type = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.zoho_name AS zoho_name_2, p0_.stripe_product_id AS stripe_product_id_3, p0_.name AS name_4 FROM Package p0_ WHERE p0_.type = 'CLASS' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tag AS tag_2,
  c0_.currency AS currency_3,
  c0_.currency_symbol AS currency_symbol_4,
  c0_.is_default AS is_default_5,
  c0_.`translations` AS translations_6,
  c0_.school_calendar_id AS school_calendar_id_7
FROM
  `Country` c0_
WHERE
  c0_.tag = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = 'US' LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.is_crawlable AS is_crawlable_2,
  i0_.is_legal_document AS is_legal_document_3,
  i0_.asked_for_validation_on AS asked_for_validation_on_4,
  i0_.is_default_user_agreement AS is_default_user_agreement_5,
  i0_.is_default_privacy_policy AS is_default_privacy_policy_6,
  i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7,
  i0_.is_marked_as_deleted AS is_marked_as_deleted_8,
  i0_.deleted_at AS deleted_at_9
FROM
  `InformationPage` i0_
WHERE
  i0_.is_default_privacy_policy = ?
  AND i0_.is_marked_as_deleted = 0
LIMIT
  1

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_privacy_policy = 1 AND i0_.is_marked_as_deleted = 0 LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.is_crawlable AS is_crawlable_2,
  i0_.is_legal_document AS is_legal_document_3,
  i0_.asked_for_validation_on AS asked_for_validation_on_4,
  i0_.is_default_user_agreement AS is_default_user_agreement_5,
  i0_.is_default_privacy_policy AS is_default_privacy_policy_6,
  i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7,
  i0_.is_marked_as_deleted AS is_marked_as_deleted_8,
  i0_.deleted_at AS deleted_at_9
FROM
  `InformationPage` i0_
WHERE
  i0_.is_default_user_agreement = ?
  AND i0_.is_marked_as_deleted = 0
LIMIT
  1

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_user_agreement = 1 AND i0_.is_marked_as_deleted = 0 LIMIT 1;