Symfony Profiler

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Core\EventListener\LocaleFallbackSubscriber::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" => "App\Core\EventListener\AppEventListener::onKernelRequest"
]

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

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

[
  "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"
]

[
  "sql" => "SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "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 DISTINCT id_6 FROM (SELECT DISTINCT id_6, position_4 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_4 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20, a0_.thumbnail_id AS thumbnail_id_21, a0_.author_id AS author_id_22, a1_.entity_id AS entity_id_23 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 6
    2 => 7
    3 => 8
    4 => 9
    5 => 10
    6 => 11
    7 => 12
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 127
    2 => 69
    3 => 129
    4 => 79
    5 => 80
    6 => 73
    7 => 128
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "param.app.main.phone.number"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "param.app.main.email.contact"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22, a0_.author_id AS author_id_23, a1_.entity_id AS entity_id_24 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 9
    2 => 10
    3 => 11
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '9' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '9' AND a0_.deleted = 0 AND a0_.id IN (?, ?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 10
    2 => 32
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?)"
  "params" => [
    1 => 76
    2 => 67
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?)"
  "params" => [
    1 => 10
    2 => 32
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '9' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '10' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '10' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 15
    2 => 16
    3 => 40
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?)"
  "params" => [
    1 => 60
    2 => 135
    3 => 207
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?)"
  "params" => [
    1 => 15
    2 => 16
    3 => 40
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '10' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '11' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '11' AND a0_.deleted = 0 AND a0_.id IN (?, ?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 1
    2 => 18
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?)"
  "params" => [
    1 => 47
    2 => 662
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?)"
  "params" => [
    1 => 1
    2 => 18
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id = '11' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10"
]

[
  "sql" => "SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?) ORDER BY a0_.position ASC"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]