Query Metrics
7
Database Queries
7
Different statements
180.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.50 ms (84.82%) |
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 382419 382562 384268 386472 389829 390001 394218 394425 395905 396317 397215 397772 400143 401235 405485 405507 407154 409349 413185 430835 446286 453453 455281 460332 460340 460709 465791 465834 484768 486252 487933 493093 502306 502326 510287 512895 513728 514297 515060 518312 518927 519929 535010 546125 546883 562874 563182 563443 565146 591258 601234 619613 623145 663503 663514 663861 663865 665121 667287 667593 667621 674256 682074 682181 684222 685979 688668 696171 699675 702454 710578 710593 718499 719276 730550 732171 744316 745840 753707 766663 775853 780614 780663 781692 782216 782276 784304 785931 787328 788180 788468 788583 789660 789960 789967 790596 800541 801323 804218 804583 806290 807608 809790 813787 816059 816069 816476 817327 817688 818161 818280 818345 818402 818438 818893 823710 824023 824535 824936 825847 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (9.16%) |
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 591258 801323 465834 484768 512895 818345 813787 546883 562874 674256 718499 619613 785931 780614 790596 807608 394218 397772 732171 702454 601234 784304 400143 502306 518927 663503 518312 682181 413185 401235 430835 510287 744316 390001 535010 502326 546125 384268 818280 818161 818893 823710 824023 825847 667593 667287 682074 696171 699675 710593 663861 780663 789967 745840 788583 789960 806290 730550 753707 719276 781692 782216 788180 789660 804218 396317 405507 460709 446286 453453 407154 487933 685979 816059 788468 665121 460340 405485 563443 465791 513728 514297 817327 775853 800541 787328 804583 460332 389829 493093 386472 382562 382419 816476 824936 824535 818402 667621 688668 663865 684222 565146 782276 809790 766663 455281 519929 486252 663514 394425 395905 397215 409349 816069 817688 818438 515060 563182 710578 623145 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.78%) |
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 382419 382562 384268 386472 389829 390001 394218 394425 395905 396317 397215 397772 400143 401235 405485 405507 407154 409349 413185 430835 446286 453453 455281 460332 460340 460709 465791 465834 484768 486252 487933 493093 502306 502326 510287 512895 513728 514297 515060 518312 518927 519929 535010 546125 546883 562874 563182 563443 565146 591258 601234 619613 623145 663503 663514 663861 663865 665121 667287 667593 667621 674256 682074 682181 684222 685979 688668 696171 699675 702454 710578 710593 718499 719276 730550 732171 744316 745840 753707 766663 775853 780614 780663 781692 782216 782276 784304 785931 787328 788180 788468 788583 789660 789960 789967 790596 800541 801323 804218 804583 806290 807608 809790 813787 816059 816069 816476 817327 817688 818161 818280 818345 818402 818438 818893 823710 824023 824535 824936 825847 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mom fuck"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mom секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mom секс"
]
|
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.