Query Metrics
7
Database Queries
7
Different statements
131.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.90 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистинг бдсм"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.46 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 561273 530024 467867 546794 597963 486217 533538 536340 512224 530005 531261 545648 648861 555154 634185 613508 641949 418886 467888 503406 527916 470580 543848 420203 420406 469023 453162 478090 492762 530053 536262 552272 639748 522220 443471 420125 532843 534988 531251 528682 532762 544825 647936 631202 533727 423930 491665 421613 518668 443323 416989 515972 536676 530763 530808 530495 541848 634784 448077 451866 530694 532680 538963 532745 543840 648241 599835 512447 518599 516684 391372 467705 534994 543842 648257 597216 613488 715595 497300 533915 530369 600011 427174 533557 523924 665328 527915 409667 ] |
||||||||||||||||||||||||||||||
| 4 | 2.44 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 391372 409667 416989 418886 420125 420203 420406 421613 423930 427174 443323 443471 448077 451866 453162 467705 467867 467888 469023 470580 478090 486217 491665 492762 497300 503406 512224 512447 515972 516684 518599 518668 522220 523924 527915 527916 528682 530005 530024 530053 530369 530495 530694 530763 530808 531251 531261 532680 532745 532762 532843 533538 533557 533727 533915 534988 534994 536262 536340 536676 538963 541848 543840 543842 543848 544825 545648 546794 552272 555154 561273 597216 597963 599835 600011 613488 613508 631202 634185 634784 639748 641949 647936 648241 648257 648861 665328 715595 ] |
||||||||||||||||||||||||||||||
| 5 | 107.63 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 391372 409667 416989 418886 420125 420203 420406 421613 423930 427174 443323 443471 448077 451866 453162 467705 467867 467888 469023 470580 478090 486217 491665 492762 497300 503406 512224 512447 515972 516684 518599 518668 522220 523924 527915 527916 528682 530005 530024 530053 530369 530495 530694 530763 530808 531251 531261 532680 532745 532762 532843 533538 533557 533727 533915 534988 534994 536262 536340 536676 538963 541848 543840 543842 543848 544825 545648 546794 552272 555154 561273 597216 597963 599835 600011 613488 613508 631202 634185 634784 639748 641949 647936 648241 648257 648861 665328 715595 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг бдсм"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.64 ms |
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.