Query Metrics
7
Database Queries
7
Different statements
147.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.13 ms (80.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 386211 386954 395394 395522 395894 405116 418159 420232 429232 430416 434289 444264 445184 445607 451024 451581 454457 455181 455836 456987 461046 461903 466671 466746 466960 467066 467130 467743 469715 472332 473168 475223 475952 476478 480705 485539 485733 486494 487133 487168 495302 497166 497867 500469 502808 504170 505005 506015 509184 509274 510086 512877 514296 519665 523666 523999 525380 525650 525699 526337 527074 528416 528998 529033 534958 535616 539114 547755 549222 552535 554563 556401 559934 560179 560877 562311 562804 563333 564112 568602 569870 572265 572385 573367 574443 574817 575131 580966 583999 586485 590573 591749 594970 598186 601559 601580 607146 607227 608681 621648 625663 625945 626911 637608 649912 650228 652480 663261 663789 668005 668380 682136 691112 704387 709855 734846 737456 760600 784907 812249 ] |
||||||||||||||||||||||||||||||
|
18.88 ms (12.79%) |
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 395522 386954 418159 444264 455181 512877 539114 569870 451581 467130 480705 504170 509184 506015 509274 523666 485539 734846 395394 445184 466960 559934 590573 405116 574817 560179 625945 454457 456987 510086 386211 525650 451024 486494 514296 466671 562804 621648 626911 495302 650228 572265 455836 528998 549222 583999 580966 469715 497166 625663 487133 563333 547755 608681 682136 568602 574443 461046 591749 525699 663261 668380 476478 487168 523999 526337 573367 594970 473168 472332 519665 461903 429232 552535 668005 556401 784907 601580 737456 709855 528416 505005 663789 564112 475952 430416 445607 598186 434289 500469 575131 586485 607146 601559 467066 467743 420232 395894 485733 535616 554563 475223 525380 527074 652480 704387 691112 760600 812249 637608 649912 572385 562311 466746 560877 529033 607227 497867 502808 534958 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.85%) |
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 386211 386954 395394 395522 395894 405116 418159 420232 429232 430416 434289 444264 445184 445607 451024 451581 454457 455181 455836 456987 461046 461903 466671 466746 466960 467066 467130 467743 469715 472332 473168 475223 475952 476478 480705 485539 485733 486494 487133 487168 495302 497166 497867 500469 502808 504170 505005 506015 509184 509274 510086 512877 514296 519665 523666 523999 525380 525650 525699 526337 527074 528416 528998 529033 534958 535616 539114 547755 549222 552535 554563 556401 559934 560179 560877 562311 562804 563333 564112 568602 569870 572265 572385 573367 574443 574817 575131 580966 583999 586485 590573 591749 594970 598186 601559 601580 607146 607227 608681 621648 625663 625945 626911 637608 649912 650228 652480 663261 663789 668005 668380 682136 691112 704387 709855 734846 737456 760600 784907 812249 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в парк"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в парк природ"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.94%) |
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.