Query Metrics
7
Database Queries
7
Different statements
145.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.95 ms (85.60%) |
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 208554 263039 388962 398643 403035 403421 403948 406108 408241 415311 429117 429410 434007 434673 444051 448522 449908 450067 461853 462862 463420 467889 493909 497013 499789 499800 506688 515435 521238 525209 525700 528770 537651 541567 541669 544852 546981 555044 555306 556755 556896 557582 565425 578039 579582 581236 587465 593994 596240 596660 600206 600337 602793 608380 618267 622663 626108 629771 629797 648220 661061 665993 669000 673794 678838 680612 696499 700259 705427 708013 713167 714238 735555 739134 739915 740803 744982 747483 762714 766155 767695 772398 772951 772976 773302 776088 777989 778531 780553 781494 783900 783907 783913 783935 784155 784704 784759 785665 785775 786726 787524 792025 792176 793205 793207 793941 794931 796194 797079 800516 801636 801724 803566 807008 808158 808327 810913 813298 814491 823272 ] |
||||||||||||||||||||||||||||||
|
11.71 ms (8.02%) |
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 467889 648220 600206 388962 784759 783913 785665 208554 444051 678838 557582 626108 777989 780553 449908 493909 450067 792176 778531 796194 747483 823272 497013 680612 794931 767695 772398 618267 403948 263039 398643 403035 403421 537651 581236 661061 673794 714238 556896 565425 629771 587465 596660 629797 781494 807008 739915 783935 801724 803566 808158 762714 705427 772951 415311 408241 434673 448522 528770 499789 541567 544852 555044 784155 801636 602793 462862 406108 461853 525700 521238 596240 696499 600337 499800 429117 434007 429410 665993 700259 783900 793205 739134 608380 622663 784704 813298 525209 735555 669000 578039 506688 593994 541669 708013 713167 783907 785775 792025 787524 793207 800516 810913 772976 766155 740803 744982 773302 776088 797079 515435 579582 556755 808327 814491 463420 546981 555306 786726 793941 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.75%) |
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 208554 263039 388962 398643 403035 403421 403948 406108 408241 415311 429117 429410 434007 434673 444051 448522 449908 450067 461853 462862 463420 467889 493909 497013 499789 499800 506688 515435 521238 525209 525700 528770 537651 541567 541669 544852 546981 555044 555306 556755 556896 557582 565425 578039 579582 581236 587465 593994 596240 596660 600206 600337 602793 608380 618267 622663 626108 629771 629797 648220 661061 665993 669000 673794 678838 680612 696499 700259 705427 708013 713167 714238 735555 739134 739915 740803 744982 747483 762714 766155 767695 772398 772951 772976 773302 776088 777989 778531 780553 781494 783900 783907 783913 783935 784155 784704 784759 785665 785775 786726 787524 792025 792176 793205 793207 793941 794931 796194 797079 800516 801636 801724 803566 807008 808158 808327 810913 813298 814491 823272 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
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.