Query Metrics
7
Database Queries
7
Different statements
169.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.71 ms (88.15%) |
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 385600 394509 396944 397777 417283 418856 419223 421599 423155 434370 434889 435043 435799 456599 460109 469271 534739 537347 540245 542082 544969 546557 555125 565086 573277 584211 584233 587783 589030 606101 609809 615893 620211 620653 648169 648497 666404 668071 674607 689160 701232 710208 716596 716599 716621 716628 716856 721450 723131 726356 727511 729255 729270 733938 734858 735471 739624 749185 758743 761435 761789 763146 763194 763198 763232 763292 763626 763877 764993 765267 766882 766903 767520 767524 768241 768803 771512 772823 778634 778671 779037 779850 781408 783217 783385 783387 783432 783440 783510 783557 783724 783788 786070 790181 791106 791156 793349 793456 793756 796015 798305 799388 803674 803692 806872 807663 809329 813632 814281 814310 817971 818843 819704 825174 825455 825588 826145 826373 826374 827209 ] |
||||||||||||||||||||||||||||||
|
10.05 ms (5.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 786070 763198 749185 768803 540245 396944 648497 813632 783724 763626 555125 620653 385600 783217 423155 766903 791106 456599 825588 825455 674607 710208 783557 739624 826373 779850 783440 796015 799388 803674 772823 763146 761789 807663 419223 421599 435799 546557 765267 544969 809329 766882 417283 716856 729270 584233 689160 584211 609809 701232 606101 771512 768241 733938 778634 783510 758743 763877 542082 827209 825174 716628 435043 793756 534739 648169 573277 764993 666404 587783 726356 460109 565086 778671 537347 817971 818843 819704 763232 783432 793349 767520 615893 783788 721450 734858 767524 791156 397777 434370 763194 783385 716596 735471 814310 798305 803692 668071 589030 394509 826145 716599 781408 779037 793456 727511 763292 418856 723131 434889 620211 826374 814281 469271 716621 761435 783387 790181 806872 729255 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat cum amateur"
]
|
||||||||||||||||||||||||||||||
|
2.44 ms (1.43%) |
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 385600 394509 396944 397777 417283 418856 419223 421599 423155 434370 434889 435043 435799 456599 460109 469271 534739 537347 540245 542082 544969 546557 555125 565086 573277 584211 584233 587783 589030 606101 609809 615893 620211 620653 648169 648497 666404 668071 674607 689160 701232 710208 716596 716599 716621 716628 716856 721450 723131 726356 727511 729255 729270 733938 734858 735471 739624 749185 758743 761435 761789 763146 763194 763198 763232 763292 763626 763877 764993 765267 766882 766903 767520 767524 768241 768803 771512 772823 778634 778671 779037 779850 781408 783217 783385 783387 783432 783440 783510 783557 783724 783788 786070 790181 791106 791156 793349 793456 793756 796015 798305 799388 803674 803692 806872 807663 809329 813632 814281 814310 817971 818843 819704 825174 825455 825588 826145 826373 826374 827209 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глубокийминет минет оральн секс cum любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс cum любительск"
]
|
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.