Query Metrics
7
Database Queries
7
Different statements
190.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.73 ms (87.62%) |
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 330764 386212 392872 396374 418078 429298 440700 443640 444412 445616 451584 451606 453666 455840 456798 460531 464204 467172 470224 480002 482401 485484 491565 497661 504574 504790 505433 512932 521912 523944 523946 527535 551567 551640 551949 557895 558210 560384 564071 565343 565350 565372 565375 565431 565436 565457 566905 570620 571865 572108 572110 572111 572382 572417 572796 572863 573420 573661 575450 580050 586561 589800 594772 594824 598223 599758 605246 607084 607092 607303 607316 607319 612023 623439 633064 649845 668281 673141 690406 690410 691219 693164 698880 698994 705770 706934 709521 716149 720824 721062 723122 725864 727015 734105 734425 735113 735848 735851 736058 737350 739222 740301 740821 751778 759469 761140 765890 771612 772556 774020 777868 786403 817237 818746 820949 821165 821661 822741 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (7.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 599432 586561 698880 721062 467172 396374 392872 505433 504574 551567 551949 598223 460531 418078 470224 527535 565375 566905 572108 690406 691219 571865 594824 523944 443640 444412 482401 453666 551640 570620 565372 480002 440700 521912 497661 429298 821661 817237 818746 822741 820949 821165 523946 560384 572110 573420 575450 565431 572863 557895 572111 572382 673141 693164 705770 709521 668281 716149 720824 572796 580050 607092 607319 633064 607084 594772 605246 777868 786403 735113 739222 759469 774020 734105 735848 735851 740301 772556 751778 725864 727015 736058 737350 740821 765890 771612 607316 612023 623439 386212 690410 491565 464204 456798 558210 589800 455840 734425 761140 451584 451606 485484 504790 565457 698994 565343 565350 572417 723122 445616 527557 565436 649845 607303 599758 706934 512932 330764 564071 573661 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.28%) |
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 330764 386212 392872 396374 418078 429298 440700 443640 444412 445616 451584 451606 453666 455840 456798 460531 464204 467172 470224 480002 482401 485484 491565 497661 504574 504790 505433 512932 521912 523944 523946 527535 551567 551640 551949 557895 558210 560384 564071 565343 565350 565372 565375 565431 565436 565457 566905 570620 571865 572108 572110 572111 572382 572417 572796 572863 573420 573661 575450 580050 586561 589800 594772 594824 598223 599758 605246 607084 607092 607303 607316 607319 612023 623439 633064 649845 668281 673141 690406 690410 691219 693164 698880 698994 705770 706934 709521 716149 720824 721062 723122 725864 727015 734105 734425 735113 735848 735851 736058 737350 739222 740301 740821 751778 759469 761140 765890 771612 772556 774020 777868 786403 817237 818746 820949 821165 821661 822741 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pickup public"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.