Query Metrics
7
Database Queries
7
Different statements
181.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.77 ms (87.30%) |
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 7665 12731 28591 28717 91891 188621 263788 307339 318343 382058 396866 397382 398614 410855 431537 431744 450652 451798 470194 477360 489616 491367 494261 504042 504170 506548 512535 536979 540957 545585 552928 555688 559029 559644 559711 564157 590631 590867 593759 603549 603627 607620 608038 622005 622154 622155 622613 624225 624510 632028 644303 647980 649146 650842 651003 651888 651889 653165 653619 664855 665876 667656 669408 671004 677957 680657 681271 682423 694143 702058 705663 709295 720834 721072 721568 723582 724111 724440 726252 726799 732784 734422 735078 746082 770799 770874 770885 770891 771282 775931 778061 781414 783412 790971 791571 797936 798083 800259 801944 806038 806300 807191 807512 810668 811236 811931 817445 817658 817692 817912 817914 820523 823873 824804 825122 826865 827370 827516 828257 828647 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (7.30%) |
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 817658 817914 820523 817692 649146 694143 720834 622154 811236 770891 771282 790971 806300 770799 798083 7665 28591 451798 817445 477360 470194 669408 677957 681271 647980 632028 608038 801944 644303 810668 431744 504170 491367 410855 494261 91891 28717 559029 512535 564157 555688 603627 778061 382058 824804 827516 817912 552928 650842 671004 797936 770874 770885 398614 450652 431537 590867 318343 827370 536979 506548 540957 651888 665876 667656 651889 653619 664855 622005 622155 781414 735078 746082 723582 825122 545585 559644 680657 702058 651003 806038 807512 726799 724111 705663 709295 811931 489616 807191 775931 593759 603549 734422 823873 826865 828257 828647 721568 783412 800259 732784 622613 263788 791571 590631 307339 397382 682423 188621 396866 653165 726252 624225 721072 12731 724440 504042 559711 607620 624510 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.55%) |
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 7665 12731 28591 28717 91891 188621 263788 307339 318343 382058 396866 397382 398614 410855 431537 431744 450652 451798 470194 477360 489616 491367 494261 504042 504170 506548 512535 536979 540957 545585 552928 555688 559029 559644 559711 564157 590631 590867 593759 603549 603627 607620 608038 622005 622154 622155 622613 624225 624510 632028 644303 647980 649146 650842 651003 651888 651889 653165 653619 664855 665876 667656 669408 671004 677957 680657 681271 682423 694143 702058 705663 709295 720834 721072 721568 723582 724111 724440 726252 726799 732784 734422 735078 746082 770799 770874 770885 770891 771282 775931 778061 781414 783412 790971 791571 797936 798083 800259 801944 806038 806300 807191 807512 810668 811236 811931 817445 817658 817692 817912 817914 820523 823873 824804 825122 826865 827370 827516 828257 828647 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.71%) |
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.