Query Metrics
7
Database Queries
7
Different statements
139.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.91 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro group"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.10 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 615748 625798 629899 644280 790392 473242 541419 541872 544862 559060 559061 562828 541370 541605 562841 546954 562826 581300 663507 670113 671754 674117 649106 571241 572544 576684 592440 592456 593441 624155 643731 598099 603147 605338 541606 522917 659262 562823 576690 576691 541408 541634 541656 541690 581349 541592 546993 550233 580257 622979 541623 541698 577368 576696 566252 662137 541699 559127 541831 541885 541661 541665 542956 541752 541780 565351 541614 541833 541888 541633 541644 541667 541769 574258 576726 541643 541671 576717 541721 542189 580969 541588 541688 603214 470924 542187 562825 609196 541611 556778 ] |
||||||||||||||||||||||||||||||
| 4 | 2.90 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 470924 473242 522917 541370 541408 541419 541588 541592 541605 541606 541611 541614 541623 541633 541634 541643 541644 541656 541661 541665 541667 541671 541688 541690 541698 541699 541721 541752 541769 541780 541831 541833 541872 541885 541888 542187 542189 542956 544862 546954 546993 550233 556778 559060 559061 559127 562823 562825 562826 562828 562841 565351 566252 571241 572544 574258 576684 576690 576691 576696 576717 576726 577368 580257 580969 581300 581349 592440 592456 593441 598099 603147 603214 605338 609196 615748 622979 624155 625798 629899 643731 644280 649106 659262 662137 663507 670113 671754 674117 790392 ] |
||||||||||||||||||||||||||||||
| 5 | 114.45 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 470924 473242 522917 541370 541408 541419 541588 541592 541605 541606 541611 541614 541623 541633 541634 541643 541644 541656 541661 541665 541667 541671 541688 541690 541698 541699 541721 541752 541769 541780 541831 541833 541872 541885 541888 542187 542189 542956 544862 546954 546993 550233 556778 559060 559061 559127 562823 562825 562826 562828 562841 565351 566252 571241 572544 574258 576684 576690 576691 576696 576717 576726 577368 580257 580969 581300 581349 592440 592456 593441 598099 603147 603214 605338 609196 615748 622979 624155 625798 629899 643731 644280 649106 659262 662137 663507 670113 671754 674117 790392 ] |
||||||||||||||||||||||||||||||
| 6 | 1.64 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр group"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.24 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр group"
]
|
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.