Query Metrics
7
Database Queries
7
Different statements
152.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.66 ms (83.98%) |
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 61866 390375 390645 411812 413639 416295 419466 423447 456097 458360 468073 488557 511179 541573 542091 552156 569517 571543 577950 592700 594429 605714 611828 615041 618778 626882 627567 638145 649851 650095 653506 668987 670032 671213 673890 678238 682644 701451 703814 708233 708701 709155 710817 716825 716929 720793 724550 726385 727562 727887 728646 730225 730686 731160 731393 731396 732582 734294 735463 740875 741832 742836 743775 743954 745610 746137 747565 747822 747946 752438 755166 755916 756269 756947 758405 763331 763558 763579 766057 768380 769354 769616 771159 771445 771803 779008 779228 781569 783840 785191 786421 789229 790132 790480 793173 793462 793732 793737 794470 797650 801057 801129 801612 803435 804556 805846 806251 806281 806341 806731 806865 812983 814307 819942 823422 823498 823655 824934 825667 827578 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (9.03%) |
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 756269 734294 746137 728646 731160 731393 740875 747565 771803 618778 790480 806251 806341 416295 488557 605714 731396 752438 766057 789229 511179 61866 411812 819942 823498 827578 823422 824934 571543 541573 542091 569517 650095 673890 708233 710817 703814 716929 720793 709155 626882 627567 793737 803435 730225 742836 755166 801057 806731 755916 756947 758405 726385 727562 735463 745610 730686 732582 743954 747946 763558 763331 611828 701451 793732 794470 390375 419466 468073 552156 577950 716825 649851 615041 727887 741832 806281 456097 413639 423447 823655 814307 825667 668987 670032 671213 678238 682644 708701 653506 592700 594429 779008 779228 793173 785191 769354 771159 781569 783840 790132 793462 801129 801612 804556 805846 724550 771445 747822 768380 743775 763579 769616 638145 786421 797650 806865 812983 390645 458360 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.92%) |
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 61866 390375 390645 411812 413639 416295 419466 423447 456097 458360 468073 488557 511179 541573 542091 552156 569517 571543 577950 592700 594429 605714 611828 615041 618778 626882 627567 638145 649851 650095 653506 668987 670032 671213 673890 678238 682644 701451 703814 708233 708701 709155 710817 716825 716929 720793 724550 726385 727562 727887 728646 730225 730686 731160 731393 731396 732582 734294 735463 740875 741832 742836 743775 743954 745610 746137 747565 747822 747946 752438 755166 755916 756269 756947 758405 763331 763558 763579 766057 768380 769354 769616 771159 771445 771803 779008 779228 781569 783840 785191 786421 789229 790132 790480 793173 793462 793732 793737 794470 797650 801057 801129 801612 803435 804556 805846 806251 806281 806341 806731 806865 812983 814307 819942 823422 823498 823655 824934 825667 827578 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick on face"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член face"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член face"
]
|
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.