Query Metrics
7
Database Queries
7
Different statements
400.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.91 ms (51.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
167.58 ms (41.89%) |
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 6602 24255 33821 73947 117513 154112 172068 197892 263917 382508 382556 385252 385481 385709 388113 388503 389912 391106 395909 396826 400497 400860 405682 417875 420474 443111 450271 453258 459215 459257 459441 467021 472852 473613 485740 486465 488224 494642 498849 500576 503976 503985 506079 509367 509372 510573 512739 517281 520359 521407 523170 523599 532138 537006 543306 545221 546272 546631 546635 549534 549717 550367 551110 554985 557233 557327 560988 562346 563067 564206 565651 567418 568712 569235 571138 577089 579338 579811 584639 590977 590980 590984 590991 591016 591039 591059 591154 591218 591452 591468 591508 591536 591550 591566 593821 598254 599720 605803 606042 609197 610112 615979 621687 636249 645939 653252 660457 667095 696772 696958 697605 729748 738300 746097 757303 778600 779899 803140 805213 812358 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (4.36%) |
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 590980 591508 605803 486465 488224 494642 506079 512739 520359 537006 503985 543306 549717 579811 567418 610112 591468 591550 73947 385252 382556 385709 263917 450271 591016 498849 443111 197892 420474 778600 803140 812358 6602 523599 517281 485740 579338 545221 563067 564206 577089 557233 565651 569235 667095 550367 598254 590984 590991 591536 590977 591154 606042 172068 391106 417875 503976 521407 562346 609197 400497 33821 396826 459215 395909 509372 560988 382508 568712 546635 696958 805213 729748 746097 738300 757303 453258 385481 154112 24255 388113 779899 697605 117513 551110 653252 615979 523170 500576 510573 532138 554985 557327 584639 549534 571138 546631 645939 660457 599720 591059 591566 621687 591452 636249 591218 388503 459441 467021 472852 696772 459257 509367 591039 400860 473613 389912 405682 546272 593821 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.70%) |
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 6602 24255 33821 73947 117513 154112 172068 197892 263917 382508 382556 385252 385481 385709 388113 388503 389912 391106 395909 396826 400497 400860 405682 417875 420474 443111 450271 453258 459215 459257 459441 467021 472852 473613 485740 486465 488224 494642 498849 500576 503976 503985 506079 509367 509372 510573 512739 517281 520359 521407 523170 523599 532138 537006 543306 545221 546272 546631 546635 549534 549717 550367 551110 554985 557233 557327 560988 562346 563067 564206 565651 567418 568712 569235 571138 577089 579338 579811 584639 590977 590980 590984 590991 591016 591039 591059 591154 591218 591452 591468 591508 591536 591550 591566 593821 598254 599720 605803 606042 609197 610112 615979 621687 636249 645939 653252 660457 667095 696772 696958 697605 729748 738300 746097 757303 778600 779899 803140 805213 812358 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в кухни"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в кухн"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.34%) |
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.