Query Metrics
7
Database Queries
7
Different statements
258.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
232.04 ms (89.82%) |
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 187186 233683 313286 327786 358449 381878 386350 386864 395508 395548 395881 395924 399634 400150 407626 407707 409713 411631 411923 413275 414253 427335 443626 444545 447418 449342 453276 455030 461010 470129 475855 514936 518796 525949 530537 534245 537849 549138 549251 550852 560390 563156 563478 563483 564019 564197 572715 579346 584114 586647 593253 594774 598910 604885 611317 615311 616997 619650 621196 623948 636016 643984 644018 647984 650422 651025 663908 663925 663929 664832 664833 665240 665300 665349 665395 665889 666791 667317 667661 693956 694967 696320 697634 711679 719016 721382 721818 724226 728316 731080 731814 737897 740156 740164 745728 752876 758425 759877 770179 770585 772100 780616 781726 781741 788875 789691 794089 798640 802185 802233 804219 806907 808510 810937 811001 815722 817010 818504 824935 826246 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (6.14%) |
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 518796 187186 395881 395924 395508 395548 313286 399634 400150 411631 407626 407707 409713 414253 411923 413275 443626 818504 824935 826246 815722 817010 453276 461010 447418 449342 475855 455030 470129 525949 530537 534245 537849 514936 549138 560390 563483 564019 579346 563156 584114 549251 550852 563478 663929 665300 665395 666791 667317 693956 696320 697634 711679 721382 664833 665240 665889 647984 650422 651025 663908 663925 664832 665349 667661 694967 564197 572715 611317 615311 619650 594774 598910 604885 623948 644018 586647 593253 616997 621196 643984 781726 788875 789691 794089 811001 780616 798640 802185 806907 810937 731080 770179 770585 781741 802233 808510 728316 731814 740156 740164 745728 759877 772100 758425 752876 724226 737897 636016 719016 721818 804219 327786 381878 386864 233683 358449 386350 427335 444545 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.08%) |
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 187186 233683 313286 327786 358449 381878 386350 386864 395508 395548 395881 395924 399634 400150 407626 407707 409713 411631 411923 413275 414253 427335 443626 444545 447418 449342 453276 455030 461010 470129 475855 514936 518796 525949 530537 534245 537849 549138 549251 550852 560390 563156 563478 563483 564019 564197 572715 579346 584114 586647 593253 594774 598910 604885 611317 615311 616997 619650 621196 623948 636016 643984 644018 647984 650422 651025 663908 663925 663929 664832 664833 665240 665300 665349 665395 665889 666791 667317 667661 693956 694967 696320 697634 711679 719016 721382 721818 724226 728316 731080 731814 737897 740156 740164 745728 752876 758425 759877 770179 770585 772100 780616 781726 781741 788875 789691 794089 798640 802185 802233 804219 806907 808510 810937 811001 815722 817010 818504 824935 826246 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young glasses"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.67%) |
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.