Query Metrics
7
Database Queries
7
Different statements
181.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.60 ms (87.83%) |
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 230986 389770 418429 423861 468683 477402 483892 485238 490345 507263 515311 523719 529570 529678 530266 532277 532622 533683 539350 540616 541186 544228 545310 546292 555644 555674 559277 575018 602709 610779 614315 623042 623130 623568 625760 661005 667938 686527 688444 695515 697218 710393 714557 716970 719212 719337 719879 720113 722049 727397 731409 734382 735492 735712 738665 740126 740555 742908 744064 746239 750348 752535 761297 761330 761402 764686 765824 766114 766292 767772 768245 768301 768681 769018 776976 777137 777204 778135 779028 779915 781030 782578 783041 783191 784305 785645 786613 786713 790530 791613 792727 794417 794633 795237 795475 799679 801528 801999 802861 803701 812017 813134 813137 813314 817403 817570 823982 824117 824393 825462 826288 826344 826451 826452 826539 828198 828335 828455 828593 828622 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (6.99%) |
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 766292 769018 623130 623568 716970 719337 720113 777204 778135 779028 779915 782578 783041 784305 785645 786613 790530 792727 794417 794633 795475 812017 813314 477402 826452 515311 529570 532277 532622 533683 530266 545310 544228 719212 722049 688444 697218 602709 731409 710393 714557 776976 529678 761330 418429 825462 826288 828198 828622 485238 507263 539350 555674 555644 614315 777137 783191 801999 813137 752535 734382 735712 750348 768301 768681 768245 735492 740555 744064 765824 740126 813134 823982 826539 540616 559277 575018 686527 719879 623042 786713 230986 817403 817570 824117 826451 828335 828455 791613 803701 781030 801528 742908 746239 766114 802861 764686 767772 738665 727397 761297 761402 795237 546292 490345 423861 468683 483892 523719 610779 389770 826344 824393 828593 799679 625760 541186 667938 661005 695515 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.57%) |
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 230986 389770 418429 423861 468683 477402 483892 485238 490345 507263 515311 523719 529570 529678 530266 532277 532622 533683 539350 540616 541186 544228 545310 546292 555644 555674 559277 575018 602709 610779 614315 623042 623130 623568 625760 661005 667938 686527 688444 695515 697218 710393 714557 716970 719212 719337 719879 720113 722049 727397 731409 734382 735492 735712 738665 740126 740555 742908 744064 746239 750348 752535 761297 761330 761402 764686 765824 766114 766292 767772 768245 768301 768681 769018 776976 777137 777204 778135 779028 779915 781030 782578 783041 783191 784305 785645 786613 786713 790530 791613 792727 794417 794633 795237 795475 799679 801528 801999 802861 803701 812017 813134 813137 813314 817403 817570 823982 824117 824393 825462 826288 826344 826451 826452 826539 828198 828335 828455 828593 828622 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small amateur"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
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.