Query Metrics
7
Database Queries
7
Different statements
133.00 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.98 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"while"
]
|
||||||||||||||||||||||||||||||
| 3 | 10.79 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 766539 769338 728703 733219 739700 741939 742771 742842 744301 749783 750864 751967 752188 753617 759313 759346 764193 765537 767771 769433 730356 731182 731212 738541 742102 742542 748385 749760 750014 750026 751497 756354 758172 761072 761511 761522 763879 768096 768858 770455 772896 602023 607981 608664 615256 617768 620486 627937 632244 633591 635030 635404 638157 644509 699156 701263 708329 711384 712620 715694 715838 722094 776352 776769 776999 777182 778515 778700 779177 779265 784291 785900 787472 789374 791174 792768 795482 797123 797297 798769 800388 800938 801183 801713 803702 804978 810075 810182 810943 812267 812468 384514 456203 397635 233443 386325 285831 383646 250587 400521 401158 405744 441550 441978 444389 415036 817749 818832 821800 824760 816147 816610 816693 816765 817802 819868 821410 821819 823413 824703 ] |
||||||||||||||||||||||||||||||
| 4 | 2.41 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 233443 250587 285831 383646 384514 386325 397635 400521 401158 405744 415036 441550 441978 444389 456203 602023 607981 608664 615256 617768 620486 627937 632244 633591 635030 635404 638157 644509 699156 701263 708329 711384 712620 715694 715838 722094 728703 730356 731182 731212 733219 738541 739700 741939 742102 742542 742771 742842 744301 748385 749760 749783 750014 750026 750864 751497 751967 752188 753617 756354 758172 759313 759346 761072 761511 761522 763879 764193 765537 766539 767771 768096 768858 769338 769433 770455 772896 776352 776769 776999 778515 778700 779177 779265 784291 785900 787472 789374 791174 792768 795482 797123 797297 798769 800388 800938 801183 801713 803702 804978 810075 810182 810943 812267 812468 816147 816610 816693 816765 817749 817802 818832 819868 821410 821800 821819 823413 824703 824760 ] |
||||||||||||||||||||||||||||||
| 5 | 113.09 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 233443 250587 285831 383646 384514 386325 397635 400521 401158 405744 415036 441550 441978 444389 456203 602023 607981 608664 615256 617768 620486 627937 632244 633591 635030 635404 638157 644509 699156 701263 708329 711384 712620 715694 715838 722094 728703 730356 731182 731212 733219 738541 739700 741939 742102 742542 742771 742842 744301 748385 749760 749783 750014 750026 750864 751497 751967 752188 753617 756354 758172 759313 759346 761072 761511 761522 763879 764193 765537 766539 767771 768096 768858 769338 769433 770455 772896 776352 776769 776999 778515 778700 779177 779265 784291 785900 787472 789374 791174 792768 795482 797123 797297 798769 800388 800938 801183 801713 803702 804978 810075 810182 810943 812267 812468 816147 816610 816693 816765 817749 817802 818832 819868 821410 821800 821819 823413 824703 824760 ] |
||||||||||||||||||||||||||||||
| 6 | 1.72 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"while"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.47 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"while"
]
|
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.