Query Metrics
7
Database Queries
7
Different statements
209.01 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.78 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"his cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.61 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 653809 683679 588110 811812 764815 766926 801442 650622 719780 559044 826734 486230 773150 471626 502324 496101 574095 564166 568078 423731 444346 815143 828006 647468 687644 667270 668849 646610 606090 741606 761261 738571 745164 722067 789633 563218 823753 689972 781566 783370 768932 747068 783634 813850 696992 533435 664964 652649 663377 714376 670418 641599 800171 743791 731727 755366 759000 741102 744600 749277 761586 620759 719963 723116 783106 811355 523026 529664 530600 687056 708638 735609 530263 541107 638113 794171 801061 790144 800603 732096 739437 768818 798847 802310 817828 739051 815932 538806 528513 530234 665833 634298 597688 778665 788502 727388 739686 765953 633846 639598 705385 792773 608376 620263 626566 778212 809143 811126 792398 745892 771281 765911 771269 750797 773817 730297 697005 797094 426234 802390 ] |
||||||||||||||||||||||||||||||
| 4 | 2.93 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 423731 426234 444346 471626 486230 496101 502324 523026 528513 529664 530234 530263 530600 533435 538806 541107 559044 563218 564166 568078 574095 588110 597688 606090 608376 620263 620759 626566 633846 634298 638113 639598 641599 646610 647468 650622 652649 653809 663377 664964 665833 667270 668849 670418 683679 687056 687644 689972 696992 697005 705385 708638 714376 719780 719963 722067 723116 727388 730297 731727 732096 735609 738571 739051 739437 739686 741102 741606 743791 744600 745164 745892 747068 749277 750797 755366 759000 761261 761586 764815 765911 765953 766926 768818 768932 771269 771281 773150 773817 778212 778665 781566 783106 783370 783634 788502 789633 790144 792398 792773 794171 797094 798847 800171 800603 801061 801442 802310 802390 809143 811126 811355 811812 813850 815143 815932 817828 823753 826734 828006 ] |
||||||||||||||||||||||||||||||
| 5 | 185.00 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 423731 426234 444346 471626 486230 496101 502324 523026 528513 529664 530234 530263 530600 533435 538806 541107 559044 563218 564166 568078 574095 588110 597688 606090 608376 620263 620759 626566 633846 634298 638113 639598 641599 646610 647468 650622 652649 653809 663377 664964 665833 667270 668849 670418 683679 687056 687644 689972 696992 697005 705385 708638 714376 719780 719963 722067 723116 727388 730297 731727 732096 735609 738571 739051 739437 739686 741102 741606 743791 744600 745164 745892 747068 749277 750797 755366 759000 761261 761586 764815 765911 765953 766926 768818 768932 771269 771281 773150 773817 778212 778665 781566 783106 783370 783634 788502 789633 790144 792398 792773 794171 797094 798847 800171 800603 801061 801442 802310 802390 809143 811126 811355 811812 813850 815143 815932 817828 823753 826734 828006 ] |
||||||||||||||||||||||||||||||
| 6 | 1.75 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"his cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.66 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"his cock"
]
|
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.