Query Metrics
7
Database Queries
7
Different statements
173.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.59 ms (85.57%) |
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 9637 389693 393185 444221 457027 458303 460128 460252 470577 474200 490325 506414 512635 514069 537276 543135 543714 545980 549642 575408 578534 579187 580017 584160 588216 590305 593807 597896 615703 618755 625141 630238 647077 647256 647402 650066 660057 666416 672759 675876 687175 688979 689079 691538 701179 710432 712625 714888 715601 723929 726624 727009 728919 731071 731585 737208 739711 739840 740777 741902 742578 743800 745610 745849 748037 748849 750432 755242 756267 757651 759029 759173 760353 760989 761103 761328 762008 762211 762733 764640 770616 777127 777500 778284 782110 782800 783968 785458 787026 787351 788726 789365 789376 794098 794486 794493 794842 795203 795337 796693 797041 798523 798888 799312 800639 801269 801429 801505 802099 802330 802582 804916 806166 806263 811562 811747 812164 814502 814716 ] |
||||||||||||||||||||||||||||||
|
13.75 ms (7.92%) |
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 800639 777500 789365 759029 739711 762211 731071 755242 757651 785458 389693 794486 460128 811747 802330 798523 802099 789376 794098 795203 812164 579187 778284 783968 506414 748849 458303 543714 580017 514069 512635 543135 647077 660057 647256 650066 689079 647402 545980 588216 597896 618755 630238 590305 593807 782110 748037 625141 701179 9637 794493 745610 760353 764640 777127 444221 811562 804916 393185 814716 814502 549642 799312 796693 797041 801269 802582 756267 770616 787026 794842 728919 731585 726624 742578 741902 740777 801429 460252 788726 806263 714888 715601 795337 782800 806166 723929 737208 761328 762008 739840 762625 762733 759173 760989 727009 761103 798888 801505 470577 490325 675876 712625 615703 745849 457027 474200 750432 743800 787351 537276 575408 584160 578534 688979 666416 672759 687175 691538 710432 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (2.49%) |
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 9637 389693 393185 444221 457027 458303 460128 460252 470577 474200 490325 506414 512635 514069 537276 543135 543714 545980 549642 575408 578534 579187 580017 584160 588216 590305 593807 597896 615703 618755 625141 630238 647077 647256 647402 650066 660057 666416 672759 675876 687175 688979 689079 691538 701179 710432 712625 714888 715601 723929 726624 727009 728919 731071 731585 737208 739711 739840 740777 741902 742578 743800 745610 745849 748037 748849 750432 755242 756267 757651 759029 759173 760353 760989 761103 761328 762008 762211 762733 764640 770616 777127 777500 778284 782110 782800 783968 785458 787026 787351 788726 789365 789376 794098 794486 794493 794842 795203 795337 796693 797041 798523 798888 799312 800639 801269 801429 801505 802099 802330 802582 804916 806166 806263 811562 811747 812164 814502 814716 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy amateurs"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.80%) |
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.