Query Metrics
7
Database Queries
7
Different statements
185.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.10 ms (86.96%) |
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 350287 382383 384233 385599 392902 393641 397130 417707 430809 433206 437274 437295 439811 441439 443567 455140 455833 455843 457049 474487 476122 484075 489361 493043 494072 495331 496711 497146 499578 512900 513292 513346 517777 523086 527567 528056 528994 529046 529066 531002 532884 533827 547136 552171 559204 560162 566516 569871 579394 579949 580125 582722 588501 596198 598742 601612 613643 625796 634249 644879 645495 648674 650922 655582 659289 660296 660612 671808 690468 691607 696024 697427 711905 712722 714628 717849 719129 720015 720390 721976 722457 724185 728713 736444 738630 741862 744010 744135 744928 745568 749204 754243 761490 765071 766956 769091 771508 773917 779979 784260 788100 788309 789067 794116 798720 808849 814305 815898 817410 817713 819098 819147 819862 821088 821182 821552 821559 821666 822786 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (7.50%) |
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 513292 527557 443567 385599 382383 817410 821666 644879 815898 817713 819098 819147 821088 821552 822786 814305 821182 821559 532884 533827 499578 528056 512900 645495 659289 660612 671808 722457 660296 720015 648674 690468 691607 719129 588501 596198 598742 613643 625796 788100 794116 736444 744010 749204 744928 766956 724185 744135 745568 773917 721976 350287 397130 531002 547136 552171 696024 697427 711905 650922 714628 569871 601612 634249 779979 788309 808849 769091 738630 765071 754243 784260 527567 489361 582722 655582 439811 417707 393641 455833 528994 529066 495331 728713 517777 441439 384233 433206 494072 513346 580125 392902 819862 559204 560162 712722 720390 798720 761490 789067 741862 771508 717849 437274 457049 476122 455140 455843 493043 523086 529046 579949 437295 497146 484075 474487 496711 579394 430809 566516 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.73%) |
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 350287 382383 384233 385599 392902 393641 397130 417707 430809 433206 437274 437295 439811 441439 443567 455140 455833 455843 457049 474487 476122 484075 489361 493043 494072 495331 496711 497146 499578 512900 513292 513346 517777 523086 527567 528056 528994 529046 529066 531002 532884 533827 547136 552171 559204 560162 566516 569871 579394 579949 580125 582722 588501 596198 598742 601612 613643 625796 634249 644879 645495 648674 650922 655582 659289 660296 660612 671808 690468 691607 696024 697427 711905 712722 714628 717849 719129 720015 720390 721976 722457 724185 728713 736444 738630 741862 744010 744135 744928 745568 749204 754243 761490 765071 766956 769091 771508 773917 779979 784260 788100 788309 789067 794116 798720 808849 814305 815898 817410 817713 819098 819147 819862 821088 821182 821552 821559 821666 822786 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen public"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen на улиц"
]
|
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.