Query Metrics
7
Database Queries
7
Different statements
217.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.46 ms (87.05%) |
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 343227 381795 389181 395942 396969 397647 411408 411863 440788 440968 443423 443741 451991 454287 456697 460736 468167 470213 472628 476303 477712 479040 481912 484395 505656 509554 518563 518729 519152 528081 534238 535264 544493 545686 546813 556451 579308 582586 585518 604715 604958 612188 617440 633115 644661 695196 698496 707484 712335 712927 717700 718496 718839 724370 725350 726901 727814 728452 730097 731832 733029 733097 733098 733128 734728 736295 740890 742241 744989 746025 746060 748389 748876 750063 759810 761318 766663 770110 770140 775571 777025 781780 785436 788237 788514 789252 793875 794632 797259 797275 798901 800298 800347 800541 802439 802448 803541 804013 804583 805415 805969 807171 807327 807605 815299 815518 817796 818402 818773 818812 818817 819011 820115 820174 820734 823916 824367 825037 826448 828421 ] |
||||||||||||||||||||||||||||||
|
16.71 ms (7.68%) |
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 748876 770110 807171 807605 818817 805415 389181 815299 718839 718496 556451 781780 454287 440788 505656 585518 794632 761318 750063 742241 395942 397647 819011 820115 824367 818812 817796 818402 518729 519152 582586 695196 707484 717700 712335 712927 633115 775571 798901 802448 797259 802439 804013 725350 730097 736295 785436 788237 727814 759810 766663 733029 733097 733098 744989 746060 733128 734728 770140 746025 617440 698496 789252 804583 443423 381795 396969 484395 468167 411408 815518 825037 818773 476303 534238 546813 579308 545686 644661 604715 612188 788514 800347 800541 803541 724370 797275 731832 740890 604958 793875 800298 805969 343227 440968 451991 456697 535264 509554 544493 807327 728452 748389 443741 470213 472628 460736 477712 479040 528081 481912 411863 518563 823916 820174 826448 820734 828421 777025 726901 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (1.66%) |
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 343227 381795 389181 395942 396969 397647 411408 411863 440788 440968 443423 443741 451991 454287 456697 460736 468167 470213 472628 476303 477712 479040 481912 484395 505656 509554 518563 518729 519152 528081 534238 535264 544493 545686 546813 556451 579308 582586 585518 604715 604958 612188 617440 633115 644661 695196 698496 707484 712335 712927 717700 718496 718839 724370 725350 726901 727814 728452 730097 731832 733029 733097 733098 733128 734728 736295 740890 742241 744989 746025 746060 748389 748876 750063 759810 761318 766663 770110 770140 775571 777025 781780 785436 788237 788514 789252 793875 794632 797259 797275 798901 800298 800347 800541 802439 802448 803541 804013 804583 805415 805969 807171 807327 807605 815299 815518 817796 818402 818773 818812 818817 819011 820115 820174 820734 823916 824367 825037 826448 828421 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature лиза pussy"
]
|
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.