Query Metrics
7
Database Queries
7
Different statements
270.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.90 ms (89.18%) |
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 2407 7740 32761 161378 187048 382458 384251 385952 386331 386456 386975 389412 389726 390634 396001 398319 398916 402822 404418 408170 416869 425272 425942 428598 442070 443211 446381 449466 449854 450269 450438 453025 456585 459077 460306 464182 464625 465223 467111 469937 472271 473461 473490 474194 474500 476477 477605 477795 479123 480434 481484 484041 488342 488931 490291 496009 498557 498667 503020 506148 506637 508760 518642 518882 519747 520111 521091 521537 522513 527027 529321 529507 531718 535241 535846 537122 538201 542640 547715 547864 563757 571277 573616 579601 579967 581232 582920 583439 586290 587018 587314 588022 588456 594219 595326 598831 598934 599421 600510 602177 602788 621300 624046 626870 629539 640295 644161 652639 655779 678443 678456 699449 702261 710881 717187 719642 725343 727251 795928 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (5.41%) |
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 579601 453025 161378 547715 385952 7740 702261 581232 390634 527027 425942 587018 404418 398916 476477 508760 484041 538201 521091 521537 626870 428598 573616 602177 450269 442070 537122 587314 32761 473490 386331 402822 389412 588022 443211 464182 472271 719642 416869 460306 384251 450438 506148 621300 710881 459077 582920 598934 600510 595326 678443 678456 640295 588456 644161 529321 542640 598831 473461 519747 425272 474194 477795 490291 503020 531718 488342 396001 474500 525060 498667 586290 655779 795928 629539 480434 579967 652639 602788 624046 725343 727251 717187 449854 518882 535241 479123 408170 446381 481484 449466 594219 389726 469937 456585 522513 187048 506637 464625 2407 518642 496009 386456 571277 465223 477605 488931 535846 699449 498557 529507 547864 563757 599421 382458 386975 398319 520111 583439 467111 ] |
||||||||||||||||||||||||||||||
|
6.68 ms (2.47%) |
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 2407 7740 32761 161378 187048 382458 384251 385952 386331 386456 386975 389412 389726 390634 396001 398319 398916 402822 404418 408170 416869 425272 425942 428598 442070 443211 446381 449466 449854 450269 450438 453025 456585 459077 460306 464182 464625 465223 467111 469937 472271 473461 473490 474194 474500 476477 477605 477795 479123 480434 481484 484041 488342 488931 490291 496009 498557 498667 503020 506148 506637 508760 518642 518882 519747 520111 521091 521537 522513 527027 529321 529507 531718 535241 535846 537122 538201 542640 547715 547864 563757 571277 573616 579601 579967 581232 582920 583439 586290 587018 587314 588022 588456 594219 595326 598831 598934 599421 600510 602177 602788 621300 624046 626870 629539 640295 644161 652639 655779 678443 678456 699449 702261 710881 717187 719642 725343 727251 795928 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding big dick"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.60%) |
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.