Query Metrics
7
Database Queries
7
Different statements
159.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.49 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom hard"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.56 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 814736 825762 474145 445936 515499 669218 590724 602016 588201 617402 791209 766262 412881 406780 506438 646111 744902 513076 527076 697996 724506 472447 461368 479782 515952 510858 504825 520151 513158 523977 565246 544835 565359 619396 792612 445909 446940 428406 448325 477114 518486 487067 566355 722984 786924 745214 750110 659272 656009 426532 814175 485232 560330 683438 574869 640802 623574 584720 395291 445681 496518 521204 537670 605418 600995 486583 522759 536691 557570 465234 796207 608534 739535 524142 422062 409887 572128 602359 429287 735778 513435 443368 471620 426499 534645 467949 790234 ] |
||||||||||||||||||||||||||||||
| 4 | 2.53 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 395291 406780 409887 412881 422062 426499 426532 428406 429287 443368 445681 445909 445936 446940 448325 461368 465234 467949 471620 472447 474145 477114 479782 485232 486583 487067 496518 504825 506438 510858 513076 513158 513435 515499 515952 518486 520151 521204 522759 523977 524142 527076 534645 536691 537670 544835 557570 560330 565246 565359 566355 572128 574869 584720 588201 590724 600995 602016 602359 605418 608534 617402 619396 623574 640802 646111 656009 659272 669218 683438 697996 722984 724506 735778 739535 744902 745214 750110 766262 786924 790234 791209 792612 796207 814175 814736 825762 ] |
||||||||||||||||||||||||||||||
| 5 | 136.32 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 395291 406780 409887 412881 422062 426499 426532 428406 429287 443368 445681 445909 445936 446940 448325 461368 465234 467949 471620 472447 474145 477114 479782 485232 486583 487067 496518 504825 506438 510858 513076 513158 513435 515499 515952 518486 520151 521204 522759 523977 524142 527076 534645 536691 537670 544835 557570 560330 565246 565359 566355 572128 574869 584720 588201 590724 600995 602016 602359 605418 608534 617402 619396 623574 640802 646111 656009 659272 669218 683438 697996 722984 724506 735778 739535 744902 745214 750110 766262 786924 790234 791209 792612 796207 814175 814736 825762 ] |
||||||||||||||||||||||||||||||
| 6 | 1.74 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван hard"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.31 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван hard"
]
|
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.