Symfony Profiler

[
  "route" => "app_api_getproducts"
  "route_parameters" => [
    "_route" => "app_api_getproducts"
    "_controller" => "App\Controller\ApiController::getProducts"
  ]
  "request_uri" => "http://backend.soft99.ru/api/get/product?id=nano_hard_clear"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "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.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

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

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

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

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

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

[
  "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 p0_.id AS id_0, p0_.title AS title_1, p0_.title_detail AS title_detail_2, p0_.sort AS sort_3, p0_.public AS public_4, p0_.description AS description_5, p0_.features AS features_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.duration AS duration_9, p0_.is_popular AS is_popular_10, p0_.label AS label_11, p0_.label_type AS label_type_12, p0_.static AS static_13, p0_.product_type_id AS product_type_id_14 FROM product p0_ INNER JOIN product_article p1_ ON p0_.id = p1_.product_id AND (p1_.product_id = p0_.id) WHERE (p0_.id LIKE ? OR p1_.link LIKE ?) AND p0_.public = 1"
  "params" => [
    1 => "nano_hard_clear"
    2 => "nano_hard_clear"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.preview AS preview_3, t0.description AS description_4, t0.note AS note_5, t0.detail_time AS detail_time_6, t0.public AS public_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.link AS link_10, t0.title_detail AS title_detail_11, t0.category_id AS category_id_12, t0.video_id AS video_id_13 FROM news t0 INNER JOIN news_product ON t0.id = news_product.news_id WHERE news_product.product_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.public AS public_4, t0.sort AS sort_5 FROM video t0 INNER JOIN product_video ON t0.id = product_video.video_id WHERE product_video.product_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.title_detail AS title_detail_3, t0.sort AS sort_4, t0.public AS public_5, t0.description AS description_6, t0.features AS features_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.duration AS duration_10, t0.is_popular AS is_popular_11, t0.label AS label_12, t0.label_type AS label_type_13, t0.static AS static_14, t0.product_type_id AS product_type_id_15 FROM product t0 INNER JOIN product_video ON t0.id = product_video.product_id WHERE product_video.video_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.preview AS preview_2, n0_.description AS description_3, n0_.note AS note_4, n0_.detail_time AS detail_time_5, n0_.public AS public_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.link AS link_9, n0_.title_detail AS title_detail_10, n0_.category_id AS category_id_11, n0_.video_id AS video_id_12 FROM news n0_ LEFT JOIN news_category n1_ ON (n1_.id = n0_.category_id) INNER JOIN news_product n3_ ON n0_.id = n3_.news_id INNER JOIN product p2_ ON p2_.id = n3_.product_id AND (p2_.id = ?) WHERE n1_.id = 2"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3 FROM product_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 34
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?"
  "params" => [
    1 => 34
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?"
  "params" => [
    1 => 82
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?"
  "params" => [
    1 => 83
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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 = 'soft99' 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 = 'soft99' /*!50116 AND c.CONSTRAINT_SCHEMA = 'soft99' */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 = 'soft99' 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\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

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

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

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

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

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

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

[
  "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\DataCollector\RequestDataCollector::onKernelResponse"
]

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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"
]