Query Metrics
7
Database Queries
7
Different statements
182.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.61 ms (85.24%) |
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 224641 400977 402427 406652 412237 419099 422408 438682 441656 441811 449800 457071 458511 462760 469757 474840 478074 481198 483278 484056 488474 488855 489840 492807 493024 497993 499020 502778 504631 505359 506452 509099 509120 509217 510506 512232 517113 518048 518334 519125 519252 523986 528122 528506 529856 535336 536861 542072 542698 546051 553698 557265 567037 567514 571543 581739 581834 586017 588333 593818 598787 603113 606810 618379 621298 627153 629565 636441 654431 669704 687140 691423 693354 698196 703704 708337 708463 709709 713061 715236 716367 734892 735761 758345 771413 776089 776372 777422 777922 778756 778916 779094 779150 779829 781289 782613 782677 783259 783471 783819 786716 792978 795366 796752 799698 800769 801270 806561 810343 812077 813497 813640 814286 816756 819858 824536 825510 827947 827964 827983 ] |
||||||||||||||||||||||||||||||
|
17.11 ms (9.37%) |
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 469757 481198 509217 510506 483278 488855 492807 518048 519125 528122 528506 493024 499020 504631 509099 489840 497993 505359 509120 535336 474840 458511 546051 542072 621298 441656 419099 457071 462760 478074 506452 512232 536861 502778 518334 519252 488474 517113 224641 402427 400977 406652 422408 412237 438682 441811 813640 816756 824536 814286 819858 827947 827983 827964 825510 484056 449800 523986 529856 553698 557265 567514 571543 542698 567037 687140 693354 703704 708463 709709 654431 669704 691423 713061 715236 716367 698196 708337 581739 581834 588333 629565 636441 593818 598787 586017 603113 606810 618379 627153 776089 776372 777422 778756 778916 779150 779829 781289 801270 777922 779094 782613 782677 783471 786716 792978 795366 796752 799698 800769 806561 810343 812077 813497 734892 735761 758345 771413 783259 783819 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.30%) |
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 224641 400977 402427 406652 412237 419099 422408 438682 441656 441811 449800 457071 458511 462760 469757 474840 478074 481198 483278 484056 488474 488855 489840 492807 493024 497993 499020 502778 504631 505359 506452 509099 509120 509217 510506 512232 517113 518048 518334 519125 519252 523986 528122 528506 529856 535336 536861 542072 542698 546051 553698 557265 567037 567514 571543 581739 581834 586017 588333 593818 598787 603113 606810 618379 621298 627153 629565 636441 654431 669704 687140 691423 693354 698196 703704 708337 708463 709709 713061 715236 716367 734892 735761 758345 771413 776089 776372 777422 777922 778756 778916 779094 779150 779829 781289 782613 782677 783259 783471 783819 786716 792978 795366 796752 799698 800769 801270 806561 810343 812077 813497 813640 814286 816756 819858 824536 825510 827947 827964 827983 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful cum"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая cum"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая cum"
]
|
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.