Query Metrics
7
Database Queries
7
Different statements
163.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.51 ms (88.45%) |
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 73280 79601 409031 411878 415907 418705 418936 424757 439480 446321 453543 455294 466429 474155 506404 521009 525975 533176 539228 544684 558336 560175 561521 564697 565328 578554 580482 582591 584338 584833 584840 585329 585687 598837 599909 603032 603149 604848 605002 605362 606783 620325 626121 627166 635230 671379 676201 693333 704101 705067 708248 718767 746262 757045 757340 761453 763100 763550 764318 764622 772678 774013 776421 777286 780445 782897 784237 784252 789474 789498 789504 790106 790968 791632 791767 791841 793279 793742 794757 794952 795103 795168 795193 795963 796435 797107 798626 799573 802218 803036 804927 805141 805666 807322 807728 808193 809243 811241 813621 814030 815141 817768 818736 819145 819531 820452 820624 821796 823102 823735 823849 824043 825924 826006 826236 826860 828240 ] |
||||||||||||||||||||||||||||||
|
8.51 ms (5.21%) |
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 635230 799573 815141 521009 811241 580482 585329 453543 820624 822993 823102 823188 828240 603149 466429 560175 784252 784237 795103 825924 819145 789474 794952 765427 774013 455294 474155 446321 809243 763100 73280 411878 761453 418936 415907 424757 790968 797107 791841 693333 626121 746262 763550 506404 525975 708248 584338 813621 533176 558336 565328 578554 598837 603032 585687 605002 606783 627166 776421 805141 807728 793279 791632 794757 796435 79601 584840 676201 409031 439480 823735 804927 764318 561521 539228 544684 564697 620325 824043 826006 826236 814030 818736 819531 704101 671379 782897 795168 807322 798626 790106 791767 764622 418705 793742 795963 803036 820452 823849 826860 604848 605362 789504 802218 757045 789498 757340 772678 705067 777286 599909 817768 718767 805666 582591 821796 795193 780445 808193 584833 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.68%) |
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 73280 79601 409031 411878 415907 418705 418936 424757 439480 446321 453543 455294 466429 474155 506404 521009 525975 533176 539228 544684 558336 560175 561521 564697 565328 578554 580482 582591 584338 584833 584840 585329 585687 598837 599909 603032 603149 604848 605002 605362 606783 620325 626121 627166 635230 671379 676201 693333 704101 705067 708248 718767 746262 757045 757340 761453 763100 763550 764318 764622 772678 774013 776421 777286 780445 782897 784237 784252 789474 789498 789504 790106 790968 791632 791767 791841 793279 793742 794757 794952 795103 795168 795193 795963 796435 797107 798626 799573 802218 803036 804927 805141 805666 807322 807728 808193 809243 811241 813621 814030 815141 817768 818736 819145 819531 820452 820624 821796 823102 823735 823849 824043 825924 826006 826236 826860 828240 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob milf pov"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс milf пов"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс milf пов"
]
|
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.