Symfony Profiler

[
  "event" => "xcart.boot"
  "listener" => "XCart\EventListener\XCartBootListener::onBoot"
]

[
  "params" => [
    "unix_socket" => ""
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "evalt"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))"
      "table_prefix" => "xc"
      1009 => ""
      1008 => ""
      1007 => ""
    ]
    "driverClass" => "XCart\Doctrine\DBAL\Driver\PDO\MySQL\Driver"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "evalt"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "CA"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "CA"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => ""
    3 => "E"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
  ]
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\CleanUrlListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Monolog\Processor\WebProcessor::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\ConfigListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\LanguageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\ProfileDetectionEventSubscriber::process"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\CartAccessValidationEventSubscriber::checkCart"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformPaginationParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformSortingParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformFieldsetsParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformFilteringParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\CartAccessValidationEventSubscriber::checkCartItem"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "XCart\EventListener\KernelControllerInitListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "XCart\EventListener\ModulesInitEventDispatcher::dispatchModulesInitEvent"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.currency_id AS currency_id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.e AS e_6, t0.decimalDelimiter AS decimalDelimiter_7, t0.thousandDelimiter AS thousandDelimiter_8, t0.roundUp AS roundUp_9 FROM xc_currencies t0 WHERE t0.currency_id = ?"
  "params" => [
    1 => 124
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.value AS value_1, x0_.name AS name_2, x0_.used AS used_3, x0_.order_id AS order_id_4, x0_.card_id AS card_id_5 FROM xc_gift_certificates_orders x0_ WHERE x0_.order_id = ?"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.value AS value_1, x0_.name AS name_2, x0_.used AS used_3, x0_.order_id AS order_id_4, x0_.card_id AS card_id_5 FROM xc_gift_certificates_orders x0_ WHERE x0_.order_id = ?"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM xc_tmp_vars t0 WHERE t0.name = ? LIMIT 1"
  "params" => [
    1 => "cloud_search_reg_scheduled"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT x0_.lng_id AS lng_id_0, x0_.code AS code_1, x0_.code3 AS code3_2, x0_.r2l AS r2l_3, x0_.added AS added_4, x0_.enabled AS enabled_5, x0_.module AS module_6 FROM xc_languages x0_ WHERE x0_.added = 1 AND x0_.enabled = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "event" => "deferrer.callback.run"
  "listener" => "XCart\EntityCallback\MembershipCallback::runQuickData"
]

[
  "event" => "deferrer.callback.run"
  "listener" => "XCart\EntityCallback\ProductCallback::runQuickData"
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.lpos = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 495
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 301
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 302
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 313
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 314
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 317
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 321
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 303
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 304
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 305
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 306
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 307
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 308
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 309
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 322
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 310
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 311
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 312
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = ? AND x0_.id <> ? AND x0_.type = ? AND x0_.enabled = ? AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 495
    3 => "P"
    4 => 1
    5 => 474
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 2
    4 => 5
    5 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 301
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 301
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 302
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 302
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 313
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 313
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 501
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 501
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 502
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 502
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 503
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 503
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 504
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 504
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 314
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 314
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 508
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 508
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 509
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 509
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 315
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 315
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 316
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 316
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 317
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 317
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 510
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 510
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 511
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 511
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 512
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 512
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 513
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 513
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 318
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 318
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 319
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 319
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 320
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 320
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 321
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 321
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 514
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 514
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 516
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 516
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 517
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 517
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 518
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 518
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 303
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 303
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 323
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 323
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 324
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 324
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 325
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 325
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 326
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 326
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 338
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 338
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 304
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 304
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 341
  ]
  "types" => [
    1 => 1
  ]
]