Query Metrics
7
Database Queries
7
Different statements
138.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.82 ms (84.49%) |
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 69871 123257 230986 271329 387006 397686 438040 438056 443459 444169 444337 455860 460534 462087 465486 484550 493431 497766 508374 514101 518819 519173 540612 540642 542082 545310 557922 560535 567081 585737 587745 598150 606886 614597 614693 626846 630775 634614 634615 638164 645006 647359 653952 662062 674826 682269 689970 694732 696350 698245 698247 706018 708208 710920 713133 714149 714658 714826 723482 724671 732605 732695 733190 735446 736113 740954 743422 745357 746536 747873 750711 753250 758255 760940 761889 763905 766224 771324 772339 775292 776138 777103 777482 778619 779075 779203 781030 783271 785841 787222 787556 787590 788026 789127 791578 793500 795015 796202 797668 799174 799690 800608 803701 805628 808840 813100 817447 818222 819699 819763 824918 824974 825046 825177 825839 826559 828366 ] |
||||||||||||||||||||||||||||||
|
11.49 ms (8.31%) |
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 696350 787590 747873 763214 779203 783271 825177 540642 518819 779075 732695 789127 750711 758255 740954 753250 123257 629530 638164 630775 825839 776138 694732 805628 444337 567081 775292 817447 828580 493431 647359 674826 796202 484550 777103 795015 813100 761889 732605 714149 778619 785841 662062 689970 713133 743422 387006 271329 824918 826559 443459 438040 519173 542082 714826 735446 645006 514101 653952 714658 824974 706018 614693 708208 614597 508374 444169 606886 587745 634615 634614 793500 797668 724671 788026 808840 799174 540612 585737 497766 760940 698245 777482 787556 746536 560535 598150 462087 723482 230986 397686 819699 819763 818222 828366 545310 698247 626846 799690 803701 781030 763905 745357 772339 733190 736113 787222 69871 460534 557922 791578 800608 771324 710920 438056 825046 766224 682269 465486 455860 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (2.03%) |
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 69871 123257 230986 271329 387006 397686 438040 438056 443459 444169 444337 455860 460534 462087 465486 484550 493431 497766 508374 514101 518819 519173 540612 540642 542082 545310 557922 560535 567081 585737 587745 598150 606886 614597 614693 626846 630775 634614 634615 638164 645006 647359 653952 662062 674826 682269 689970 694732 696350 698245 698247 706018 708208 710920 713133 714149 714658 714826 723482 724671 732605 732695 733190 735446 736113 740954 743422 745357 746536 747873 750711 753250 758255 760940 761889 763905 766224 771324 772339 775292 776138 777103 777482 778619 779075 779203 781030 783271 785841 787222 787556 787590 788026 789127 791578 793500 795015 796202 797668 799174 799690 800608 803701 805628 808840 813100 817447 818222 819699 819763 824918 824974 825046 825177 825839 826559 828366 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cum"
]
|
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.