Query Metrics
7
Database Queries
7
Different statements
248.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.48 ms (87.86%) |
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 185038 379578 381758 383051 383486 385096 385105 386518 389147 390185 399008 404722 406578 406993 407549 413465 416144 418933 436628 436859 445233 446860 447529 447882 448061 454323 454714 457767 463882 467273 469820 469825 478760 481873 487514 489110 489225 489318 501805 503215 507171 507175 510043 515779 516406 518032 518328 518347 527029 527660 543043 545814 551329 551334 551422 554777 557266 558617 563796 565940 565943 572010 591115 600581 600602 603516 603583 619604 620317 624285 625452 634756 643436 653247 653253 654331 663391 670270 677030 677041 697178 720458 722098 722810 722896 728067 732379 735530 737921 738907 738925 738927 740007 740235 743810 747376 749551 773182 776724 781022 782003 789745 794425 797499 800005 800066 800069 808241 813949 815958 816047 816517 818324 818390 818725 821572 822737 824724 825204 827828 ] |
||||||||||||||||||||||||||||||
|
19.66 ms (7.91%) |
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 591115 808241 489318 507175 816047 399008 743810 510043 448061 390185 406993 543043 722810 654331 740007 738925 740235 749551 738907 722896 794425 416144 815958 469820 557266 653253 600602 634756 789745 565940 818725 818324 825204 677030 643436 738927 379578 454714 527029 619604 404722 383486 185038 813949 489225 677041 551334 624285 797499 732379 728067 781022 800069 385096 389147 507171 469825 670270 413465 463882 545814 600581 406578 407549 385105 824724 816517 446860 776724 800066 381758 487514 436628 697178 800005 737921 782003 386518 383051 822737 818390 821572 827828 551329 565943 720458 663391 722098 603516 620317 747376 735530 773182 436859 457767 447882 515779 516406 518347 481873 554777 558617 563796 551422 572010 653247 603583 625452 478760 445233 447529 503215 489110 518032 501805 418933 454323 518328 467273 527660 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.40%) |
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 185038 379578 381758 383051 383486 385096 385105 386518 389147 390185 399008 404722 406578 406993 407549 413465 416144 418933 436628 436859 445233 446860 447529 447882 448061 454323 454714 457767 463882 467273 469820 469825 478760 481873 487514 489110 489225 489318 501805 503215 507171 507175 510043 515779 516406 518032 518328 518347 527029 527660 543043 545814 551329 551334 551422 554777 557266 558617 563796 565940 565943 572010 591115 600581 600602 603516 603583 619604 620317 624285 625452 634756 643436 653247 653253 654331 663391 670270 677030 677041 697178 720458 722098 722810 722896 728067 732379 735530 737921 738907 738925 738927 740007 740235 743810 747376 749551 773182 776724 781022 782003 789745 794425 797499 800005 800066 800069 808241 813949 815958 816047 816517 818324 818390 818725 821572 822737 824724 825204 827828 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage tits"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.