Query Metrics
7
Database Queries
7
Different statements
579.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
338.14 ms (58.33%) |
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 282218 282430 358566 387014 396673 410090 410937 411169 414778 415223 417408 418423 419655 420331 421890 424646 436437 439320 440619 443465 444180 444260 446740 447337 447350 448562 452095 452677 459487 461442 462515 463938 470254 470782 474642 479836 480803 483558 488698 490085 490201 491704 492382 492598 492773 493951 496028 501797 502764 502844 505023 507785 511721 511735 512269 513322 513696 517554 519646 521999 522000 522789 522791 522792 523260 524070 528788 528921 533738 536675 536676 542864 544199 546051 548785 551199 551579 552480 552656 558130 558131 558844 559673 561692 563053 574490 574599 575079 575104 575461 575494 575522 575784 575799 576025 576036 576052 576061 576075 576083 576356 576358 576364 576403 590398 595867 595875 597260 597575 597961 598806 600248 602653 607387 636026 651841 670996 718710 721795 766302 ] |
||||||||||||||||||||||||||||||
|
206.61 ms (35.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teen young"
]
|
||||||||||||||||||||||||||||||
|
25.74 ms (4.44%) |
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 670996 548785 559673 574490 576083 597260 597961 595867 600248 766302 718710 721795 419655 424646 396673 443465 470782 282430 358566 459487 461442 444180 521999 483558 491704 502844 488698 502764 512269 522789 462515 576061 551199 576052 575461 575494 448562 452095 447337 493951 496028 492598 536676 523260 558130 542864 421890 490201 415223 420331 597575 513322 513696 544199 552480 563053 574599 575522 575799 576403 546051 552656 575079 576356 576358 558844 561692 575104 575784 576036 651841 576025 590398 636026 602653 411169 480803 282218 463938 387014 414778 417408 436437 439320 447350 410090 410937 444260 479836 522000 522792 528921 490085 492382 511721 522791 492773 511735 524070 519646 533738 470254 501797 607387 528788 595875 598806 551579 440619 418423 452677 474642 505023 507785 446740 558131 536675 517554 576364 576075 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (0.61%) |
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 282218 282430 358566 387014 396673 410090 410937 411169 414778 415223 417408 418423 419655 420331 421890 424646 436437 439320 440619 443465 444180 444260 446740 447337 447350 448562 452095 452677 459487 461442 462515 463938 470254 470782 474642 479836 480803 483558 488698 490085 490201 491704 492382 492598 492773 493951 496028 501797 502764 502844 505023 507785 511721 511735 512269 513322 513696 517554 519646 521999 522000 522789 522791 522792 523260 524070 528788 528921 533738 536675 536676 542864 544199 546051 548785 551199 551579 552480 552656 558130 558131 558844 559673 561692 563053 574490 574599 575079 575104 575461 575494 575522 575784 575799 576025 576036 576052 576061 576075 576083 576356 576358 576364 576403 590398 595867 595875 597260 597575 597961 598806 600248 602653 607387 636026 651841 670996 718710 721795 766302 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen young"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen young"
]
|
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.