Query Metrics
7
Database Queries
7
Different statements
165.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.28 ms (82.54%) |
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 388500 422170 423848 428090 434933 438291 447588 451771 452617 453844 455198 457786 458234 459159 461988 465671 466103 466180 466795 469171 469199 470015 470762 471997 472746 478927 484246 484369 486333 488955 489376 492549 492643 493019 496729 498614 498645 499987 500644 501451 503398 505069 506221 509813 510781 520339 520872 522107 522548 525447 525645 537307 541989 541998 543342 543344 543755 545321 546667 551669 552521 554742 559109 566455 581072 586493 587998 598482 615818 618947 619898 620046 623731 636505 636509 660274 666468 672791 688969 691388 691395 691432 698165 700926 700928 702280 702305 702310 708135 712956 722182 727710 728820 729342 739906 739967 741356 741547 741714 742375 743432 746129 747480 757120 766450 767670 768465 771822 777568 778765 783342 784225 789836 798891 799877 802215 802264 805228 813437 824994 ] |
||||||||||||||||||||||||||||||
|
19.67 ms (11.91%) |
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 472746 451771 453844 469171 388500 525645 484246 496729 498614 509813 546667 522107 447588 541998 471997 465671 700926 688969 702280 666468 691395 691432 619898 636505 741547 543344 554742 466180 469199 470015 520339 525447 620046 798891 799877 802215 767670 766450 739967 783342 452617 581072 741714 722182 757120 537307 541989 587998 466103 478927 470762 522548 498645 672791 691388 618947 777568 746129 768465 802264 741356 739906 729342 771822 428090 459159 489376 422170 552521 559109 423848 438291 455198 466795 434933 501451 484369 486333 493019 499987 500644 505069 510781 488955 742375 698165 551669 543342 458234 457786 492549 461988 506221 520872 492643 702305 702310 712956 660274 708135 598482 623731 700928 615818 824994 543755 566455 805228 778765 784225 813437 743432 747480 727710 789836 503398 545321 636509 586493 728820 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.42%) |
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 388500 422170 423848 428090 434933 438291 447588 451771 452617 453844 455198 457786 458234 459159 461988 465671 466103 466180 466795 469171 469199 470015 470762 471997 472746 478927 484246 484369 486333 488955 489376 492549 492643 493019 496729 498614 498645 499987 500644 501451 503398 505069 506221 509813 510781 520339 520872 522107 522548 525447 525645 537307 541989 541998 543342 543344 543755 545321 546667 551669 552521 554742 559109 566455 581072 586493 587998 598482 615818 618947 619898 620046 623731 636505 636509 660274 666468 672791 688969 691388 691395 691432 698165 700926 700928 702280 702305 702310 708135 712956 722182 727710 728820 729342 739906 739967 741356 741547 741714 742375 743432 746129 747480 757120 766450 767670 768465 771822 777568 778765 783342 784225 789836 798891 799877 802215 802264 805228 813437 824994 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur russian compilation"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск русск подборк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
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.