Query Metrics
7
Database Queries
7
Different statements
163.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.40 ms (85.23%) |
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 465002 488223 499396 500818 504750 505929 513759 517675 523199 524039 530399 530442 533244 533435 534579 534763 536196 536896 538169 540062 542246 543899 546227 552156 553470 565702 579204 584347 586741 590154 590163 601649 602129 614900 616183 617096 617536 617760 622319 623425 623755 626296 627772 630086 630621 630999 634326 635791 641267 641599 645730 651535 651565 653680 653693 660317 667147 668145 668812 668964 669564 670606 677180 677258 688483 698788 702936 703328 704291 707511 707673 708150 708901 714367 714799 716845 718328 718594 720283 723091 724547 725055 725333 726308 728511 728912 733361 734457 735311 736298 738875 739707 741812 744680 747562 748076 748437 748586 750339 753238 754000 757610 762219 762258 762348 767694 771738 773751 780098 805297 819209 819738 821791 823849 823972 824881 825957 826730 827341 828099 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (8.52%) |
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 586741 630086 623425 826730 819209 819738 823972 767694 733361 734457 825957 530399 728511 824881 823849 725055 754000 762258 736298 762219 724547 747562 728912 748437 771738 707511 688483 465002 505929 536196 500818 533244 513759 523199 533435 540062 553470 565702 542246 668964 677180 698788 708901 714799 723091 651565 653680 668145 704291 716845 718328 645730 651535 653693 660317 668812 670606 677258 702936 703328 602129 641599 590163 616183 635791 590154 627772 626296 630999 748076 614900 617096 617760 534579 821791 828099 827341 543899 718594 725333 750339 735311 726308 738875 757610 739707 741812 762348 744680 748586 753238 773751 720283 780098 805297 504750 530442 534763 536896 517675 524039 538169 552156 579204 584347 669564 667147 707673 714367 623755 641267 622319 601649 617536 634326 630621 708150 488223 499396 546227 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (2.41%) |
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 465002 488223 499396 500818 504750 505929 513759 517675 523199 524039 530399 530442 533244 533435 534579 534763 536196 536896 538169 540062 542246 543899 546227 552156 553470 565702 579204 584347 586741 590154 590163 601649 602129 614900 616183 617096 617536 617760 622319 623425 623755 626296 627772 630086 630621 630999 634326 635791 641267 641599 645730 651535 651565 653680 653693 660317 667147 668145 668812 668964 669564 670606 677180 677258 688483 698788 702936 703328 704291 707511 707673 708150 708901 714367 714799 716845 718328 718594 720283 723091 724547 725055 725333 726308 728511 728912 733361 734457 735311 736298 738875 739707 741812 744680 747562 748076 748437 748586 750339 753238 754000 757610 762219 762258 762348 767694 771738 773751 780098 805297 819209 819738 821791 823849 823972 824881 825957 826730 827341 828099 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur big cock"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск большие 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.