Query Metrics
7
Database Queries
7
Different statements
182.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.22 ms (84.57%) |
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 199188 397883 397912 397918 397919 407802 421849 422261 422821 426940 428073 432650 437314 438562 439560 439715 442932 443747 444171 448975 449702 450181 450812 452320 455788 456000 458554 459947 460744 460745 460748 463481 463700 465388 468355 471419 476271 477981 478377 479027 479493 486539 488073 492333 498321 502326 504927 506044 507829 510074 512017 514042 518851 520683 521401 521634 523902 531997 532063 532064 532126 549661 551035 553433 559083 567074 567218 571254 577598 582656 587677 609422 661913 661991 677862 694105 696567 714297 716584 723744 726593 726753 730904 736379 739965 742022 743463 746207 746267 746497 755695 757070 757201 757288 758171 758594 764309 769550 773403 775889 777217 777739 779347 779902 789188 789276 792287 792522 794403 796197 796208 796214 800934 802075 803363 809791 811314 827842 ] |
||||||||||||||||||||||||||||||
|
17.91 ms (9.82%) |
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 532063 694105 661913 609422 757201 521634 521401 397912 397919 458554 796208 792287 796197 802075 757288 803363 811314 746207 764309 726593 779347 794403 809791 199188 407802 437314 421849 439560 465388 506044 518851 438562 531997 559083 587677 452320 439715 488073 520683 567218 486539 730904 769550 460744 502326 696567 697943 397918 428073 422261 432650 450181 450812 459947 449702 471419 571254 726753 397883 443747 456000 422821 426940 448975 460748 463481 478377 468355 512017 498321 523902 507829 479493 532126 582656 716584 775889 789188 777217 792522 773403 796214 723744 746267 758594 736379 739965 742022 757070 758171 777739 779902 800934 455788 460745 442932 476271 479027 477981 567074 510074 444171 514042 492333 504927 549661 755695 789276 743463 736517 746497 827842 463700 532064 551035 577598 553433 677862 714297 661991 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.65%) |
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 199188 397883 397912 397918 397919 407802 421849 422261 422821 426940 428073 432650 437314 438562 439560 439715 442932 443747 444171 448975 449702 450181 450812 452320 455788 456000 458554 459947 460744 460745 460748 463481 463700 465388 468355 471419 476271 477981 478377 479027 479493 486539 488073 492333 498321 502326 504927 506044 507829 510074 512017 514042 518851 520683 521401 521634 523902 531997 532063 532064 532126 549661 551035 553433 559083 567074 567218 571254 577598 582656 587677 609422 661913 661991 677862 694105 696567 714297 716584 723744 726593 726753 730904 736379 739965 742022 743463 746207 746267 746497 755695 757070 757201 757288 758171 758594 764309 769550 773403 775889 777217 777739 779347 779902 789188 789276 792287 792522 794403 796197 796208 796214 800934 802075 803363 809791 811314 827842 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mom boy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск mom парен"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск mom парен"
]
|
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.