Symfony Profiler

SELECT
  t0.code AS code_1,
  t0.id AS id_2,
  t0.code3 AS code3_3,
  t0.enabled AS enabled_4,
  t0.currency_id AS currency_id_5,
  t0.lng_id AS lng_id_6
FROM
  xc_countries t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.id AS id_2, t0.code3 AS code3_3, t0.enabled AS enabled_4, t0.currency_id AS currency_id_5, t0.lng_id AS lng_id_6 FROM xc_countries t0 WHERE t0.code = 'CA';

SELECT
  t0.state_id AS state_id_1,
  t0.state AS state_2,
  t0.code AS code_3,
  t0.country_code AS country_code_4,
  t0.region_code AS region_code_5
FROM
  xc_states t0
WHERE
  t0.country_code = ?
ORDER BY
  t0.state ASC

SELECT t0.state_id AS state_id_1, t0.state AS state_2, t0.code AS code_3, t0.country_code AS country_code_4, t0.region_code AS region_code_5 FROM xc_states t0 WHERE t0.country_code = 'CA' ORDER BY t0.state ASC;

SELECT
  x0_.csiProfileType AS csiProfileType_0,
  x0_.rewardPoints AS rewardPoints_1,
  x0_.taxExempt AS taxExempt_2,
  x0_.emailConfirmed AS emailConfirmed_3,
  x0_.emailConfirmationCode AS emailConfirmationCode_4,
  x0_.emailConfirmationCodeDate AS emailConfirmationCodeDate_5,
  x0_.newLogin AS newLogin_6,
  x0_.profile_id AS profile_id_7,
  x0_.login AS login_8,
  x0_.password AS password_9,
  x0_.password_hint AS password_hint_10,
  x0_.password_hint_answer AS password_hint_answer_11,
  x0_.passwordResetKey AS passwordResetKey_12,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_13,
  x0_.access_level AS access_level_14,
  x0_.added AS added_15,
  x0_.first_login AS first_login_16,
  x0_.last_login AS last_login_17,
  x0_.status AS status_18,
  x0_.statusComment AS statusComment_19,
  x0_.referer AS referer_20,
  x0_.language AS language_21,
  x0_.last_shipping_id AS last_shipping_id_22,
  x0_.last_payment_id AS last_payment_id_23,
  x0_.anonymous AS anonymous_24,
  x0_.forceChangePassword AS forceChangePassword_25,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_26,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_27,
  x0_.searchFakeField AS searchFakeField_28,
  x0_.xcPendingExport AS xcPendingExport_29,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_30,
  x0_.order_id AS order_id_31,
  x0_.membership_id AS membership_id_32,
  x0_.pending_membership_id AS pending_membership_id_33
FROM
  xc_profiles x0_
  LEFT JOIN xc_profile_addresses x1_ ON x0_.profile_id = x1_.profile_id
WHERE
  (
    x0_.order_id IS NULL
    AND x0_.anonymous <> ?
  )
  AND x0_.login = ?
  AND x0_.status = ?
LIMIT
  1

SELECT x0_.csiProfileType AS csiProfileType_0, x0_.rewardPoints AS rewardPoints_1, x0_.taxExempt AS taxExempt_2, x0_.emailConfirmed AS emailConfirmed_3, x0_.emailConfirmationCode AS emailConfirmationCode_4, x0_.emailConfirmationCodeDate AS emailConfirmationCodeDate_5, x0_.newLogin AS newLogin_6, x0_.profile_id AS profile_id_7, x0_.login AS login_8, x0_.password AS password_9, x0_.password_hint AS password_hint_10, x0_.password_hint_answer AS password_hint_answer_11, x0_.passwordResetKey AS passwordResetKey_12, x0_.passwordResetKeyDate AS passwordResetKeyDate_13, x0_.access_level AS access_level_14, x0_.added AS added_15, x0_.first_login AS first_login_16, x0_.last_login AS last_login_17, x0_.status AS status_18, x0_.statusComment AS statusComment_19, x0_.referer AS referer_20, x0_.language AS language_21, x0_.last_shipping_id AS last_shipping_id_22, x0_.last_payment_id AS last_payment_id_23, x0_.anonymous AS anonymous_24, x0_.forceChangePassword AS forceChangePassword_25, x0_.dateOfLoginAttempt AS dateOfLoginAttempt_26, x0_.countOfLoginAttempts AS countOfLoginAttempts_27, x0_.searchFakeField AS searchFakeField_28, x0_.xcPendingExport AS xcPendingExport_29, x0_.lastCheckoutEmail AS lastCheckoutEmail_30, x0_.order_id AS order_id_31, x0_.membership_id AS membership_id_32, x0_.pending_membership_id AS pending_membership_id_33 FROM xc_profiles x0_ LEFT JOIN xc_profile_addresses x1_ ON x0_.profile_id = x1_.profile_id WHERE (x0_.order_id IS NULL AND x0_.anonymous <> 1) AND x0_.login = '' AND x0_.status = 'E' LIMIT 1;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
WHERE
  x0_.cleanURL = ?
  AND x0_.product_id IS NOT NULL
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ WHERE x0_.cleanURL = 'TLGU19BLK' AND x0_.product_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.freight_charge AS freight_charge_1,
  t0.participateSale AS participateSale_2,
  t0.discountType AS discountType_3,
  t0.salePriceValue AS salePriceValue_4,
  t0.applySaleToWholesale AS applySaleToWholesale_5,
  t0.makeAnOfferState AS makeAnOfferState_6,
  t0.csiMultiple AS csiMultiple_7,
  t0.isAvailableForBackorder AS isAvailableForBackorder_8,
  t0.isBackorderLimit AS isBackorderLimit_9,
  t0.backorderLimit AS backorderLimit_10,
  t0.callForPrice AS callForPrice_11,
  t0.csLastUpdate AS csLastUpdate_12,
  t0.rewardPoints AS rewardPoints_13,
  t0.fixedRewardPoints AS fixedRewardPoints_14,
  t0.taxExempt AS taxExempt_15,
  t0.isGiftCard AS isGiftCard_16,
  t0.xcPendingBulkEdit AS xcPendingBulkEdit_17,
  t0.googleFeedEnabled AS googleFeedEnabled_18,
  t0.product_id AS product_id_19,
  t0.price AS price_20,
  t0.sku AS sku_21,
  t0.enabled AS enabled_22,
  t0.weight AS weight_23,
  t0.useSeparateBox AS useSeparateBox_24,
  t0.boxWidth AS boxWidth_25,
  t0.boxLength AS boxLength_26,
  t0.boxHeight AS boxHeight_27,
  t0.itemsPerBox AS itemsPerBox_28,
  t0.free_shipping AS free_shipping_29,
  t0.taxable AS taxable_30,
  t0.arrivalDate AS arrivalDate_31,
  t0.date AS date_32,
  t0.updateDate AS updateDate_33,
  t0.needProcess AS needProcess_34,
  t0.inventoryEnabled AS inventoryEnabled_35,
  t0.amount AS amount_36,
  t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_37,
  t0.lowLimitEnabled AS lowLimitEnabled_38,
  t0.lowLimitAmount AS lowLimitAmount_39,
  t0.attrSepTab AS attrSepTab_40,
  t0.metaDescType AS metaDescType_41,
  t0.sales AS sales_42,
  t0.xcPendingExport AS xcPendingExport_43,
  t0.isDemoProduct AS isDemoProduct_44,
  t0.quantity1 AS quantity1_45,
  t0.entityVersion AS entityVersion_46,
  t0.product_class_id AS product_class_id_47,
  t0.tax_class_id AS tax_class_id_48
FROM
  xc_products t0
WHERE
  t0.product_id = ?

SELECT t0.freight_charge AS freight_charge_1, t0.participateSale AS participateSale_2, t0.discountType AS discountType_3, t0.salePriceValue AS salePriceValue_4, t0.applySaleToWholesale AS applySaleToWholesale_5, t0.makeAnOfferState AS makeAnOfferState_6, t0.csiMultiple AS csiMultiple_7, t0.isAvailableForBackorder AS isAvailableForBackorder_8, t0.isBackorderLimit AS isBackorderLimit_9, t0.backorderLimit AS backorderLimit_10, t0.callForPrice AS callForPrice_11, t0.csLastUpdate AS csLastUpdate_12, t0.rewardPoints AS rewardPoints_13, t0.fixedRewardPoints AS fixedRewardPoints_14, t0.taxExempt AS taxExempt_15, t0.isGiftCard AS isGiftCard_16, t0.xcPendingBulkEdit AS xcPendingBulkEdit_17, t0.googleFeedEnabled AS googleFeedEnabled_18, t0.product_id AS product_id_19, t0.price AS price_20, t0.sku AS sku_21, t0.enabled AS enabled_22, t0.weight AS weight_23, t0.useSeparateBox AS useSeparateBox_24, t0.boxWidth AS boxWidth_25, t0.boxLength AS boxLength_26, t0.boxHeight AS boxHeight_27, t0.itemsPerBox AS itemsPerBox_28, t0.free_shipping AS free_shipping_29, t0.taxable AS taxable_30, t0.arrivalDate AS arrivalDate_31, t0.date AS date_32, t0.updateDate AS updateDate_33, t0.needProcess AS needProcess_34, t0.inventoryEnabled AS inventoryEnabled_35, t0.amount AS amount_36, t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_37, t0.lowLimitEnabled AS lowLimitEnabled_38, t0.lowLimitAmount AS lowLimitAmount_39, t0.attrSepTab AS attrSepTab_40, t0.metaDescType AS metaDescType_41, t0.sales AS sales_42, t0.xcPendingExport AS xcPendingExport_43, t0.isDemoProduct AS isDemoProduct_44, t0.quantity1 AS quantity1_45, t0.entityVersion AS entityVersion_46, t0.product_class_id AS product_class_id_47, t0.tax_class_id AS tax_class_id_48 FROM xc_products t0 WHERE t0.product_id = 33317;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.lpos = ?
LIMIT
  1

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.lpos = 1 LIMIT 1;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
  INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id
WHERE
  x0_.cleanURL = ?
  AND x0_.category_id IS NOT NULL
  AND x1_.parent_id = ?
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'lighting' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.category_id = 1579;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
  INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id
WHERE
  x0_.cleanURL = ?
  AND x0_.category_id IS NOT NULL
  AND x1_.parent_id = ?
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'indoor-fixtures' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1579 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.category_id = 1586;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
  INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id
WHERE
  x0_.cleanURL = ?
  AND x0_.category_id IS NOT NULL
  AND x1_.parent_id = ?
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'track-lighting' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1586 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.category_id = 1636;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
  INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id
WHERE
  x0_.cleanURL = ?
  AND x0_.category_id IS NOT NULL
  AND x1_.parent_id = ?
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'kendal-lighting' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1636 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.category_id = 1988;