Query Metrics
7
Database Queries
7
Different statements
150.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.03 ms (81.12%) |
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 268222 268747 285233 383774 395236 395335 396556 398261 398477 398513 398695 400480 402346 402762 413273 416826 421851 422154 423908 424038 424446 428610 432647 432735 432736 432878 440745 440877 446061 447521 447690 447732 447804 448951 449141 450344 450889 453727 454600 456236 457890 458420 460299 463156 465986 466007 466261 467948 468105 469565 470968 473222 478644 481748 483567 483568 484193 484763 485086 488454 491920 493568 496077 500922 509063 509818 512935 517662 517768 517797 519063 521552 529709 546005 554252 570160 576933 578327 579746 579848 590843 593768 604373 604426 626256 654338 656206 670906 678868 686457 695719 715566 720598 723573 725619 726974 728706 740248 740589 741296 742341 743578 746378 756089 759370 764186 766830 768760 787492 788837 789664 819005 821089 822086 825943 826067 827589 828198 828788 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (11.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 766830 725619 759370 764186 715566 720598 788837 789664 424038 450344 469565 481748 483567 517662 493568 463156 383774 468105 268747 395335 395236 678868 656206 626256 485086 428610 432647 483568 529709 478644 579746 654338 579848 423908 484193 519063 422154 398261 400480 432735 432736 440877 440745 446061 488454 458420 467948 453727 454600 496077 512935 460299 554252 576933 570160 578327 590843 593768 413273 447690 473222 449141 398695 402762 421851 500922 517797 740248 768760 743578 756089 484763 398477 447521 695719 456236 432878 268222 402346 723573 670906 686457 604373 740583 728706 741296 742341 746378 740589 787492 509063 465986 726974 447804 521552 546005 416826 447732 457890 491920 466007 509818 466261 450889 470968 517768 285233 448951 604426 424446 396556 398513 819005 825943 827589 822086 821089 828198 828788 826067 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.81%) |
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 268222 268747 285233 383774 395236 395335 396556 398261 398477 398513 398695 400480 402346 402762 413273 416826 421851 422154 423908 424038 424446 428610 432647 432735 432736 432878 440745 440877 446061 447521 447690 447732 447804 448951 449141 450344 450889 453727 454600 456236 457890 458420 460299 463156 465986 466007 466261 467948 468105 469565 470968 473222 478644 481748 483567 483568 484193 484763 485086 488454 491920 493568 496077 500922 509063 509818 512935 517662 517768 517797 519063 521552 529709 546005 554252 570160 576933 578327 579746 579848 590843 593768 604373 604426 626256 654338 656206 670906 678868 686457 695719 715566 720598 723573 725619 726974 728706 740248 740589 741296 742341 743578 746378 756089 759370 764186 766830 768760 787492 788837 789664 819005 821089 822086 825943 826067 827589 828198 828788 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал через трусики"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.