Query Metrics
7
Database Queries
7
Different statements
154.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.66 ms (80.13%) |
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 381776 389110 406312 414870 416288 416797 417308 422575 422686 425832 428381 433748 447125 451450 452382 453248 456591 458868 464916 466298 467812 468267 468617 469750 472951 474748 475601 479492 479726 484792 486422 486651 486658 487722 489436 491190 491393 492163 492595 492719 494695 498023 506522 509464 510464 512781 512806 515269 515279 518085 518541 518939 526492 527519 528840 531108 531256 532307 533747 538542 540316 543494 544867 546200 548594 550060 550085 550091 550092 555858 559091 559093 562511 565046 565061 565847 569663 572891 574244 586691 596753 597063 597781 597785 598032 598138 598614 598745 599433 600565 600586 607021 608878 624231 636268 659439 668377 671753 675381 680167 683310 687370 698302 699804 699808 702460 705907 706269 706280 706286 714473 714652 719001 720823 728386 730098 734842 741578 752164 784756 ] |
||||||||||||||||||||||||||||||
|
19.46 ms (12.61%) |
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 734842 730098 741578 624231 702460 705907 706286 784756 475601 389110 428381 433748 414870 456591 467812 451450 515279 486651 487722 515269 484792 474748 680167 494695 533747 548594 546200 598745 492163 381776 406312 458868 469750 466298 479492 498023 518939 532307 512781 540316 506522 512806 531256 527519 464916 479726 559091 559093 565847 687370 698302 706269 719001 659439 683310 714652 720823 668377 671753 699804 714473 550060 550091 597063 597781 598032 598138 600565 600586 608878 586691 597785 599433 596753 598614 607021 752164 728386 699808 706280 468617 417308 472951 452382 468267 486422 486658 510464 491393 491190 492595 492719 574244 636268 509464 416288 425832 416797 422575 422686 453248 447125 489436 518085 518541 531108 538542 528840 526492 555858 562511 565046 543494 550085 550092 565061 569663 572891 544867 675381 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.15%) |
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 381776 389110 406312 414870 416288 416797 417308 422575 422686 425832 428381 433748 447125 451450 452382 453248 456591 458868 464916 466298 467812 468267 468617 469750 472951 474748 475601 479492 479726 484792 486422 486651 486658 487722 489436 491190 491393 492163 492595 492719 494695 498023 506522 509464 510464 512781 512806 515269 515279 518085 518541 518939 526492 527519 528840 531108 531256 532307 533747 538542 540316 543494 544867 546200 548594 550060 550085 550091 550092 555858 559091 559093 562511 565046 565061 565847 569663 572891 574244 586691 596753 597063 597781 597785 598032 598138 598614 598745 599433 600565 600586 607021 608878 624231 636268 659439 668377 671753 675381 680167 683310 687370 698302 699804 699808 702460 705907 706269 706280 706286 714473 714652 719001 720823 728386 730098 734842 741578 752164 784756 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen uniform"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen униформ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen униформ"
]
|
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.