Symfony Profiler

[
  "route" => "home_page"
  "route_parameters" => [
    "_route" => "home_page"
    "_controller" => "App\Controller\HomePageController::index"
  ]
  "request_uri" => "https://dev.fluid.vet/"
  "method" => "GET"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::handleLegacyEaContext"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::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"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.7"
    "defaultTableOptions" => []
    "dbname" => "fluid_dev"
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.alt AS alt_2, b0_.modified AS modified_3, b0_.created AS created_4, b0_.is_published AS is_published_5, b0_.is_default AS is_default_6, b0_.order_by AS order_by_7, b0_.caption AS caption_8, b0_.page_id AS page_id_9 FROM banners b0_ WHERE b0_.is_published = 1 AND b0_.page_id = 1 ORDER BY b0_.is_default DESC, b0_.order_by ASC"
]

[
  "sql" => "SELECT RAND() AS sclr_0, p0_.id AS id_1, p0_.is_published AS is_published_2, p0_.name AS name_3, p0_.active_ingredient AS active_ingredient_4, p0_.image AS image_5, p0_.description AS description_6, p0_.dosage AS dosage_7, p0_.size AS size_8, p0_.form AS form_9, p0_.unit AS unit_10, p0_.unit_price AS unit_price_11, p0_.stock_count AS stock_count_12, p0_.modified AS modified_13, p0_.created AS created_14, p0_.sku AS sku_15, p0_.expiry_date_required AS expiry_date_required_16, p0_.tags AS tags_17, p0_.slug AS slug_18, p0_.is_active AS is_active_19, p0_.price_from AS price_from_20, p0_.dosage_unit AS dosage_unit_21, p0_.manufacturer_ids AS manufacturer_ids_22, p0_.is_controlled AS is_controlled_23, d1_.id AS id_24, d1_.sku AS sku_25, d1_.unit_price AS unit_price_26, d1_.stock_count AS stock_count_27, d1_.expiry_date AS expiry_date_28, d1_.tax_exempt AS tax_exempt_29, d1_.modified AS modified_30, d1_.created AS created_31, d1_.is_active AS is_active_32, d1_.item_id AS item_id_33, d2_.id AS id_34, d2_.distributor_name AS distributor_name_35, d2_.logo AS logo_36, d2_.telephone AS telephone_37, d2_.email AS email_38, d2_.website AS website_39, d2_.about AS about_40, d2_.operating_hours AS operating_hours_41, d2_.refund_policy AS refund_policy_42, d2_.sales_tax_policy AS sales_tax_policy_43, d2_.is_manufaturer AS is_manufaturer_44, d2_.theme_id AS theme_id_45, d2_.modified AS modified_46, d2_.created AS created_47, d2_.po_number_prefix AS po_number_prefix_48, d2_.address_street AS address_street_49, d2_.address_city AS address_city_50, d2_.address_postal_code AS address_postal_code_51, d2_.address_state AS address_state_52, d2_.shipping_policy AS shipping_policy_53, d2_.iso_code AS iso_code_54, d2_.intl_code AS intl_code_55, d2_.hashed_email AS hashed_email_56, d2_.domain_name AS domain_name_57, d2_.is_approved AS is_approved_58, d2_.manager_first_name AS manager_first_name_59, d2_.manager_last_name AS manager_last_name_60, d2_.trade_license AS trade_license_61, d2_.trade_license_no AS trade_license_no_62, d2_.trade_license_exp_date AS trade_license_exp_date_63, d2_.manager_id_no AS manager_id_no_64, d2_.manager_id_exp_date AS manager_id_exp_date_65, c3_.id AS id_66, c3_.name AS name_67, c3_.tags AS tags_68, c3_.modified AS modified_69, c3_.created AS created_70, c3_.slug AS slug_71, c3_.product_count AS product_count_72, p4_.id AS id_73, p5_.id AS id_74, p5_.image AS image_75, p5_.modified AS modified_76, p5_.created AS created_77, p5_.is_default AS is_default_78, p5_.file_type AS file_type_79, p0_.sub_category_id AS sub_category_id_80, p0_.category2_id AS category2_id_81, p0_.category3_id AS category3_id_82, p0_.category_id AS category_id_83, d1_.distributor_id AS distributor_id_84, d1_.product_id AS product_id_85, d2_.address_country_id AS address_country_id_86, d2_.tracking_id AS tracking_id_87, p4_.products_id AS products_id_88, p4_.manufacturers_id AS manufacturers_id_89, p5_.product_id AS product_id_90 FROM products p0_ INNER JOIN distributor_products d1_ ON p0_.id = d1_.product_id INNER JOIN distributors d2_ ON d1_.distributor_id = d2_.id LEFT JOIN categories1 c3_ ON p0_.category_id = c3_.id LEFT JOIN product_manufacturers p4_ ON p0_.id = p4_.products_id LEFT JOIN product_favourites p6_ ON p0_.id = p6_.product_id LEFT JOIN product_images p5_ ON p0_.id = p5_.product_id WHERE p5_.is_default = 1 AND p0_.is_active = 1 AND p0_.is_published = 1 AND d1_.unit_price > 0 AND p0_.price_from > 0 ORDER BY sclr_0 ASC LIMIT 10"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "fluid_dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "fluid_dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               t.ENGINE,\n
               t.AUTO_INCREMENT,\n
               t.TABLE_COMMENT,\n
               t.CREATE_OPTIONS,\n
               t.TABLE_COLLATION,\n
               ccsa.CHARACTER_SET_NAME\n
          FROM information_schema.TABLES t\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n
                ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "fluid_dev"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
    AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'fluid_dev' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "fluid_dev"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\n
           c.COLUMN_TYPE       AS type,\n
           c.IS_NULLABLE        AS `null`,\n
           c.COLUMN_KEY         AS `key`,\n
           c.COLUMN_DEFAULT     AS `default`,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT     AS comment,\n
           c.CHARACTER_SET_NAME AS characterset,\n
           c.COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS c\n
        INNER JOIN information_schema.TABLES t\n
            ON t.TABLE_NAME = c.TABLE_NAME\n
         WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "fluid_dev"
    2 => "fluid_dev"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "fluid_dev"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DATABASE()"
]

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

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

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