Query Metrics
7
Database Queries
7
Different statements
185.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.33 ms (86.62%) |
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 187928 247954 383065 391944 398174 398461 398979 401404 405859 407799 411688 411704 414782 418057 428884 448356 453124 453438 454256 457782 460171 461051 463172 464388 465406 466192 466212 466977 466995 467912 468927 469579 470280 470286 471195 473400 474685 474791 483375 488370 488373 502061 502108 506061 506830 513329 517007 518762 518837 526727 544971 546433 547737 549033 551979 555198 555248 555274 555425 560409 563001 563036 566770 567422 587958 590730 591162 591197 592214 592438 605686 612922 612989 613004 613576 614392 614789 614843 619650 619791 640724 660807 663977 665197 665372 665499 666813 667578 670904 726986 730361 730847 733266 733317 735442 736077 744197 744200 744203 748254 758790 758799 766613 774196 775649 781972 794632 804443 812555 817262 818054 818584 823917 824035 824164 824363 824457 825138 825959 827648 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (7.98%) |
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 555425 670904 555274 460171 407799 187928 418057 591197 563036 605686 758799 758790 398174 518762 766613 488373 466212 794632 733266 733317 470286 454256 474685 473400 825959 546433 592214 824457 818054 824035 824164 825138 666813 667578 663977 665499 614789 804443 748254 730361 744203 612922 640724 590730 566770 506061 818584 468927 613576 513329 526727 414782 614392 398461 453124 502061 567422 551979 665372 665197 587958 591162 619791 614843 730847 736077 744197 744200 781972 391944 401404 817262 405859 411704 560409 660807 592438 726986 398979 827648 812555 471195 544971 549033 612989 774196 823917 555248 555198 775649 735442 247954 824363 502108 517007 467912 619650 613004 466977 383065 411688 448356 453438 461051 464388 469579 563001 547737 428884 463172 466995 474791 466192 470280 457782 465406 518837 506830 483375 488370 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.50%) |
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 187928 247954 383065 391944 398174 398461 398979 401404 405859 407799 411688 411704 414782 418057 428884 448356 453124 453438 454256 457782 460171 461051 463172 464388 465406 466192 466212 466977 466995 467912 468927 469579 470280 470286 471195 473400 474685 474791 483375 488370 488373 502061 502108 506061 506830 513329 517007 518762 518837 526727 544971 546433 547737 549033 551979 555198 555248 555274 555425 560409 563001 563036 566770 567422 587958 590730 591162 591197 592214 592438 605686 612922 612989 613004 613576 614392 614789 614843 619650 619791 640724 660807 663977 665197 665372 665499 666813 667578 670904 726986 730361 730847 733266 733317 735442 736077 744197 744200 744203 748254 758790 758799 766613 774196 775649 781972 794632 804443 812555 817262 818054 818584 823917 824035 824164 824363 824457 825138 825959 827648 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy ass mature"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая жоп mature"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая жоп mature"
]
|
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.