Query Metrics
7
Database Queries
7
Different statements
171.15 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.84 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.60 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife morning sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.22 ms |
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 523731 522783 501708 524099 560512 707740 610712 499740 493555 448440 449715 501709 486917 549688 580818 439675 484484 606567 418394 535164 535429 568454 623472 492027 524581 524189 488023 520248 527925 529776 580807 625521 501178 457781 547900 516298 489823 482570 467993 675444 529168 396772 488698 488073 486884 520201 457566 458986 566370 524087 513500 623813 575189 552984 475111 621122 556494 429459 571844 508419 515769 552987 569544 525267 445799 516119 515579 613360 520801 521414 526775 568822 443040 549159 472588 501724 568848 564687 543346 550841 623260 486569 622805 527087 571333 584461 ] |
||||||||||||||||||||||||||||||
| 4 | 2.61 ms |
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 396772 418394 429459 439675 443040 445799 448440 449715 457566 457781 458986 467993 472588 475111 482570 484484 486569 486884 486917 488023 488073 488698 489823 492027 493555 499740 501178 501708 501709 501724 508419 513500 515579 515769 516119 516298 520201 520248 520801 521414 522783 523731 524087 524099 524189 524581 525267 526775 527087 527925 529168 529776 535164 535429 543346 547900 549159 549688 550841 552984 552987 556494 560512 564687 566370 568454 568822 568848 569544 571333 571844 575189 580807 580818 584461 606567 610712 613360 621122 622805 623260 623472 623813 625521 675444 707740 ] |
||||||||||||||||||||||||||||||
| 5 | 145.11 ms |
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 396772 418394 429459 439675 443040 445799 448440 449715 457566 457781 458986 467993 472588 475111 482570 484484 486569 486884 486917 488023 488073 488698 489823 492027 493555 499740 501178 501708 501709 501724 508419 513500 515579 515769 516119 516298 520201 520248 520801 521414 522783 523731 524087 524099 524189 524581 525267 526775 527087 527925 529168 529776 535164 535429 543346 547900 549159 549688 550841 552984 552987 556494 560512 564687 566370 568454 568822 568848 569544 571333 571844 575189 580807 580818 584461 606567 610712 613360 621122 622805 623260 623472 623813 625521 675444 707740 ] |
||||||||||||||||||||||||||||||
| 6 | 2.09 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен morning секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.68 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен morning секс"
]
|
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.