Query Metrics
7
Database Queries
7
Different statements
188.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.75 ms (84.03%) |
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 239808 397962 402912 411133 412857 418389 419999 420864 421552 425294 427341 429259 433940 439169 443448 445012 447310 453221 458238 458639 459664 460542 461873 462540 465754 467645 472739 475584 477206 479980 482258 482699 484350 484952 484960 485230 485298 495030 497262 498479 498603 498972 512702 516740 519125 519873 521368 521752 522226 529087 538739 547726 551732 552169 559199 565289 565296 567190 570142 571986 576154 576544 586601 588846 589979 594280 598043 598549 598914 599460 613247 617312 620566 627310 627656 627794 631598 637369 641207 642155 661046 676194 678620 693433 693944 706173 709093 717502 722405 723007 725183 735036 735699 736639 737095 739332 740500 748437 749995 754000 754580 756204 757857 766131 766429 766854 770476 774266 777899 784679 785207 786756 797718 799499 809323 810741 814499 819932 824602 825488 ] |
||||||||||||||||||||||||||||||
|
19.78 ms (10.47%) |
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 498479 482699 522226 397962 693433 749995 766854 552169 461873 465754 485298 598914 512702 453221 462540 516740 706173 484952 411133 475584 482258 497262 571986 661046 576154 479980 676194 589979 613247 617312 642155 598549 627656 641207 814499 819932 458238 538739 735036 774266 485230 559199 567190 547726 588846 599460 425294 419999 439169 445012 458639 421552 519873 620566 484350 521368 460542 433940 757857 576544 722405 627794 723007 586601 521752 766429 420864 784679 498603 565296 551732 598043 637369 627310 570142 427341 472739 529087 565289 631598 447310 484960 459664 678620 594280 467645 477206 519125 693944 824602 717502 754580 735699 740500 725183 737095 754000 785207 756204 736639 766131 739332 748437 770476 777899 797718 799499 809323 402912 418389 239808 498972 495030 786756 709093 810741 412857 429259 443448 825488 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.30%) |
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 239808 397962 402912 411133 412857 418389 419999 420864 421552 425294 427341 429259 433940 439169 443448 445012 447310 453221 458238 458639 459664 460542 461873 462540 465754 467645 472739 475584 477206 479980 482258 482699 484350 484952 484960 485230 485298 495030 497262 498479 498603 498972 512702 516740 519125 519873 521368 521752 522226 529087 538739 547726 551732 552169 559199 565289 565296 567190 570142 571986 576154 576544 586601 588846 589979 594280 598043 598549 598914 599460 613247 617312 620566 627310 627656 627794 631598 637369 641207 642155 661046 676194 678620 693433 693944 706173 709093 717502 722405 723007 725183 735036 735699 736639 737095 739332 740500 748437 749995 754000 754580 756204 757857 766131 766429 766854 770476 774266 777899 784679 785207 786756 797718 799499 809323 810741 814499 819932 824602 825488 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодежь красотки домашнее"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые молодая девушк молодой красивая домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.