Query Metrics
7
Database Queries
7
Different statements
182.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.34 ms (85.70%) |
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 384547 402735 408429 413093 413685 417491 417952 419030 422415 426357 427006 429960 432514 432552 435706 436132 437635 439033 441020 444912 444937 448587 452923 454842 455585 456567 457134 460343 465815 470090 470137 470205 477386 491718 494386 496061 496698 496750 522288 530292 533667 533777 534117 535634 537974 539238 543533 543540 543717 543719 543727 543745 543829 545185 574606 575127 579049 595455 595517 595521 596649 598141 598197 598448 598543 598549 598597 598728 605829 608438 610346 614566 618769 623440 625405 626083 626255 643590 655504 656545 683303 688939 694164 705809 713369 714656 715627 720164 731043 731581 734189 735115 745336 751692 768042 768715 769198 775574 777080 778256 781331 786093 787484 790446 794003 799900 800305 800487 801978 819940 821845 825705 828442 828560 828657 828763 828780 828786 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (9.47%) |
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 470137 470205 432552 435706 439033 441020 444937 448587 427006 530292 598728 805492 800487 595521 787484 408429 384547 537974 543727 437635 543533 539238 643590 778256 731043 470090 543719 786093 768042 534117 828763 768715 781331 429960 417952 496750 543829 705809 777080 801978 800305 751692 402735 465815 419030 432514 456567 460343 575127 494386 598448 610346 714656 422415 828786 828560 595517 457134 683303 713369 656545 626083 595455 598549 794003 775574 596649 436132 452923 426357 454842 417491 522288 491718 715627 477386 496698 545185 655504 688939 605829 625405 608438 825705 821845 769198 745336 828780 828657 828442 790446 496061 533777 598197 614566 799900 805512 734189 543717 598597 819940 694164 579049 598543 618769 735115 731581 543745 413093 533667 535634 543540 413685 455585 574606 720164 623440 598141 626255 444912 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.49%) |
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 384547 402735 408429 413093 413685 417491 417952 419030 422415 426357 427006 429960 432514 432552 435706 436132 437635 439033 441020 444912 444937 448587 452923 454842 455585 456567 457134 460343 465815 470090 470137 470205 477386 491718 494386 496061 496698 496750 522288 530292 533667 533777 534117 535634 537974 539238 543533 543540 543717 543719 543727 543745 543829 545185 574606 575127 579049 595455 595517 595521 596649 598141 598197 598448 598543 598549 598597 598728 605829 608438 610346 614566 618769 623440 625405 626083 626255 643590 655504 656545 683303 688939 694164 705809 713369 714656 715627 720164 731043 731581 734189 735115 745336 751692 768042 768715 769198 775574 777080 778256 781331 786093 787484 790446 794003 799900 800305 800487 801978 819940 821845 825705 828442 828560 828657 828763 828780 828786 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur russian teen"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск русск teen"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск русск teen"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.75%) |
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.