Query Metrics
7
Database Queries
7
Different statements
419.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.09 ms (51.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пошл домашн любительск молодые"
]
|
||||||||||||||||||||||||||||||
|
165.09 ms (39.35%) |
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 428679 450815 451175 460027 468636 469601 469649 481580 484958 485002 485630 486229 488084 490210 494072 500904 503984 505015 506816 508567 509135 512741 513664 514125 515812 515947 516119 518268 520496 521074 521307 521604 521624 521909 522297 524512 525019 530064 530948 543479 547742 548012 553129 553329 560006 561178 562325 562740 564009 564042 568720 568792 569065 569159 570601 572385 572774 572885 575287 575979 582838 584461 586431 589509 590651 591141 593989 594073 595243 597642 598756 599030 599103 601314 601947 602761 603033 603850 603923 603933 605586 605774 605840 606016 606136 608206 608820 609292 609649 610628 613867 615429 615623 616686 617342 618177 618987 619003 619565 619999 620050 620686 620995 621272 621327 621705 622351 623108 624473 625212 627632 636181 639922 644023 653405 658952 662378 663259 675321 684440 ] |
||||||||||||||||||||||||||||||
|
28.18 ms (6.72%) |
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 485002 508567 514125 506816 663259 575979 605774 619565 518268 525019 553129 521074 481580 547742 451175 623108 460027 616686 590651 582838 684440 591141 603850 608820 627632 618987 609292 620050 644023 561178 619999 548012 575287 639922 428679 494072 513664 598756 500904 569159 597642 624473 610628 599030 606136 521909 572774 553329 568792 589509 516119 503984 524512 484958 515947 572385 562325 515812 490210 468636 509135 486229 568720 636181 615623 608206 613867 602761 620995 485630 450815 653405 593989 595243 562740 572885 658952 675321 586431 625212 469601 469649 488084 521307 522297 530064 530948 521624 621705 569065 621327 594073 609649 505015 512741 521604 543479 617342 601314 570601 584461 622351 599103 605586 560006 564009 662378 564042 603923 605840 615429 619003 601947 603033 606016 620686 520496 603933 618177 621272 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (1.04%) |
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 428679 450815 451175 460027 468636 469601 469649 481580 484958 485002 485630 486229 488084 490210 494072 500904 503984 505015 506816 508567 509135 512741 513664 514125 515812 515947 516119 518268 520496 521074 521307 521604 521624 521909 522297 524512 525019 530064 530948 543479 547742 548012 553129 553329 560006 561178 562325 562740 564009 564042 568720 568792 569065 569159 570601 572385 572774 572885 575287 575979 582838 584461 586431 589509 590651 591141 593989 594073 595243 597642 598756 599030 599103 601314 601947 602761 603033 603850 603923 603933 605586 605774 605840 606016 606136 608206 608820 609292 609649 610628 613867 615429 615623 616686 617342 618177 618987 619003 619565 619999 620050 620686 620995 621272 621327 621705 622351 623108 624473 625212 627632 636181 639922 644023 653405 658952 662378 663259 675321 684440 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пошлая домашка молодых"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.39%) |
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.