Query Metrics
7
Database Queries
7
Different statements
176.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.57 ms (86.08%) |
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 44120 192814 384138 386853 388193 391908 397895 398552 458346 460830 470637 473321 478541 484145 530930 532681 533050 534640 535585 536305 536958 538043 543360 543688 544696 544751 545077 545085 545096 545106 547966 547983 557069 562588 563407 563659 566434 568180 568187 583446 583715 591165 591167 593884 593885 599533 603590 604679 606064 610780 624985 625307 633179 634347 635787 635791 635842 636567 642524 645050 649250 651420 653435 653593 653600 653634 653914 654291 654295 654297 663546 664481 671243 681740 686024 690049 692454 694310 694346 710263 710492 717233 717372 718421 721933 723967 727767 731113 731195 731358 732850 733045 733050 733178 742691 743644 745896 745906 745917 749639 759443 767173 767861 768189 768227 770143 773961 775896 776528 778160 793231 797126 804508 813018 819180 823252 823928 824132 824325 826621 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (7.41%) |
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 545085 566434 664481 649250 653600 717372 694310 635791 593884 778160 636567 470637 484145 563659 653593 593885 635787 733045 732850 767861 731358 721933 723967 710492 710263 545077 604679 384138 826621 819180 536305 460830 773961 591167 44120 775896 535585 544751 568180 606064 538043 692454 635842 192814 543360 610780 568187 823252 563407 583715 547983 653914 391908 458346 731113 793231 386853 653435 742691 536958 545096 651420 388193 823928 599533 759443 398552 663546 776528 804508 591165 767173 717233 727767 625307 654295 654297 813018 731195 603590 671243 624985 768189 733050 681740 473321 544696 543688 545106 745917 824132 824325 557069 768227 797126 478541 743644 530930 645050 690049 686024 562588 653634 749639 654291 583446 718421 745896 745906 397895 770143 733178 534640 532681 533050 547966 694346 633179 642524 634347 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.03%) |
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 44120 192814 384138 386853 388193 391908 397895 398552 458346 460830 470637 473321 478541 484145 530930 532681 533050 534640 535585 536305 536958 538043 543360 543688 544696 544751 545077 545085 545096 545106 547966 547983 557069 562588 563407 563659 566434 568180 568187 583446 583715 591165 591167 593884 593885 599533 603590 604679 606064 610780 624985 625307 633179 634347 635787 635791 635842 636567 642524 645050 649250 651420 653435 653593 653600 653634 653914 654291 654295 654297 663546 664481 671243 681740 686024 690049 692454 694310 694346 710263 710492 717233 717372 718421 721933 723967 727767 731113 731195 731358 732850 733045 733050 733178 742691 743644 745896 745906 745917 749639 759443 767173 767861 768189 768227 770143 773961 775896 776528 778160 793231 797126 804508 813018 819180 823252 823928 824132 824325 826621 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome mmf wife"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро мжм секс втро жен"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро мжм секс втро жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.