Query Metrics
7
Database Queries
7
Different statements
143.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.54 ms (82.65%) |
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 6983 24356 314552 388772 388776 393582 395642 395667 395920 395978 404122 408532 420839 426266 441917 446525 468711 475447 487422 499457 503705 504082 528421 544751 564184 565159 597229 604140 604650 609875 612997 617711 619476 624159 626954 633241 634541 634562 635578 637018 640731 660321 662573 663176 664760 669279 671077 671810 672052 674220 674452 675856 677109 678799 678802 678981 679662 680143 680146 681208 684376 688885 698259 699961 703277 707662 710236 711064 711089 712366 715907 718681 722583 723159 727839 729929 731874 734472 749603 752722 760313 760968 761742 764261 764274 765235 765257 766969 777888 778946 781052 782349 782405 782959 783347 786769 788169 793283 793663 794198 794647 794917 795551 797863 800387 800423 801246 813906 814019 817496 818044 820811 820829 820840 821202 822934 823721 824227 826705 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (10.47%) |
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 395978 817496 660321 783347 794198 778946 718681 680146 800423 826705 635578 764261 395642 604140 801246 420839 680143 781052 24356 663176 675856 681208 707662 711064 669279 634562 782349 734472 795551 761742 749603 821202 446525 677109 698259 710236 612997 764274 703277 786769 722583 487422 715907 820811 408532 793663 820840 475447 504082 793283 626954 528421 404122 388776 820829 564184 6983 634541 823721 544751 800387 814019 499457 664760 777888 727839 752722 609875 818044 678802 788169 813906 674220 604650 619476 782959 765257 731874 782405 503705 662573 393582 824227 729929 395920 565159 678981 712366 723159 797863 794917 699961 822934 765235 314552 395667 671810 680196 597229 760313 388772 468711 674452 678799 671077 672052 633241 637018 617711 794647 766969 760968 640731 426266 441917 684376 711089 679662 688885 624159 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.71%) |
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 6983 24356 314552 388772 388776 393582 395642 395667 395920 395978 404122 408532 420839 426266 441917 446525 468711 475447 487422 499457 503705 504082 528421 544751 564184 565159 597229 604140 604650 609875 612997 617711 619476 624159 626954 633241 634541 634562 635578 637018 640731 660321 662573 663176 664760 669279 671077 671810 672052 674220 674452 675856 677109 678799 678802 678981 679662 680143 680146 681208 684376 688885 698259 699961 703277 707662 710236 711064 711089 712366 715907 718681 722583 723159 727839 729929 731874 734472 749603 752722 760313 760968 761742 764261 764274 765235 765257 766969 777888 778946 781052 782349 782405 782959 783347 786769 788169 793283 793663 794198 794647 794917 795551 797863 800387 800423 801246 813906 814019 817496 818044 820811 820829 820840 821202 822934 823721 824227 826705 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс first анал"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс first анал"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex first anal"
]
|
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.