Query Metrics
7
Database Queries
7
Different statements
136.49 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.14 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum loves"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.35 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 564054 590254 596865 618612 788252 766896 724247 619885 407458 463370 447783 469002 421834 457460 470321 421657 509284 518607 484740 505225 509647 513371 517980 525452 511245 495999 517113 434557 440906 443420 503004 543344 557503 560839 564493 571235 667002 591082 439551 455718 463362 463694 439597 482070 412753 422380 452657 476777 478292 445707 439697 478948 502239 510077 517248 494780 512427 514456 512230 520837 527738 438001 439783 535335 461221 573429 565584 621796 601828 782516 438045 439606 426789 486941 577409 564162 624921 588956 439624 493464 519517 486911 452916 458775 497935 547658 618797 516214 ] |
||||||||||||||||||||||||||||||
| 4 | 2.86 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 407458 412753 421657 421834 422380 426789 434557 438001 438045 439551 439597 439606 439624 439697 439783 440906 443420 445707 447783 452657 452916 455718 457460 458775 461221 463362 463370 463694 469002 470321 476777 478292 478948 482070 484740 486911 486941 493464 494780 495999 497935 502239 503004 505225 509284 509647 510077 511245 512230 512427 513371 514456 516214 517113 517248 517980 518607 519517 520837 525452 527738 535335 543344 547658 557503 560839 564054 564162 564493 565584 571235 573429 577409 588956 590254 591082 596865 601828 618612 618797 619885 621796 624921 667002 724247 766896 782516 788252 ] |
||||||||||||||||||||||||||||||
| 5 | 113.45 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 407458 412753 421657 421834 422380 426789 434557 438001 438045 439551 439597 439606 439624 439697 439783 440906 443420 445707 447783 452657 452916 455718 457460 458775 461221 463362 463370 463694 469002 470321 476777 478292 478948 482070 484740 486911 486941 493464 494780 495999 497935 502239 503004 505225 509284 509647 510077 511245 512230 512427 513371 514456 516214 517113 517248 517980 518607 519517 520837 525452 527738 535335 543344 547658 557503 560839 564054 564162 564493 565584 571235 573429 577409 588956 590254 591082 596865 601828 618612 618797 619885 621796 624921 667002 724247 766896 782516 788252 ] |
||||||||||||||||||||||||||||||
| 6 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum loves"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum loves"
]
|
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.