Query Metrics
7
Database Queries
7
Different statements
148.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.43 ms (87.41%) |
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 389660 452217 469099 472812 483848 495377 499681 511580 530083 530280 530641 533756 534723 535396 536488 537097 539751 539752 540120 540691 541488 542722 542927 543660 545967 547410 548321 548813 551554 553228 553807 554703 555066 555319 555406 555745 556040 557444 557461 558979 562936 570932 577002 577026 581041 581285 588302 592666 598424 600778 602600 603322 605181 618071 618967 621168 631183 633825 637462 639231 643031 643214 655545 670526 682886 692435 692715 709314 718029 718757 721956 734137 735813 735891 738236 750950 751381 752622 755345 764419 767495 768606 768681 769336 770058 772435 778521 788110 788532 789438 792623 796577 798755 798825 798884 800469 801819 802913 805287 811878 812226 812242 812249 813324 813589 814163 814165 818950 823841 824033 826386 827453 828046 828047 828098 828376 828402 828415 828725 ] |
||||||||||||||||||||||||||||||
|
9.38 ms (6.33%) |
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 540120 547410 709314 548321 553228 605181 643214 792623 811878 738236 735813 770058 557461 533756 530641 499681 577026 655545 618071 557444 581285 718757 692435 721956 800469 813324 796577 734137 755345 618967 588302 824033 828402 535396 621168 555066 581041 670526 805287 452217 798825 822666 828415 828725 818950 530280 542722 555319 600778 802913 812249 752622 764419 768606 812242 536488 555745 598424 603322 735891 813589 814163 539752 534723 539751 543660 553807 554703 577002 718029 637462 639231 643031 768681 772435 812226 545967 602600 542927 789438 798884 827453 826386 548813 555406 631183 788532 801819 798755 769336 788110 562936 767495 389660 633825 828046 828098 828376 828047 483848 558979 472812 495377 823841 751381 540691 537097 530083 556040 551554 750950 778521 469099 814165 511580 541488 682886 692715 570932 592666 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.65%) |
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 389660 452217 469099 472812 483848 495377 499681 511580 530083 530280 530641 533756 534723 535396 536488 537097 539751 539752 540120 540691 541488 542722 542927 543660 545967 547410 548321 548813 551554 553228 553807 554703 555066 555319 555406 555745 556040 557444 557461 558979 562936 570932 577002 577026 581041 581285 588302 592666 598424 600778 602600 603322 605181 618071 618967 621168 631183 633825 637462 639231 643031 643214 655545 670526 682886 692435 692715 709314 718029 718757 721956 734137 735813 735891 738236 750950 751381 752622 755345 764419 767495 768606 768681 769336 770058 772435 778521 788110 788532 789438 792623 796577 798755 798825 798884 800469 801819 802913 805287 811878 812226 812242 812249 813324 813589 814163 814165 818950 823841 824033 826386 827453 828046 828047 828098 828376 828402 828415 828725 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public solo milf"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц соло milf"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц соло milf"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.00%) |
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.