Query Metrics
7
Database Queries
7
Different statements
182.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.42 ms (86.81%) |
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 11320 114557 183074 192968 341546 383250 387221 387576 389197 391202 393460 393765 394227 395539 397699 398878 401820 401840 402207 402664 402672 403979 405324 405360 406711 407290 407324 409163 411030 411947 413240 418725 425684 444127 446314 450189 456952 459086 462525 466382 466640 467758 469084 470607 470608 471526 475695 481099 482147 484802 486161 489241 493488 494277 506552 511384 511864 515236 524745 527231 543971 543982 548727 551186 551269 555664 556063 559716 559841 564894 566997 570418 574079 575059 575765 575787 578363 578380 581001 581145 592307 607376 607403 611307 615883 618882 630638 633022 635584 650793 665921 666828 667875 667878 668542 693073 714199 716856 720188 722903 732055 734428 737332 741196 748251 765841 775834 783109 784247 789711 790213 796250 800240 800610 802112 802343 803454 809301 809439 812796 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (8.09%) |
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 469084 475695 481099 486161 493488 466382 471526 450189 456952 470607 489241 494277 506552 511384 515236 511864 527231 524745 484802 543982 551186 555664 556063 564894 574079 578363 578380 559716 575059 581145 543971 570418 575765 575787 581001 667878 716856 665921 666828 667875 668542 693073 714199 650793 722903 548727 551269 559841 566997 611307 607376 592307 615883 630638 618882 775834 784247 809439 812796 734428 748251 765841 783109 796250 800240 802112 802343 741196 732055 737332 607403 633022 635584 720188 789711 790213 800610 803454 809301 387221 394227 401840 407290 407324 411947 418725 425684 470608 482147 192968 397699 405324 405360 459086 462525 341546 391202 393460 393765 398878 402207 402672 444127 446314 466640 467758 11320 114557 183074 383250 387576 389197 395539 401820 402664 403979 406711 409163 411030 413240 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.62%) |
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 11320 114557 183074 192968 341546 383250 387221 387576 389197 391202 393460 393765 394227 395539 397699 398878 401820 401840 402207 402664 402672 403979 405324 405360 406711 407290 407324 409163 411030 411947 413240 418725 425684 444127 446314 450189 456952 459086 462525 466382 466640 467758 469084 470607 470608 471526 475695 481099 482147 484802 486161 489241 493488 494277 506552 511384 511864 515236 524745 527231 543971 543982 548727 551186 551269 555664 556063 559716 559841 564894 566997 570418 574079 575059 575765 575787 578363 578380 581001 581145 592307 607376 607403 611307 615883 618882 630638 633022 635584 650793 665921 666828 667875 667878 668542 693073 714199 716856 720188 722903 732055 734428 737332 741196 748251 765841 775834 783109 784247 789711 790213 796250 800240 800610 802112 802343 803454 809301 809439 812796 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.73%) |
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.