Query Metrics
7
Database Queries
7
Different statements
152.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.29 ms (78.44%) |
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 392721 394351 396813 397131 398623 398986 399017 401973 403285 408833 410292 410655 414956 415894 416943 417471 418009 418513 420359 422231 422256 422376 422421 425301 425565 426376 426715 427045 428093 428303 429060 429117 429259 429546 429707 435656 437918 438486 441936 443417 444193 444232 444614 445671 445855 448011 449003 451717 455113 456677 457134 458036 458408 458628 458663 459282 459323 459431 460764 461163 462102 463321 466320 471333 473095 473687 473751 475054 479011 484132 488489 489437 492086 492347 492663 493484 494890 504711 506489 507851 514976 517295 527165 527545 527628 532628 536720 536809 537790 537822 539707 603467 603481 622427 700737 712293 723538 727921 735982 739409 744507 747942 749730 750084 751361 755576 757003 758012 759223 761359 761873 771572 780485 792048 794354 805650 807268 811951 812958 ] |
||||||||||||||||||||||||||||||
|
21.65 ms (14.24%) |
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 739409 744507 747942 749730 755576 758012 761359 762399 771572 727921 735982 750084 751361 757003 759223 761873 603467 603481 622427 700737 712293 780485 792048 794354 805650 807268 811951 812958 408833 410655 422376 429259 435656 451717 473687 475054 416943 425565 429546 449003 396813 398623 414956 466320 392721 403285 410292 415894 418513 426715 438486 455113 458036 458663 460764 461163 473095 420359 527545 537790 484132 506489 492663 494890 517295 527628 488489 489437 493484 418009 479011 394351 397131 398986 399017 401973 422256 429060 429117 444193 444232 444614 425301 426376 427045 437918 441936 443417 422421 428303 429707 417471 428093 422231 723538 445855 457134 459282 459431 492086 492347 445671 448011 456677 462102 473751 458408 458628 459323 463321 471333 504711 532628 536809 507851 514976 527165 536720 537822 539707 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лето"
]
|
||||||||||||||||||||||||||||||
|
2.71 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 392721 394351 396813 397131 398623 398986 399017 401973 403285 408833 410292 410655 414956 415894 416943 417471 418009 418513 420359 422231 422256 422376 422421 425301 425565 426376 426715 427045 428093 428303 429060 429117 429259 429546 429707 435656 437918 438486 441936 443417 444193 444232 444614 445671 445855 448011 449003 451717 455113 456677 457134 458036 458408 458628 458663 459282 459323 459431 460764 461163 462102 463321 466320 471333 473095 473687 473751 475054 479011 484132 488489 489437 492086 492347 492663 493484 494890 504711 506489 507851 514976 517295 527165 527545 527628 532628 536720 536809 537790 537822 539707 603467 603481 622427 700737 712293 723538 727921 735982 739409 744507 747942 749730 750084 751361 755576 757003 758012 759223 761359 761873 771572 780485 792048 794354 805650 807268 811951 812958 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лет"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.