Query Metrics
7
Database Queries
7
Different statements
165.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.30 ms (84.92%) |
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 390839 394309 395983 398124 410796 413006 419895 423773 449572 450583 457056 457074 458508 466031 472548 480494 492808 506302 511006 515531 517441 520524 521014 522102 528296 528926 529595 529810 531856 535807 537155 539557 540691 541805 545504 551883 556040 568652 576176 577054 579236 579523 584140 584363 585453 587241 591993 592656 593183 594934 597725 599601 600362 602320 603717 607573 618072 620813 630233 634836 639652 640375 641064 642076 649738 650447 650649 654196 655297 656228 660597 663751 666733 668026 668303 675837 678661 682611 692165 699232 700985 710523 710800 711597 711637 712884 713117 714253 734416 736814 739133 749611 750981 752251 752496 760609 770544 776007 776524 777756 779718 783297 784199 784337 785366 787526 790214 792547 796807 804440 804453 810754 812198 812557 814285 816836 818960 819950 824104 827553 ] |
||||||||||||||||||||||||||||||
|
15.84 ms (9.59%) |
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 827553 649738 597725 395983 390839 410796 515531 528926 545504 660597 398124 819950 816836 818960 458508 529810 528296 537155 522102 584363 551883 656228 663751 668026 678661 682611 714253 654196 675837 713117 607573 620813 600362 603717 639652 641064 618072 777756 790214 752496 792547 804453 810754 812557 739133 750981 752251 734416 760609 699232 783297 784199 796807 804440 812198 506302 531856 517441 655297 592656 779718 749611 776007 394309 423773 511006 457074 770544 492808 591993 480494 449572 450583 576176 579523 579236 710523 776524 787526 784337 419895 472548 521014 466031 584140 577054 587241 602320 599601 593183 785366 736814 413006 814285 824104 457056 520524 529595 539557 540691 535807 541805 556040 650447 650649 668303 700985 711637 666733 710800 712884 692165 711597 568652 594934 634836 640375 642076 585453 630233 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.73%) |
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 390839 394309 395983 398124 410796 413006 419895 423773 449572 450583 457056 457074 458508 466031 472548 480494 492808 506302 511006 515531 517441 520524 521014 522102 528296 528926 529595 529810 531856 535807 537155 539557 540691 541805 545504 551883 556040 568652 576176 577054 579236 579523 584140 584363 585453 587241 591993 592656 593183 594934 597725 599601 600362 602320 603717 607573 618072 620813 630233 634836 639652 640375 641064 642076 649738 650447 650649 654196 655297 656228 660597 663751 666733 668026 668303 675837 678661 682611 692165 699232 700985 710523 710800 711597 711637 712884 713117 714253 734416 736814 739133 749611 750981 752251 752496 760609 770544 776007 776524 777756 779718 783297 784199 784337 785366 787526 790214 792547 796807 804440 804453 810754 812198 812557 814285 816836 818960 819950 824104 827553 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot solo ass"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.35 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.