Query Metrics
7
Database Queries
7
Different statements
183.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.06 ms (84.91%) |
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 33821 402631 403087 407423 410305 425359 426470 428888 431639 444428 445785 457289 460598 469305 486643 487275 502205 503757 506945 510594 517693 518601 530635 530742 531390 537872 538603 542880 544801 547629 553440 555529 561483 562506 565111 565137 567729 574318 574375 574706 576572 578433 582444 584038 584425 584592 587344 589408 592930 595189 596675 598338 604087 605184 607685 610286 611563 613608 618998 620755 626253 626257 626263 627076 631740 634688 644876 662847 663263 666439 668809 683664 684731 687384 715865 722519 724401 727326 730756 733708 736437 740956 742360 744774 745298 745312 747325 750078 750881 752094 752147 752766 757221 757667 758330 759117 759139 765243 770964 774908 781895 782007 788113 788255 788839 790326 793592 797308 798273 802274 804260 804314 804445 804654 806301 807894 810704 811275 814151 827290 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (9.31%) |
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 510594 530742 503757 544801 555529 561483 687384 666439 604087 610286 618998 781895 804260 724401 727326 730756 802274 804314 428888 531390 683664 611563 757667 752766 506945 457289 518601 626263 626257 469305 547629 562506 567729 589408 605184 788113 774908 788839 804445 757221 759117 793592 807894 811275 733708 758330 745298 747325 752094 752147 782007 788255 33821 644876 584038 553440 668809 684731 662847 592930 627076 596675 426470 745312 584592 565137 798273 403087 530635 542880 663263 598338 626253 486643 814151 445785 538603 487275 715865 722519 578433 595189 587344 804654 806301 810704 736437 759139 425359 444428 460598 582444 634688 407423 402631 410305 431639 827290 517693 537872 502205 574375 584425 565111 574706 574318 576572 631740 607685 613608 790326 797308 740956 765243 744774 742360 750078 750881 770964 620755 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.84%) |
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 33821 402631 403087 407423 410305 425359 426470 428888 431639 444428 445785 457289 460598 469305 486643 487275 502205 503757 506945 510594 517693 518601 530635 530742 531390 537872 538603 542880 544801 547629 553440 555529 561483 562506 565111 565137 567729 574318 574375 574706 576572 578433 582444 584038 584425 584592 587344 589408 592930 595189 596675 598338 604087 605184 607685 610286 611563 613608 618998 620755 626253 626257 626263 627076 631740 634688 644876 662847 663263 666439 668809 683664 684731 687384 715865 722519 724401 727326 730756 733708 736437 740956 742360 744774 745298 745312 747325 750078 750881 752094 752147 752766 757221 757667 758330 759117 759139 765243 770964 774908 781895 782007 788113 788255 788839 790326 793592 797308 798273 802274 804260 804314 804445 804654 806301 807894 810704 811275 814151 827290 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur huge boobs"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск огромные boobs"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск огромные boobs"
]
|
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.