Query Metrics
7
Database Queries
7
Different statements
170.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex asian hot"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.22 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 595443 540775 466652 665930 805431 554905 445345 623820 543872 805071 816259 654624 809157 814778 821745 797801 602753 554790 647945 592592 743936 732510 588170 613606 519171 571232 533832 814223 468536 680130 792621 31432 826663 554434 438052 713520 801048 738754 528149 538915 487517 807688 420822 510451 450702 717860 464651 598637 614080 820871 540574 754865 387937 383391 600805 680189 545610 429369 573647 530661 496972 552105 708263 588577 463341 610838 559183 545600 637049 455967 600151 600132 500883 440079 567623 497317 520424 510252 456920 508891 524388 455245 ] |
||||||||||||||||||||||||||||||
| 4 | 2.35 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 31432 383391 387937 420822 429369 438052 440079 445345 450702 455245 455967 456920 463341 464651 466652 468536 487517 496972 497317 500883 508891 510252 510451 519171 520424 524388 528149 530661 533832 538915 540574 540775 543872 545600 545610 552105 554434 554790 554905 559183 567623 571232 573647 588170 588577 592592 595443 598637 600132 600151 600805 602753 610838 613606 614080 623820 637049 647945 654624 665930 680130 680189 708263 713520 717860 732510 738754 743936 754865 792621 797801 801048 805071 805431 807688 809157 814223 814778 816259 820871 821745 826663 ] |
||||||||||||||||||||||||||||||
| 5 | 149.72 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 31432 383391 387937 420822 429369 438052 440079 445345 450702 455245 455967 456920 463341 464651 466652 468536 487517 496972 497317 500883 508891 510252 510451 519171 520424 524388 528149 530661 533832 538915 540574 540775 543872 545600 545610 552105 554434 554790 554905 559183 567623 571232 573647 588170 588577 592592 595443 598637 600132 600151 600805 602753 610838 613606 614080 623820 637049 647945 654624 665930 680130 680189 708263 713520 717860 732510 738754 743936 754865 792621 797801 801048 805071 805431 807688 809157 814223 814778 816259 820871 821745 826663 ] |
||||||||||||||||||||||||||||||
| 6 | 1.87 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс азиатк hot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.88 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс азиатк hot"
]
|
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.