Query Metrics
7
Database Queries
7
Different statements
367.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.35 ms (55.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
141.02 ms (38.41%) |
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 263039 263536 398499 406108 413687 416832 417553 418084 418594 418621 424270 428264 438178 439244 465309 468658 473607 475139 482242 494546 496345 498795 500945 505805 515874 520216 521652 522324 526501 528407 528770 531301 533099 534294 534330 537860 544401 556496 557679 559368 564250 566775 566777 566843 579582 581236 583807 584125 587899 599927 600340 602793 606583 618306 622065 630533 639326 641672 643384 648220 657236 673794 677839 678842 685527 705005 708714 710895 715594 724987 727483 728233 728669 733590 734017 740894 744782 748488 749972 750895 755554 756491 756768 756950 759826 766721 767479 771152 773016 777926 779862 780242 780553 781494 783921 783937 784862 784965 785197 786906 787047 787332 793847 794217 796365 801795 801827 802644 804064 807008 808262 808962 812326 812565 813726 814491 816033 818950 820057 820157 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (3.86%) |
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 559368 496345 808962 728233 413687 818950 820057 531301 657236 796365 748488 771152 749972 468658 544401 786906 418594 534330 416832 812326 784862 808262 750895 766721 727483 710895 787332 606583 439244 780553 767479 473607 787047 465309 678842 677839 398499 475139 526501 773016 783937 528770 816033 505805 515874 537860 534294 685527 785197 779862 784965 783921 756950 801795 802644 804064 418084 428264 482242 424270 417553 813726 740894 744782 263536 801827 583807 587899 500945 263039 820157 618306 781494 600340 566843 793847 705005 708714 812565 755554 756491 520216 622065 734017 556496 599927 630533 564250 579582 639326 648220 522324 814491 557679 438178 533099 643384 728669 724987 759826 733590 715594 566775 673794 780242 807008 418621 566777 494546 528407 521652 641672 756768 498795 581236 406108 584125 794217 602793 777926 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (0.70%) |
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 263039 263536 398499 406108 413687 416832 417553 418084 418594 418621 424270 428264 438178 439244 465309 468658 473607 475139 482242 494546 496345 498795 500945 505805 515874 520216 521652 522324 526501 528407 528770 531301 533099 534294 534330 537860 544401 556496 557679 559368 564250 566775 566777 566843 579582 581236 583807 584125 587899 599927 600340 602793 606583 618306 622065 630533 639326 641672 643384 648220 657236 673794 677839 678842 685527 705005 708714 710895 715594 724987 727483 728233 728669 733590 734017 740894 744782 748488 749972 750895 755554 756491 756768 756950 759826 766721 767479 771152 773016 777926 779862 780242 780553 781494 783921 783937 784862 784965 785197 786906 787047 787332 793847 794217 796365 801795 801827 802644 804064 807008 808262 808962 812326 812565 813726 814491 816033 818950 820057 820157 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass squirt"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.38%) |
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.