Query Metrics
7
Database Queries
7
Different statements
163.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.61 ms (83.51%) |
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 382045 382739 382748 382808 383367 383659 387198 388313 389895 389945 392599 395134 395141 396711 396889 398530 402419 406018 407365 407684 411324 411397 411614 411776 446853 462606 465386 465570 465892 466189 466318 466394 474095 475861 482782 484413 484746 485690 504173 509044 515994 517073 519038 523392 525269 527142 534334 536140 549799 555788 588233 619526 623487 624366 681075 702362 707428 709359 715551 720004 720455 724023 725655 726574 726576 726830 731788 732344 733091 735934 735992 736307 740117 740616 741091 744825 745799 745844 745929 746173 748246 752627 755369 758427 759477 759693 765640 766690 770112 772104 773577 774331 779341 785607 788490 789532 798087 798905 800360 800712 803941 804194 804983 805711 806286 813835 816774 816793 817394 818057 818478 819508 819621 819894 824152 824621 825155 825439 825775 826889 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (9.99%) |
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 789532 733091 740117 746173 748246 798087 805711 736307 755369 774331 724023 726576 740616 745844 765640 772104 773577 726830 731788 745799 726574 732344 741091 752627 758427 766690 707428 709359 798905 803941 804194 804983 411324 475861 392599 465386 411397 382748 388313 466318 509044 484413 466394 387198 402419 819508 824152 825155 824621 825439 465570 536140 525269 702362 681075 720004 720455 555788 624366 800712 788490 725655 745929 800360 759693 744825 735934 759477 770112 715551 779341 785607 383659 406018 474095 485690 549799 389895 466189 465892 484746 826889 816774 825775 588233 806286 735992 534334 504173 515994 517073 462606 619526 623487 523392 527142 519038 382739 382808 383367 395141 395134 382045 389945 396711 396889 398530 407365 407684 411614 411776 816793 817394 818057 813835 819621 818478 819894 446853 482782 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.71%) |
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 382045 382739 382748 382808 383367 383659 387198 388313 389895 389945 392599 395134 395141 396711 396889 398530 402419 406018 407365 407684 411324 411397 411614 411776 446853 462606 465386 465570 465892 466189 466318 466394 474095 475861 482782 484413 484746 485690 504173 509044 515994 517073 519038 523392 525269 527142 534334 536140 549799 555788 588233 619526 623487 624366 681075 702362 707428 709359 715551 720004 720455 724023 725655 726574 726576 726830 731788 732344 733091 735934 735992 736307 740117 740616 741091 744825 745799 745844 745929 746173 748246 752627 755369 758427 759477 759693 765640 766690 770112 772104 773577 774331 779341 785607 788490 789532 798087 798905 800360 800712 803941 804194 804983 805711 806286 813835 816774 816793 817394 818057 818478 819508 819621 819894 824152 824621 825155 825439 825775 826889 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature pussy"
]
|
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.