Query Metrics
7
Database Queries
7
Different statements
353.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.40 ms (59.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"room sex"
]
|
||||||||||||||||||||||||||||||
|
119.71 ms (33.84%) |
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 152508 348275 382793 382960 383482 398247 408701 412507 419987 424937 425305 427634 448358 451712 453191 458009 459438 460477 461851 471385 472172 478260 483880 494931 496192 511045 511140 512144 519535 534943 536352 539700 543384 544959 547653 553171 554360 557539 559072 561989 564093 582568 586186 590223 593598 602405 608202 608828 614587 614631 624079 625233 628125 636471 636599 639330 642571 643319 650648 663921 672380 672765 680682 681381 683416 689169 696077 703554 704837 708237 708433 712122 718790 719716 721068 722591 724102 724601 725624 726687 726694 734794 739529 739675 741082 747682 750724 758028 762487 765168 770313 775541 782301 783267 785184 786635 788799 790016 792581 794921 795033 796953 797874 798207 799864 801329 801526 801552 801786 807486 810521 811898 812286 814769 820652 821527 821891 823504 827648 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (4.55%) |
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 821891 471385 608202 586186 783267 799864 412507 348275 424937 823504 534943 557539 672380 689169 672765 590223 801526 795033 425305 453191 519535 511045 582568 547653 683416 704837 681381 680682 602405 643319 775541 794921 811898 739529 724601 750724 708237 722591 382960 398247 408701 820652 821527 448358 483880 494931 721068 696077 663921 703554 712122 642571 628125 624079 625233 786635 790016 725624 734794 807486 758028 741082 801329 451712 461851 427634 827648 458009 512144 544959 593598 798207 726694 801552 812286 724102 739675 788799 792581 801786 496192 770313 543384 782301 762487 718790 472172 553171 554360 708433 639330 478260 419987 814769 460477 511140 536352 539700 561989 559072 564093 699417 719716 650648 608828 614587 614631 636471 636599 810521 796953 785184 747682 765168 726687 797874 152508 459438 382793 383482 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (0.88%) |
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 152508 348275 382793 382960 383482 398247 408701 412507 419987 424937 425305 427634 448358 451712 453191 458009 459438 460477 461851 471385 472172 478260 483880 494931 496192 511045 511140 512144 519535 534943 536352 539700 543384 544959 547653 553171 554360 557539 559072 561989 564093 582568 586186 590223 593598 602405 608202 608828 614587 614631 624079 625233 628125 636471 636599 639330 642571 643319 650648 663921 672380 672765 680682 681381 683416 689169 696077 703554 704837 708237 708433 712122 718790 719716 721068 722591 724102 724601 725624 726687 726694 734794 739529 739675 741082 747682 750724 758028 762487 765168 770313 775541 782301 783267 785184 786635 788799 790016 792581 794921 795033 796953 797874 798207 799864 801329 801526 801552 801786 807486 810521 811898 812286 814769 820652 821527 821891 823504 827648 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"room секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"room секс"
]
|
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.