Symfony Profiler

[
  "route" => "api_public_products_show_by_slug"
  "route_parameters" => [
    "_route" => "api_public_products_show_by_slug"
    "_controller" => "App\Controller\Api\PublicProductApiController::showBySlug"
    "slug" => "les-oiseaux"
  ]
  "request_uri" => "https://dev.admin.maisonmyel.com/api/public/products/les-oiseaux?amp%253D%2526locale%25253Dfr%253D%3D="
  "method" => "GET"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\MaintenanceListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

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

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

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

[
  "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" => "ContainerU78maTd\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mariadb-dev"
    "port" => 3306
    "user" => "maisonmyel"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "maisonmyel"
    "serverVersion" => "11.4.0-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.price AS price_6, t0.sale_price AS sale_price_7, t0.original_price AS original_price_8, t0.rating AS rating_9, t0.review_count AS review_count_10, t0.in_stock AS in_stock_11, t0.stock_quantity AS stock_quantity_12, t0.low_stock_threshold AS low_stock_threshold_13, t0.tags AS tags_14, t0.weight AS weight_15, t0.length AS length_16, t0.width AS width_17, t0.height AS height_18, t0.sku AS sku_19, t0.reference AS reference_20, t0.is_featured AS is_featured_21, t0.status AS status_22, t0.product_type AS product_type_23, t0.product_condition AS product_condition_24, t0.disabled_for_return AS disabled_for_return_25, t0.is_made_to_order AS is_made_to_order_26, t0.production_notes AS production_notes_27, t0.production_duration AS production_duration_28, t0.production_duration_unit AS production_duration_unit_29, t0.show_price AS show_price_30, t0.only_contact AS only_contact_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.vendor_id AS vendor_id_34, t0.category_id AS category_id_35, t0.main_image_id AS main_image_id_36 FROM product t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1"
  "params" => [
    1 => "les-oiseaux"
    2 => "PUBLISHED"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.email AS email_6, t0.phone AS phone_7, t0.website AS website_8, t0.rating AS rating_9, t0.total_reviews AS total_reviews_10, t0.total_products AS total_products_11, t0.total_sales AS total_sales_12, t0.total_revenue AS total_revenue_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.is_verified AS is_verified_16, t0.is_approved AS is_approved_17, t0.is_active AS is_active_18, t0.is_public AS is_public_19, t0.status AS status_20, t0.settings AS settings_21, t0.location AS location_22, t0.address AS address_23, t0.bank_info AS bank_info_24, t0.shipping_options AS shipping_options_25, t0.member_since AS member_since_26, t0.user_id AS user_id_27, t0.logo_image_id AS logo_image_id_28, t0.banner_image_id AS banner_image_id_29, t0.main_image_id AS main_image_id_30, t0.avatar_image_id AS avatar_image_id_31, t0.country_id AS country_id_32, t33.id AS id_34, t33.vendor_name AS vendor_name_35, t33.drive_folder_id AS drive_folder_id_36, t33.drive_folder_name AS drive_folder_name_37, t33.products_csv_id AS products_csv_id_38, t33.products_csv_name AS products_csv_name_39, t33.images_folder_id AS images_folder_id_40, t33.images_folder_name AS images_folder_name_41, t33.is_active AS is_active_42, t33.auto_sync AS auto_sync_43, t33.last_sync AS last_sync_44, t33.total_products AS total_products_45, t33.total_images AS total_images_46, t33.sync_status AS sync_status_47, t33.created_at AS created_at_48, t33.updated_at AS updated_at_49, t33.vendor_id AS vendor_id_50, t0.biography_pdf AS biography_pdf_51 FROM vendor t0 LEFT JOIN drive_vendor_folder t33 ON t33.vendor_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.url AS url_4, t0.type AS type_5, t0.mime_type AS mime_type_6, t0.size AS size_7, t0.dimensions AS dimensions_8, t0.uploaded_at AS uploaded_at_9, t0.entity_type AS entity_type_10, t0.entity_id AS entity_id_11, t0.role AS role_12, t0.position AS position_13, t0.title AS title_14, t0.alt AS alt_15, t0.caption AS caption_16, t0.original_checksum AS original_checksum_17, t0.optimized_filename AS optimized_filename_18, t0.optimized_url AS optimized_url_19, t0.optimized_size AS optimized_size_20, t0.optimized_dimensions AS optimized_dimensions_21, t0.optimized_at AS optimized_at_22, t0.optimized_max_width AS optimized_max_width_23, t0.uploaded_by_id AS uploaded_by_id_24, t0.product_id AS product_id_25, t0.warehouse_id AS warehouse_id_26, t0.product_variant_id AS product_variant_id_27 FROM media t0 WHERE t0.id = ?"
  "params" => [
    1 => 8082
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.url AS url_4, t0.type AS type_5, t0.mime_type AS mime_type_6, t0.size AS size_7, t0.dimensions AS dimensions_8, t0.uploaded_at AS uploaded_at_9, t0.entity_type AS entity_type_10, t0.entity_id AS entity_id_11, t0.role AS role_12, t0.position AS position_13, t0.title AS title_14, t0.alt AS alt_15, t0.caption AS caption_16, t0.original_checksum AS original_checksum_17, t0.optimized_filename AS optimized_filename_18, t0.optimized_url AS optimized_url_19, t0.optimized_size AS optimized_size_20, t0.optimized_dimensions AS optimized_dimensions_21, t0.optimized_at AS optimized_at_22, t0.optimized_max_width AS optimized_max_width_23, t0.uploaded_by_id AS uploaded_by_id_24, t0.product_id AS product_id_25, t0.warehouse_id AS warehouse_id_26, t0.product_variant_id AS product_variant_id_27 FROM media t0 WHERE t0.id = ?"
  "params" => [
    1 => 572
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.banner_image_id AS banner_image_id_4, t0.icon AS icon_5, t0.slug AS slug_6, t0.color AS color_7, t0.is_active AS is_active_8, t0.product_count AS product_count_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.url AS url_4, t0.type AS type_5, t0.mime_type AS mime_type_6, t0.size AS size_7, t0.dimensions AS dimensions_8, t0.uploaded_at AS uploaded_at_9, t0.entity_type AS entity_type_10, t0.entity_id AS entity_id_11, t0.role AS role_12, t0.position AS position_13, t0.title AS title_14, t0.alt AS alt_15, t0.caption AS caption_16, t0.original_checksum AS original_checksum_17, t0.optimized_filename AS optimized_filename_18, t0.optimized_url AS optimized_url_19, t0.optimized_size AS optimized_size_20, t0.optimized_dimensions AS optimized_dimensions_21, t0.optimized_at AS optimized_at_22, t0.optimized_max_width AS optimized_max_width_23, t0.uploaded_by_id AS uploaded_by_id_24, t0.product_id AS product_id_25, t0.warehouse_id AS warehouse_id_26, t0.product_variant_id AS product_variant_id_27 FROM media t0 WHERE t0.id = ?"
  "params" => [
    1 => 2445
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT \n
                    m.id as image_id, \n
                    m.url as image_url, \n
                    m.filename as image_filename,\n
                    m.alt as image_alt\n
                FROM media m\n
                WHERE m.entity_type = 'product' \n
                AND m.role = 'gallery' \n
                AND m.entity_id = ?\n
                ORDER BY m.id ASC\n
            
    """
  "params" => [
    1 => 206
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.required AS required_6, t0.searchable AS searchable_7, t0.filterable AS filterable_8, t0.visible AS visible_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM product_attribute t0 INNER JOIN product_attribute_assignment ON t0.id = product_attribute_assignment.product_attribute_id WHERE product_attribute_assignment.product_id = ?"
  "params" => [
    1 => 206
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.label AS label_3, t0.color AS color_4, t0.sort_order AS sort_order_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.attribute_id AS attribute_id_9 FROM product_attribute_value t0 WHERE t0.attribute_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sku AS sku_2, t0.description AS description_3, t0.attributes AS attributes_4, t0.price_cents AS price_cents_5, t0.compare_at_price_cents AS compare_at_price_cents_6, t0.tax_rate AS tax_rate_7, t0.weight_grams AS weight_grams_8, t0.dimensions AS dimensions_9, t0.production_days AS production_days_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.product_id AS product_id_14, t15.id AS id_16, t15.quantity AS quantity_17, t15.low_stock_threshold AS low_stock_threshold_18, t15.updated_at AS updated_at_19, t15.variant_id AS variant_id_20, t0.main_image_id AS main_image_id_21 FROM product_variant t0 LEFT JOIN inventory t15 ON t15.variant_id = t0.id WHERE t0.product_id = ?"
  "params" => [
    1 => 206
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.label AS label_3, t0.color AS color_4, t0.sort_order AS sort_order_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.attribute_id AS attribute_id_9 FROM product_attribute_value t0 WHERE t0.attribute_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                SELECT \n
                    m.id as image_id, \n
                    m.url as image_url, \n
                    m.filename as image_filename,\n
                    m.alt as image_alt\n
                FROM media m\n
                WHERE m.entity_type = 'product_variant'\n
                AND m.entity_id = ?\n
                AND m.role = 'gallery'\n
                ORDER BY m.id ASC\n
            
    """
  "params" => [
    1 => 287
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.owner_type AS owner_type_1, s0_.owner_id AS owner_id_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.meta_robots AS meta_robots_5, s0_.canonical_url AS canonical_url_6, s0_.og_title AS og_title_7, s0_.og_description AS og_description_8, s0_.og_image_url AS og_image_url_9, s0_.twitter_card AS twitter_card_10, s0_.hreflangs AS hreflangs_11, s0_.schema_json_ld AS schema_json_ld_12, s0_.sitemap_priority AS sitemap_priority_13, s0_.sitemap_change_freq AS sitemap_change_freq_14, s0_.custom_meta AS custom_meta_15, s0_.noindex AS noindex_16, s0_.noarchive AS noarchive_17, s0_.last_audited_at AS last_audited_at_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20 FROM seo s0_ WHERE s0_.owner_type = ? AND s0_.owner_id = ?"
  "params" => [
    1 => "product"
    2 => 206
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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