User Deprecated: Class "Doctrine\ORM\Proxy\Autoloader" is deprecated. Use native lazy objects instead. (Autoloader.php:74 called by DoctrineBundle.php:136, https://github.com/doctrine/orm/pull/12005, package doctrine/orm)
User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal)
"SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.active AS active_3 FROM media m0_"
doctrine
[
"sql" => "SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.active AS active_3 FROM media m0_"
]
debug
Executing statement:
"SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.is_video AS is_video_5, i0_.active AS active_6, i0_.image AS image_7 FROM item i0_ LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id LEFT JOIN media m1_ ON m1_.id = m2_.media_id LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id LEFT JOIN category c3_ ON c3_.id = c4_.category_id WHERE m1_.id = ? AND c3_.id = ?"
[
"sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.is_video AS is_video_5, i0_.active AS active_6, i0_.image AS image_7 FROM item i0_ LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id LEFT JOIN media m1_ ON m1_.id = m2_.media_id LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id LEFT JOIN category c3_ ON c3_.id = c4_.category_id WHERE m1_.id = ? AND c3_.id = ?"
"params" => [1 => 32 => "7"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
2 => Doctrine\DBAL\ParameterType {#1010
+name: "STRING"
}
]
]
debug
Executing query:
"SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 GROUP BY i0_.id ORDER BY sclr_8 DESC LIMIT 9"
doctrine
[
"sql" => "SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 GROUP BY i0_.id ORDER BY sclr_8 DESC LIMIT 9"
]
debug
Executing statement:
"SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2 FROM category c0_ WHERE c0_.id = ?"
[
"sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2 FROM category c0_ WHERE c0_.id = ?"
"params" => [1 => "7"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#1010
+name: "STRING"
}
]
]
deprecation
User Deprecated: Since symfony/ux-stimulus-bundle 2.13.0: Calling ux_controller_link_tags() is deprecated and does nothing with symfony/asset-mapper 6.4. The link tags are rendered automatically via the importmap() function.
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 8]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 10]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 12]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 13]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 17]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 33]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 37]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 40]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?"
"params" => [1 => 44]
"types" => [1 => Doctrine\DBAL\ParameterType {#1054
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?"