Query Metrics
7
Database Queries
7
Different statements
190.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.42 ms (84.54%) |
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 330478 387026 405544 414038 420410 422192 424210 426010 429574 430837 439552 439638 443752 444116 445323 450786 451473 453139 453688 454134 456208 457453 457750 457782 458924 460287 460340 460804 460912 464379 464550 464888 465546 466153 466912 467279 467405 467449 467496 470016 470043 470201 470214 470236 470389 470765 470953 473400 474065 474113 474405 474787 474795 475898 476028 476285 476586 478373 480676 483732 484369 484460 484530 485131 488362 488391 490248 490831 491121 491251 491411 492062 492234 492610 492689 493190 495374 495562 495878 496863 499551 499857 502840 503154 503496 509286 511536 513522 513629 514372 514748 515912 516466 516811 518201 518264 518576 518842 519140 528587 529512 538007 546940 554235 555040 555716 555967 556851 557185 558051 558172 558177 558417 559877 560400 563063 566664 579614 593384 599451 ] |
||||||||||||||||||||||||||||||
|
20.23 ms (10.60%) |
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 467279 467496 474795 387026 439552 460912 464379 470236 474113 480676 430837 456208 457453 457782 464550 467449 470016 405544 443752 460804 466912 513522 516466 516811 518201 529512 484369 492062 496863 499551 511536 513629 515912 528587 483732 490248 492610 495878 499857 514372 538007 330478 444116 426010 414038 485131 490831 491121 493190 450786 454134 458924 470214 470389 503496 474065 474405 491251 491411 546940 554235 555967 558172 558177 559877 563063 566664 555040 556851 557185 558051 579614 555716 558417 560400 593384 599451 424210 453139 453688 478373 460287 465546 466153 470201 470765 473400 475898 429574 457750 474787 420410 439638 445323 451473 467405 470043 470953 476028 476285 476586 422192 460340 464888 509286 514748 518264 518842 519140 488362 492234 492689 495374 502840 503154 518576 484460 484530 488391 495562 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.41%) |
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 330478 387026 405544 414038 420410 422192 424210 426010 429574 430837 439552 439638 443752 444116 445323 450786 451473 453139 453688 454134 456208 457453 457750 457782 458924 460287 460340 460804 460912 464379 464550 464888 465546 466153 466912 467279 467405 467449 467496 470016 470043 470201 470214 470236 470389 470765 470953 473400 474065 474113 474405 474787 474795 475898 476028 476285 476586 478373 480676 483732 484369 484460 484530 485131 488362 488391 490248 490831 491121 491251 491411 492062 492234 492610 492689 493190 495374 495562 495878 496863 499551 499857 502840 503154 503496 509286 511536 513522 513629 514372 514748 515912 516466 516811 518201 518264 518576 518842 519140 528587 529512 538007 546940 554235 555040 555716 555967 556851 557185 558051 558172 558177 558417 559877 560400 563063 566664 579614 593384 599451 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"возраст"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"возраст"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.69%) |
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.