Query Metrics
7
Database Queries
7
Different statements
245.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.66 ms (87.96%) |
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 261656 382190 382594 389583 395698 397130 401281 402866 405584 419028 422488 428384 433013 438879 443093 443548 443590 450657 454621 456936 458962 459166 459265 459798 461460 461886 462769 466781 469644 471759 486698 490786 494046 506556 512174 512765 512826 512877 513346 524002 527044 527567 527711 533767 537669 546840 547136 548785 563823 568875 571221 572846 575111 579775 580721 585896 588501 590461 594165 596198 596673 598223 598496 598742 605405 606403 606595 606798 636003 637025 649129 649135 649845 659287 662169 670097 683583 687232 691607 693164 696024 697150 697427 698994 703070 703534 703535 706589 708475 718520 720422 722190 736444 738630 738775 743142 753517 754243 756085 766956 774162 775492 779979 787620 788100 788309 789721 792871 793901 799864 802491 806101 808849 812922 817410 817898 821182 822296 822786 825536 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (7.16%) |
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 822786 821182 691607 596198 736444 766956 512877 598223 670097 443093 459166 659287 596673 572846 458962 706589 779979 754243 703534 419028 580721 697150 637025 683583 513346 462769 571221 606403 756085 774162 606798 585896 568875 512826 405584 533767 443590 787620 547136 696024 808849 738630 443548 546840 817410 588501 598742 788100 793901 524002 466781 775492 649129 649135 812922 490786 486698 456936 471759 450657 817898 512765 575111 649845 662169 579775 537669 738775 687232 693164 459798 708475 512174 799864 743142 527044 753517 527711 606595 397130 697427 788309 527567 703535 459265 469644 261656 422488 428384 822296 605405 806101 636003 563823 389583 720422 548785 698994 590461 494046 722190 703070 402866 598496 594165 433013 395698 438879 454621 382594 401281 825536 802491 461886 789721 506556 718520 792871 461460 382190 ] |
||||||||||||||||||||||||||||||
|
4.46 ms (1.82%) |
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 261656 382190 382594 389583 395698 397130 401281 402866 405584 419028 422488 428384 433013 438879 443093 443548 443590 450657 454621 456936 458962 459166 459265 459798 461460 461886 462769 466781 469644 471759 486698 490786 494046 506556 512174 512765 512826 512877 513346 524002 527044 527567 527711 533767 537669 546840 547136 548785 563823 568875 571221 572846 575111 579775 580721 585896 588501 590461 594165 596198 596673 598223 598496 598742 605405 606403 606595 606798 636003 637025 649129 649135 649845 659287 662169 670097 683583 687232 691607 693164 696024 697150 697427 698994 703070 703534 703535 706589 708475 718520 720422 722190 736444 738630 738775 743142 753517 754243 756085 766956 774162 775492 779979 787620 788100 788309 789721 792871 793901 799864 802491 806101 808849 812922 817410 817898 821182 822296 822786 825536 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen blowjob public"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen минет оральн секс на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen минет оральн секс на улиц"
]
|
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.