Query Metrics
7
Database Queries
7
Different statements
190.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.90 ms (88.75%) |
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 152129 152762 185247 381887 387868 397349 397633 435244 442611 444296 459735 472856 474421 485069 495434 503739 506564 526330 527679 530287 533162 540934 542813 567454 574223 578690 579752 596986 597429 600855 603368 603633 605378 618069 620410 630672 649776 651393 662903 669328 671901 675926 698220 705418 708855 710294 715468 717833 718240 718453 718972 720666 722426 723831 723878 724227 726755 728653 732491 733481 735917 736167 743926 745883 745889 749537 754871 757629 757651 762063 764388 765838 766210 771778 773782 779130 779875 779897 782897 789348 789611 790161 794747 795197 795429 796000 798793 799089 805018 807784 810151 812133 813475 813655 813700 814101 817429 817686 817691 817701 817710 818043 819020 819201 819206 819266 819527 820781 823055 823352 823476 825023 825070 825302 826735 827167 827481 828053 828123 ] |
||||||||||||||||||||||||||||||
|
11.44 ms (6.01%) |
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 474421 444296 435244 442611 495434 527679 675926 605378 503739 397349 526330 798793 817429 649776 387868 819266 825302 618069 567454 828123 698220 717833 814101 723831 749537 720666 779130 779897 823476 826735 542813 812133 820781 603368 795197 152129 819201 506564 540934 708855 671901 620410 764388 732491 828053 579752 796000 754871 813475 813655 827481 817691 669328 597429 765838 766210 794747 818043 819206 819527 718240 710294 728653 762131 743926 762063 705418 789611 807784 718972 745889 745883 771778 459735 472856 574223 715468 596986 600855 805018 810151 779875 789348 723878 757651 630672 825023 485069 381887 823055 827167 823352 718453 782897 736167 733481 724227 152762 817710 825070 533162 757629 735917 773782 726755 603633 799089 722426 185247 817701 530287 790161 651393 795429 397633 817686 819020 813700 578690 662903 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.78%) |
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 152129 152762 185247 381887 387868 397349 397633 435244 442611 444296 459735 472856 474421 485069 495434 503739 506564 526330 527679 530287 533162 540934 542813 567454 574223 578690 579752 596986 597429 600855 603368 603633 605378 618069 620410 630672 649776 651393 662903 669328 671901 675926 698220 705418 708855 710294 715468 717833 718240 718453 718972 720666 722426 723831 723878 724227 726755 728653 732491 733481 735917 736167 743926 745883 745889 749537 754871 757629 757651 762063 764388 765838 766210 771778 773782 779130 779875 779897 782897 789348 789611 790161 794747 795197 795429 796000 798793 799089 805018 807784 810151 812133 813475 813655 813700 814101 817429 817686 817691 817701 817710 818043 819020 819201 819206 819266 819527 820781 823055 823352 823476 825023 825070 825302 826735 827167 827481 828053 828123 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in hotel"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hotel"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hotel"
]
|
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.