Query Metrics
7
Database Queries
7
Different statements
165.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.25 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sleeping anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.15 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 485271 489471 609252 421850 439787 493181 624127 552812 722894 609681 798680 389098 581098 445201 489281 558877 439627 439691 563444 441005 446851 421837 439808 490097 491683 507817 526008 492196 487677 796507 620100 652910 437632 428970 440614 439742 439761 513324 439672 468072 515986 622965 571956 470159 466272 625235 439730 759641 652289 798684 470196 439713 605952 427186 421323 715898 513680 422155 422205 526775 494036 560441 424995 485709 470472 536402 444890 431740 469019 622817 612519 420635 477442 514780 484739 439819 625185 437204 597580 502755 521832 731279 466213 528803 526730 620124 591235 559950 ] |
||||||||||||||||||||||||||||||
| 4 | 2.60 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 389098 420635 421323 421837 421850 422155 422205 424995 427186 428970 431740 437204 437632 439627 439672 439691 439713 439730 439742 439761 439787 439808 439819 440614 441005 444890 445201 446851 466213 466272 468072 469019 470159 470196 470472 477442 484739 485271 485709 487677 489281 489471 490097 491683 492196 493181 494036 502755 507817 513324 513680 514780 515986 521832 526008 526730 526775 528803 536402 552812 558877 559950 560441 563444 571956 581098 591235 597580 605952 609252 609681 612519 620100 620124 622817 622965 624127 625185 625235 652289 652910 715898 722894 731279 759641 796507 798680 798684 ] |
||||||||||||||||||||||||||||||
| 5 | 136.89 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 389098 420635 421323 421837 421850 422155 422205 424995 427186 428970 431740 437204 437632 439627 439672 439691 439713 439730 439742 439761 439787 439808 439819 440614 441005 444890 445201 446851 466213 466272 468072 469019 470159 470196 470472 477442 484739 485271 485709 487677 489281 489471 490097 491683 492196 493181 494036 502755 507817 513324 513680 514780 515986 521832 526008 526730 526775 528803 536402 552812 558877 559950 560441 563444 571956 581098 591235 597580 605952 609252 609681 612519 620100 620124 622817 622965 624127 625185 625235 652289 652910 715898 722894 731279 759641 796507 798680 798684 ] |
||||||||||||||||||||||||||||||
| 6 | 1.95 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск спящ анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.62 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.