Symfony Profiler

[
  "route" => "app_blo_home_index"
  "route_parameters" => [
    "_route" => "app_blo_home_index"
    "_controller" => "App\Controller\Blo\HomeController::index"
  ]
  "request_uri" => "https://www.globalafricabusiness.com/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

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

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u407703795_sogoba"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "u407703795_sogoba"
    "charset" => "utf8mb4"
  ]
]

[
  "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 b0_.id AS id_0, b0_.position AS position_1, b0_.title_override AS title_override_2, b0_.subtitle_override AS subtitle_override_3, b0_.background_image AS background_image_4, b0_.active AS active_5, b1_.id AS id_6, b1_.title AS title_7, b1_.slug AS slug_8, b1_.description AS description_9, b1_.price AS price_10, b1_.promo_price AS promo_price_11, b1_.sku AS sku_12, b1_.stock_qty AS stock_qty_13, b1_.status AS status_14, b1_.product_type AS product_type_15, b1_.currency AS currency_16, b1_.created_at AS created_at_17, b1_.updated_at AS updated_at_18, b0_.product_id AS product_id_19, b1_.shop_id AS shop_id_20, b1_.category_id AS category_id_21 FROM blo_home_slider_item b0_ LEFT JOIN blo_product b1_ ON b0_.product_id = b1_.id WHERE b0_.active = ? ORDER BY b0_.position ASC, b0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.price AS price_4, b0_.promo_price AS promo_price_5, b0_.sku AS sku_6, b0_.stock_qty AS stock_qty_7, b0_.status AS status_8, b0_.product_type AS product_type_9, b0_.currency AS currency_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.shop_id AS shop_id_13, b0_.category_id AS category_id_14 FROM blo_product b0_ INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id WHERE b0_.status = ? AND b1_.status = ? AND b0_.promo_price IS NOT NULL AND b0_.promo_price > 0 ORDER BY b0_.updated_at DESC LIMIT 8"
  "params" => [
    1 => "APPROVED"
    2 => "ACTIVE"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.price AS price_4, b0_.promo_price AS promo_price_5, b0_.sku AS sku_6, b0_.stock_qty AS stock_qty_7, b0_.status AS status_8, b0_.product_type AS product_type_9, b0_.currency AS currency_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.shop_id AS shop_id_13, b0_.category_id AS category_id_14 FROM blo_product b0_ INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id WHERE b0_.status = ? AND b1_.status = ? ORDER BY b0_.created_at DESC LIMIT 8"
  "params" => [
    1 => "APPROVED"
    2 => "ACTIVE"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.price AS price_4, b0_.promo_price AS promo_price_5, b0_.sku AS sku_6, b0_.stock_qty AS stock_qty_7, b0_.status AS status_8, b0_.product_type AS product_type_9, b0_.currency AS currency_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.shop_id AS shop_id_13, b0_.category_id AS category_id_14 FROM blo_product b0_ INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id WHERE b0_.status = ? AND b1_.status = ? ORDER BY b0_.created_at DESC LIMIT 8"
  "params" => [
    1 => "APPROVED"
    2 => "ACTIVE"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM blo_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC, t0.name ASC"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.cout AS cout_2, p0_.prix AS prix_3, p0_.statut AS statut_4, p0_.stock AS stock_5, p0_.image AS image_6, p0_.quantite_alerte AS quantite_alerte_7, p0_.date_expiration AS date_expiration_8, p0_.user_id AS user_id_9 FROM produit p0_ WHERE p0_.stock <= p0_.quantite_alerte AND p0_.statut = 0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM blo_site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "site_logo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM blo_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC, t0.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM blo_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC, t0.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.customer_id AS customer_id_5 FROM blo_cart t0 WHERE t0.session_id = ? LIMIT 1"
  "params" => [
    1 => "bv93nc4aonqmg7m66111jvs52m"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM blo_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC, t0.name ASC"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

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

[
  "sql" => "SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'u407703795_sogoba' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC"
]

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

[
  "sql" => "SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'u407703795_sogoba' /*!50116 AND c.CONSTRAINT_SCHEMA = 'u407703795_sogoba' */ORDER BY k.ORDINAL_POSITION"
]

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

[
  "sql" => "SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'u407703795_sogoba' ORDER BY SEQ_IN_INDEX ASC"
]

[
  "sql" => """
    SELECT 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\n
    WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
    """
]

[
  "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\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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]