Query Metrics
7
Database Queries
7
Different statements
149.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.79 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.21 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up bbc"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.98 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 417056 428387 568305 421537 421564 420768 417053 420139 429804 723620 814991 500913 540626 520068 565460 540984 542566 676091 675515 676110 679816 678066 549992 565102 598622 602008 620726 644718 615711 632692 443476 449356 475479 425118 487150 492535 493963 497885 443636 420203 420760 414341 429761 510591 532380 555798 565364 573479 571841 677781 689010 678529 613566 632006 616411 756469 426417 478527 416166 417829 421250 419862 423675 424876 510198 481147 483319 576529 678504 704235 679004 499111 583507 677783 500716 434712 552969 677777 608658 445641 529567 531560 529266 679019 ] |
||||||||||||||||||||||||||||||
| 4 | 2.75 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 414341 416166 417053 417056 417829 419862 420139 420203 420760 420768 421250 421537 421564 423675 424876 425118 426417 428387 429761 429804 434712 443476 443636 445641 449356 475479 478527 481147 483319 487150 492535 493963 497885 499111 500716 500913 510198 510591 520068 529266 529567 531560 532380 540626 540984 542566 549992 552969 555798 565102 565364 565460 568305 571841 573479 576529 583507 598622 602008 608658 613566 615711 616411 620726 632006 632692 644718 675515 676091 676110 677777 677781 677783 678066 678504 678529 679004 679019 679816 689010 704235 723620 756469 814991 ] |
||||||||||||||||||||||||||||||
| 5 | 124.85 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 414341 416166 417053 417056 417829 419862 420139 420203 420760 420768 421250 421537 421564 423675 424876 425118 426417 428387 429761 429804 434712 443476 443636 445641 449356 475479 478527 481147 483319 487150 492535 493963 497885 499111 500716 500913 510198 510591 520068 529266 529567 531560 532380 540626 540984 542566 549992 552969 555798 565102 565364 565460 568305 571841 573479 576529 583507 598622 602008 608658 613566 615711 616411 620726 632006 632692 644718 675515 676091 676110 677777 677781 677783 678066 678504 678529 679004 679019 679816 689010 704235 723620 756469 814991 ] |
||||||||||||||||||||||||||||||
| 6 | 1.62 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up bbc"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.32 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up bbc"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.