Query Metrics
7
Database Queries
7
Different statements
214.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.10 ms (88.18%) |
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 373842 394154 400926 403035 426673 443729 445717 446036 447487 449517 466061 480108 482073 483136 501831 509648 519725 523100 527856 530795 533577 543637 552171 565957 574481 574784 575127 575214 575771 576330 591089 594375 598013 598680 612212 617435 621066 646030 651996 653686 654086 654465 659116 659423 661028 666962 670802 673548 675797 679372 683527 688997 692051 693484 697296 698879 699544 706575 709614 712713 713279 716941 716998 718366 721419 721428 722607 722890 723526 724705 724779 726833 731998 732135 737410 739073 742161 742185 743179 748003 749468 752009 752718 753219 753806 753861 754171 756817 759639 765660 769051 770979 771862 771904 772326 773448 773600 774484 775198 783568 784204 787414 795470 796218 796863 797196 807299 812421 814139 817236 817720 817835 818377 820000 822714 823359 824256 826131 828727 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (6.94%) |
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 446036 443729 675797 574481 598013 447487 482073 501831 509648 527856 519725 575771 523100 823359 688997 693484 721428 722890 659423 712713 722607 721419 565957 621066 742185 752718 773600 731998 742161 739073 753806 749468 426673 817835 822714 723526 820000 824256 817236 817720 826131 826566 828727 533577 659116 683527 699544 651996 661028 670802 673548 692051 698879 709614 716998 718366 653686 713279 594375 774484 795470 796218 797196 783568 787414 724779 743179 756817 772326 773448 784204 724705 726833 754171 737410 752009 748003 753861 765660 771862 771904 753219 775198 796863 812421 480108 646030 612212 807299 598680 400926 449517 445717 483136 576330 654465 679372 706575 666962 697296 770979 732135 769051 617435 716941 403035 552171 591089 759639 394154 373842 818377 814139 466061 530795 543637 575127 574784 575214 654086 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.61%) |
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 373842 394154 400926 403035 426673 443729 445717 446036 447487 449517 466061 480108 482073 483136 501831 509648 519725 523100 527856 530795 533577 543637 552171 565957 574481 574784 575127 575214 575771 576330 591089 594375 598013 598680 612212 617435 621066 646030 651996 653686 654086 654465 659116 659423 661028 666962 670802 673548 675797 679372 683527 688997 692051 693484 697296 698879 699544 706575 709614 712713 713279 716941 716998 718366 721419 721428 722607 722890 723526 724705 724779 726833 731998 732135 737410 739073 742161 742185 743179 748003 749468 752009 752718 753219 753806 753861 754171 756817 759639 765660 769051 770979 771862 771904 772326 773448 773600 774484 775198 783568 784204 787414 795470 796218 796863 797196 807299 812421 814139 817236 817720 817835 818377 820000 822714 823359 824256 826131 828727 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая teen pussy"
]
|
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.