Query Metrics
7
Database Queries
7
Different statements
155.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.29 ms (82.65%) |
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 365295 384883 387324 392789 421989 422198 427550 430048 442318 455281 466963 469476 471403 471629 482346 487435 488123 489082 496101 504927 513076 515305 519087 519278 519931 524865 524896 527249 532054 539649 542677 544312 556643 556661 557958 561559 563014 571508 583067 589629 591112 591636 593165 599726 601234 602959 603733 660357 663516 681146 702050 702465 705553 715696 717740 718279 719065 723938 726667 728089 729570 733973 734313 737089 740158 750890 752539 753620 754850 756070 760166 760816 769978 770002 771394 774116 774131 775569 776775 784304 784587 784850 789505 789716 795559 798393 799054 802095 802981 804302 807969 810506 813045 813245 813486 813779 814898 814941 815678 815824 815913 816008 816941 817040 818672 820005 820007 821171 821653 821801 821905 822385 823397 823619 824840 825681 826303 826761 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (9.81%) |
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 561559 593165 603733 776775 784850 798393 802095 807969 775569 789505 795559 804302 813486 740158 769978 774116 802981 810506 728089 733973 729570 760166 737089 771394 771729 702050 705553 813045 813245 384883 816008 825681 421989 488123 524865 496101 430048 442318 471629 524896 513076 519087 519931 487435 489082 469476 816941 815824 820005 826303 544312 718279 702465 717740 589629 756070 750890 723938 753620 774131 455281 557958 556643 559076 571508 601234 602959 784304 527249 519278 471403 556661 563014 599726 422198 542677 583067 760816 821801 821905 817040 660357 663516 681146 591636 789716 752539 734313 754850 770002 482346 466963 427550 504927 824840 539649 532054 515305 719065 591112 726667 715696 784587 799054 387324 392789 365295 814898 815678 821171 821653 823619 814941 815913 818672 820007 822385 823397 826761 813779 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (2.34%) |
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 365295 384883 387324 392789 421989 422198 427550 430048 442318 455281 466963 469476 471403 471629 482346 487435 488123 489082 496101 504927 513076 515305 519087 519278 519931 524865 524896 527249 532054 539649 542677 544312 556643 556661 557958 561559 563014 571508 583067 589629 591112 591636 593165 599726 601234 602959 603733 660357 663516 681146 702050 702465 705553 715696 717740 718279 719065 723938 726667 728089 729570 733973 734313 737089 740158 750890 752539 753620 754850 756070 760166 760816 769978 770002 771394 774116 774131 775569 776775 784304 784587 784850 789505 789716 795559 798393 799054 802095 802981 804302 807969 810506 813045 813245 813486 813779 814898 814941 815678 815824 815913 816008 816941 817040 818672 820005 820007 821171 821653 821801 821905 822385 823397 823619 824840 825681 826303 826761 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick for mom"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член mom"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член mom"
]
|
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.