Query Metrics
7
Database Queries
7
Different statements
150.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.23 ms (81.89%) |
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 386751 403725 417192 421015 423055 423535 424197 425594 428281 436848 438029 441031 442479 443061 446126 446666 448722 449245 450910 451880 457962 458319 459225 460092 461232 461261 463057 463070 466677 466781 472028 472514 476084 477774 478084 478390 480089 486925 493943 495532 497317 498456 498512 504000 504578 504951 506315 513240 519789 522441 527683 528594 532328 541302 541948 542087 543191 543353 546906 550714 552252 552360 553968 555936 556007 558999 560438 561358 564451 565242 565892 571392 572982 576391 580393 582633 587018 589200 590123 597258 600743 605980 618995 620097 626354 636065 641414 691219 698372 708263 713733 726970 745063 747186 750692 764247 765803 766896 771815 775137 776263 777870 779567 779904 788519 797870 798720 804509 804525 806019 806841 807653 807855 810402 810619 813459 814975 820822 821610 824456 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (10.96%) |
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 806841 747186 386751 463057 519789 461261 478084 771815 403725 421015 450910 522441 541302 441031 775137 824456 446126 589200 797870 564451 550714 565242 698372 626354 620097 776263 777870 804525 810619 813459 750692 765803 807855 543353 527683 497317 495532 820822 541948 472028 442479 552360 558999 446666 436848 461232 466781 449245 480089 821610 472514 580393 618995 804509 814975 779567 806019 590123 532328 543191 423055 463070 552252 571392 556007 459225 478390 451880 498512 504951 691219 798720 476084 425594 428281 486925 528594 576391 600743 605980 641414 424197 745063 555936 713733 766896 443061 498456 493943 582633 504000 597258 504578 417192 448722 466677 457962 458319 708263 636065 587018 779904 810402 764247 807653 438029 477774 726970 513240 506315 460092 560438 542087 546906 553968 561358 565892 572982 788519 423535 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.73%) |
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 386751 403725 417192 421015 423055 423535 424197 425594 428281 436848 438029 441031 442479 443061 446126 446666 448722 449245 450910 451880 457962 458319 459225 460092 461232 461261 463057 463070 466677 466781 472028 472514 476084 477774 478084 478390 480089 486925 493943 495532 497317 498456 498512 504000 504578 504951 506315 513240 519789 522441 527683 528594 532328 541302 541948 542087 543191 543353 546906 550714 552252 552360 553968 555936 556007 558999 560438 561358 564451 565242 565892 571392 572982 576391 580393 582633 587018 589200 590123 597258 600743 605980 618995 620097 626354 636065 641414 691219 698372 708263 713733 726970 745063 747186 750692 764247 765803 766896 771815 775137 776263 777870 779567 779904 788519 797870 798720 804509 804525 806019 806841 807653 807855 810402 810619 813459 814975 820822 821610 824456 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov blowjob hot"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов минет оральн секс hot"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов минет оральн секс hot"
]
|
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.