Query Metrics
7
Database Queries
7
Different statements
186.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.66 ms (85.93%) |
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 401757 404000 409613 411536 438978 445088 445719 448925 457508 460857 463312 469716 470810 492337 493965 499083 505540 513176 518105 521519 541011 541157 541755 559314 560264 560579 562430 564557 569443 572295 577570 577698 579532 580609 587204 592616 592787 593022 595137 598623 602262 602620 603948 605422 609838 610121 614954 615509 618461 619797 620566 622866 623961 624389 626685 630716 631606 640656 645696 658222 658223 658224 658225 674907 674916 675930 678696 679306 684533 685931 687962 693236 695310 696241 700722 700735 709961 716675 717412 717453 718811 722253 723123 724516 727896 729357 731232 732822 733672 734037 734044 736470 740803 740897 741998 743559 743634 743892 747563 749059 752029 760214 761688 770591 772056 773313 774221 776581 785362 787379 787616 793680 793944 797719 798908 807419 810053 811415 812299 812437 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (7.90%) |
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 615509 760214 470810 411536 445719 469716 580609 812299 749059 761688 409613 463312 513176 587204 560579 602620 787616 679306 658224 658225 445088 457508 460857 577698 693236 605422 812437 793680 729357 727896 448925 736470 401757 518105 598623 741998 579532 810053 733672 776581 722253 492337 743634 614954 619797 499083 798908 732822 747563 610121 541011 562430 658222 709961 658223 630716 602262 559314 717412 675930 685931 695310 696241 717453 723123 592787 595137 624389 811415 731232 734037 740897 785362 724516 773313 740803 743559 770591 772056 774221 797719 404000 541157 716675 592616 609838 718811 793944 734044 569443 603948 743892 752029 684533 541755 521519 700722 577570 674916 560264 618461 505540 493965 620566 438978 622866 687962 700735 678696 623961 631606 572295 674907 640656 593022 626685 645696 564557 807419 787379 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (2.19%) |
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 401757 404000 409613 411536 438978 445088 445719 448925 457508 460857 463312 469716 470810 492337 493965 499083 505540 513176 518105 521519 541011 541157 541755 559314 560264 560579 562430 564557 569443 572295 577570 577698 579532 580609 587204 592616 592787 593022 595137 598623 602262 602620 603948 605422 609838 610121 614954 615509 618461 619797 620566 622866 623961 624389 626685 630716 631606 640656 645696 658222 658223 658224 658225 674907 674916 675930 678696 679306 684533 685931 687962 693236 695310 696241 700722 700735 709961 716675 717412 717453 718811 722253 723123 724516 727896 729357 731232 732822 733672 734037 734044 736470 740803 740897 741998 743559 743634 743892 747563 749059 752029 760214 761688 770591 772056 773313 774221 776581 785362 787379 787616 793680 793944 797719 798908 807419 810053 811415 812299 812437 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real homemade 18"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real домашн любительск 18"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real домашн любительск 18"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
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.