Query Metrics
7
Database Queries
7
Different statements
192.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.45 ms (82.69%) |
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 32485 61498 360205 364718 386316 388436 400226 404035 413898 417708 417716 420400 420426 421144 422488 425341 426389 427964 429200 429261 429264 438415 440736 445993 450858 451606 456261 457537 458584 458695 458830 459326 460098 460395 461301 463031 470224 470265 472331 474911 474972 475574 475867 476849 478106 478261 480106 480673 482882 490059 490264 494235 497172 499706 500277 503041 503995 504548 504833 506571 506868 509544 512884 524681 527486 527529 527535 527561 529018 529058 529901 529918 535387 535897 539917 542734 544299 545352 546858 549101 551188 551227 551248 555440 555723 555869 560014 560749 565398 570028 570356 570436 571518 571586 571598 572427 573100 573948 575760 578133 579456 580327 580864 586381 606095 614377 615082 666772 668025 680499 705640 709452 741368 793992 818686 820542 821065 821232 822815 825580 ] |
||||||||||||||||||||||||||||||
|
23.52 ms (12.20%) |
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 426389 822815 820542 818686 821065 506571 503041 527486 529918 570028 570436 570356 571598 579456 668025 615082 705640 480673 458584 461301 474911 499706 500277 494235 509544 535387 457537 490059 573948 542734 580864 476849 470265 450858 527561 404035 459326 458695 504548 527535 529901 545352 680499 586381 793992 460098 474972 421144 425341 422488 440736 386316 360205 364718 61498 32485 429200 825580 478106 503995 504833 460395 544299 575760 555440 560014 549101 741368 429264 445993 475574 506868 512884 482882 529058 614377 535897 546858 555723 560749 427964 524681 388436 400226 420400 417716 420426 429261 413898 417708 438415 821232 456261 463031 490264 451606 458830 470224 472331 478261 497172 529018 527529 539917 475867 480106 571586 572427 551227 551248 565398 580327 709452 666772 551188 555869 571518 573100 578133 606095 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.40%) |
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 32485 61498 360205 364718 386316 388436 400226 404035 413898 417708 417716 420400 420426 421144 422488 425341 426389 427964 429200 429261 429264 438415 440736 445993 450858 451606 456261 457537 458584 458695 458830 459326 460098 460395 461301 463031 470224 470265 472331 474911 474972 475574 475867 476849 478106 478261 480106 480673 482882 490059 490264 494235 497172 499706 500277 503041 503995 504548 504833 506571 506868 509544 512884 524681 527486 527529 527535 527561 529018 529058 529901 529918 535387 535897 539917 542734 544299 545352 546858 549101 551188 551227 551248 555440 555723 555869 560014 560749 565398 570028 570356 570436 571518 571586 571598 572427 573100 573948 575760 578133 579456 580327 580864 586381 606095 614377 615082 666772 668025 680499 705640 709452 741368 793992 818686 820542 821065 821232 822815 825580 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in park"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парк природ"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
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.