Query Metrics
7
Database Queries
7
Different statements
145.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.63 ms (81.97%) |
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 7286 24356 388772 393582 395642 395667 395920 395978 408532 420839 426266 441917 468711 487422 499457 503705 504082 528421 544138 544751 552689 564184 565159 597229 604140 604650 609875 617711 619476 631605 633241 634541 634562 637018 639293 640731 649585 660321 662573 663176 668104 669279 671077 671810 672052 674452 675856 677109 678799 678802 678981 679662 680143 680146 681208 684376 688885 693184 698012 698259 702633 707662 710236 710620 711064 711089 715907 718681 722583 722599 729929 731874 734472 740089 749603 760313 760968 761742 764261 764274 765235 766969 770949 775852 778946 781052 782349 782405 782959 783104 783347 783381 784597 786769 787947 788169 793283 793663 794198 794647 794917 795551 796916 800387 800423 813906 817496 818044 820829 820840 821202 821672 822934 823240 823720 823721 824227 826705 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (10.60%) |
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 698012 823240 821672 552689 693184 702633 649585 710620 631605 787947 783381 770949 740089 722599 544138 823720 7286 668104 783104 784597 796916 639293 775852 395978 817496 660321 783347 794198 778946 718681 680146 800423 826705 764261 395642 604140 420839 680143 781052 24356 663176 675856 681208 707662 711064 669279 634562 782349 734472 795551 761742 749603 821202 677109 698259 710236 764274 786769 722583 487422 715907 408532 793663 820840 504082 793283 528421 820829 564184 6983 634541 823721 544751 800387 499457 609875 818044 678802 788169 813906 604650 619476 782959 731874 782405 503705 662573 393582 824227 729929 395920 565159 678981 794917 822934 765235 395667 671810 680196 597229 760313 388772 468711 674452 678799 671077 672052 633241 637018 617711 794647 766969 760968 640731 426266 441917 684376 711089 679662 688885 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.20%) |
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 7286 24356 388772 393582 395642 395667 395920 395978 408532 420839 426266 441917 468711 487422 499457 503705 504082 528421 544138 544751 552689 564184 565159 597229 604140 604650 609875 617711 619476 631605 633241 634541 634562 637018 639293 640731 649585 660321 662573 663176 668104 669279 671077 671810 672052 674452 675856 677109 678799 678802 678981 679662 680143 680146 681208 684376 688885 693184 698012 698259 702633 707662 710236 710620 711064 711089 715907 718681 722583 722599 729929 731874 734472 740089 749603 760313 760968 761742 764261 764274 765235 766969 770949 775852 778946 781052 782349 782405 782959 783104 783347 783381 784597 786769 787947 788169 793283 793663 794198 794647 794917 795551 796916 800387 800423 813906 817496 818044 820829 820840 821202 821672 822934 823240 823720 823721 824227 826705 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"first anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"first анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"first анал секс"
]
|
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.