Query Metrics
7
Database Queries
7
Different statements
222.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"голышом дома"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.00 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 506228 516480 520468 523571 454122 453366 517780 472698 680709 562285 497905 574657 548873 541969 548265 579207 482293 453213 424518 447008 490384 515464 525992 531581 476218 461870 448901 561368 419443 416616 466995 452933 454735 425868 458937 425724 493258 525204 506134 456516 470161 402784 452482 438365 454736 493193 516336 457444 471102 477660 466435 473750 411401 508195 524687 492926 512934 517207 410808 416751 476420 587267 381871 381933 497117 413100 601748 453368 454731 595891 526948 497409 499014 543061 592988 600024 425786 592521 599359 476604 605105 591139 530232 527967 ] |
||||||||||||||||||||||||||||||
| 4 | 2.54 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 381871 381933 402784 410808 411401 413100 416616 416751 419443 424518 425724 425786 425868 438365 447008 448901 452482 452933 453213 453366 453368 454122 454731 454735 454736 456516 457444 458937 461870 466435 466995 470161 471102 472698 473750 476218 476420 476604 477660 482293 490384 492926 493193 493258 497117 497409 497905 499014 506134 506228 508195 512934 515464 516336 516480 517207 517780 520468 523571 524687 525204 525992 526948 527967 530232 531581 541969 543061 548265 548873 561368 562285 574657 579207 587267 591139 592521 592988 595891 599359 600024 601748 605105 680709 ] |
||||||||||||||||||||||||||||||
| 5 | 199.87 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 381871 381933 402784 410808 411401 413100 416616 416751 419443 424518 425724 425786 425868 438365 447008 448901 452482 452933 453213 453366 453368 454122 454731 454735 454736 456516 457444 458937 461870 466435 466995 470161 471102 472698 473750 476218 476420 476604 477660 482293 490384 492926 493193 493258 497117 497409 497905 499014 506134 506228 508195 512934 515464 516336 516480 517207 517780 520468 523571 524687 525204 525992 526948 527967 530232 531581 541969 543061 548265 548873 561368 562285 574657 579207 587267 591139 592521 592988 595891 599359 600024 601748 605105 680709 ] |
||||||||||||||||||||||||||||||
| 6 | 1.60 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голыш домашн любительск"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.53 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.