Query Metrics
7
Database Queries
7
Different statements
247.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.35 ms (88.92%) |
1 |
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 69739 81709 147400 150289 181905 314894 361992 385234 391872 401453 414711 417999 420371 421204 422005 427266 428280 428335 431506 434075 445969 446783 447813 450448 452413 454814 456813 457341 461758 461767 462783 463445 464186 464599 468310 469616 474322 474325 475661 475797 484255 486637 487748 490807 490813 491299 491738 493967 495757 496831 499182 500891 501281 504336 508265 511674 513158 514048 516486 517475 517680 519104 519213 521595 522626 524139 525733 525791 527465 527619 529400 538017 541370 542587 543553 543614 547554 553406 556747 558197 558226 558574 559454 562973 567375 568714 571509 583037 588281 588656 593880 599571 619501 621289 622770 624841 630414 643071 666940 695596 718891 725192 729641 735520 737101 740815 757089 757456 757484 758658 776216 778724 793885 801993 802231 819690 819711 823749 826624 827394 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (6.61%) |
1 |
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 452413 463445 464599 496831 521595 490813 517475 474322 547554 571509 588281 593880 447813 525791 511674 519104 513158 543553 583037 542587 417999 524139 517680 469616 420371 414711 622770 802231 729641 801993 757089 793885 150289 81709 314894 391872 508265 422005 427266 464186 474325 484255 454814 462783 446783 525733 461758 538017 695596 559454 562973 493967 666940 385234 434075 487748 445969 778724 757484 475661 361992 819690 823749 827394 819711 826624 553406 599571 776216 725192 735520 758658 737101 757456 181905 428280 495757 529400 558574 567375 568714 556747 558197 619501 630414 421204 456813 457341 486637 491299 519213 504336 588656 522626 491738 516486 527465 499182 543614 541370 624841 69739 501281 558226 718891 621289 643071 740815 147400 500891 514048 490807 428335 450448 468310 401453 475797 527619 461767 431506 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.20%) |
1 |
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 69739 81709 147400 150289 181905 314894 361992 385234 391872 401453 414711 417999 420371 421204 422005 427266 428280 428335 431506 434075 445969 446783 447813 450448 452413 454814 456813 457341 461758 461767 462783 463445 464186 464599 468310 469616 474322 474325 475661 475797 484255 486637 487748 490807 490813 491299 491738 493967 495757 496831 499182 500891 501281 504336 508265 511674 513158 514048 516486 517475 517680 519104 519213 521595 522626 524139 525733 525791 527465 527619 529400 538017 541370 542587 543553 543614 547554 553406 556747 558197 558226 558574 559454 562973 567375 568714 571509 583037 588281 588656 593880 599571 619501 621289 622770 624841 630414 643071 666940 695596 718891 725192 729641 735520 737101 740815 757089 757456 757484 758658 776216 778724 793885 801993 802231 819690 819711 823749 826624 827394 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina compilation"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин подборк"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин подборк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.