Query Metrics
7
Database Queries
7
Different statements
231.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.76 ms (88.30%) |
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 399143 417756 419729 419822 420306 420719 422401 424207 425269 425272 425365 427580 429247 429276 434251 435774 435916 437402 441708 442442 442550 442810 443177 445566 445851 448978 449501 452370 455981 458946 459377 462281 463070 466538 468264 469022 473771 473990 473995 475240 475394 475815 476477 477243 480162 482663 485636 492559 497850 498782 508828 509217 512423 512936 517370 525434 525614 527949 529465 542079 544650 546895 548339 552584 552718 554001 555836 556816 556966 558809 558903 560104 560304 560791 565027 565742 567881 568419 569274 569419 571838 578129 580239 583179 586861 591455 594463 601634 602930 637959 654945 663318 684830 700588 711700 721560 739445 764806 769797 771682 772781 775004 776154 777750 779877 783871 788046 791301 792310 795512 795761 796442 798616 806043 809341 810678 812814 813035 815063 816679 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (7.46%) |
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 591455 602930 637959 775004 776154 777750 795761 809341 810678 813035 772781 792310 796442 806043 764806 771682 769797 739445 779877 788046 798616 812814 473990 473995 419822 424207 441708 462281 466538 425269 442442 445566 476477 422401 437402 442550 468264 509217 525614 498782 517370 485636 508828 512423 529465 560304 583179 791301 795512 783871 816679 815063 475394 512936 569274 601634 399143 442810 435916 459377 449501 555836 554001 560791 480162 452370 654945 420306 425272 435774 427580 429276 417756 420719 443177 419729 425365 429247 434251 445851 455981 448978 458946 463070 473771 475240 475815 477243 482663 492559 525434 497850 527949 469022 542079 546895 558809 558903 568419 544650 552584 552718 571838 548339 565742 567881 580239 700588 684830 663318 711700 721560 556816 556966 560104 565027 569419 578129 586861 594463 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.08%) |
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 399143 417756 419729 419822 420306 420719 422401 424207 425269 425272 425365 427580 429247 429276 434251 435774 435916 437402 441708 442442 442550 442810 443177 445566 445851 448978 449501 452370 455981 458946 459377 462281 463070 466538 468264 469022 473771 473990 473995 475240 475394 475815 476477 477243 480162 482663 485636 492559 497850 498782 508828 509217 512423 512936 517370 525434 525614 527949 529465 542079 544650 546895 548339 552584 552718 554001 555836 556816 556966 558809 558903 560104 560304 560791 565027 565742 567881 568419 569274 569419 571838 578129 580239 583179 586861 591455 594463 601634 602930 637959 654945 663318 684830 700588 711700 721560 739445 764806 769797 771682 772781 775004 776154 777750 779877 783871 788046 791301 792310 795512 795761 796442 798616 806043 809341 810678 812814 813035 815063 816679 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny pov"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny пов"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny пов"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.63%) |
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.