Query Metrics
7
Database Queries
7
Different statements
154.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.42 ms (86.95%) |
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 387868 412616 459735 506564 533162 540934 543995 544113 552247 562453 562544 567454 574223 578690 579752 586011 587947 596986 597429 600855 603368 604616 610124 618069 620410 630672 635737 639073 649776 656296 669328 671901 680852 680853 685259 691148 691997 692021 695367 698220 705418 706439 708855 710294 714576 715468 718240 720666 721677 723831 723878 725620 728525 728653 730785 732491 734621 735186 737943 742271 742665 743926 745883 745889 745899 748879 749537 753757 754871 757651 757698 759024 762063 763824 764388 765838 766210 777949 778519 779130 779875 779897 789348 789396 789611 794181 794332 794747 795197 796000 798793 799823 800916 801926 802915 803814 805018 810151 812133 812777 813715 814101 817429 817691 818043 819201 819206 819266 819527 823885 823970 825302 826735 826992 827260 827481 828316 828591 ] |
||||||||||||||||||||||||||||||
|
9.40 ms (6.08%) |
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 803814 812777 544113 691148 763824 649776 387868 817429 748879 798793 819266 825302 618069 552247 567454 828591 824605 827260 728525 698220 794332 692021 635737 737943 789396 749537 823970 828316 777949 604616 723831 826735 720666 779130 757698 779897 587947 579752 603368 610124 796000 814101 812133 540934 562544 708855 671901 562453 620410 735186 714576 795197 754871 819201 764388 794181 799823 745889 745883 574223 669328 706439 680853 710294 639073 596986 600855 597429 805018 730785 745899 753757 705418 801926 721677 800916 823885 506564 732491 826992 827481 543995 715468 718240 656296 586011 778519 728653 742271 759024 742665 725620 762131 743926 757651 630672 794747 685259 412616 813715 818043 817691 819206 819527 459735 810151 779875 789348 723878 734621 765838 762063 766210 789611 802915 533162 578690 680852 691997 695367 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск hotel"
]
|
||||||||||||||||||||||||||||||
|
2.69 ms (1.74%) |
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 387868 412616 459735 506564 533162 540934 543995 544113 552247 562453 562544 567454 574223 578690 579752 586011 587947 596986 597429 600855 603368 604616 610124 618069 620410 630672 635737 639073 649776 656296 669328 671901 680852 680853 685259 691148 691997 692021 695367 698220 705418 706439 708855 710294 714576 715468 718240 720666 721677 723831 723878 725620 728525 728653 730785 732491 734621 735186 737943 742271 742665 743926 745883 745889 745899 748879 749537 753757 754871 757651 757698 759024 762063 763824 764388 765838 766210 777949 778519 779130 779875 779897 789348 789396 789611 794181 794332 794747 795197 796000 798793 799823 800916 801926 802915 803814 805018 810151 812133 812777 813715 814101 817429 817691 818043 819201 819206 819266 819527 823885 823970 825302 826735 826992 827260 827481 828316 828591 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hotel"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск hotel"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.96%) |
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.