Query Metrics
7
Database Queries
7
Different statements
242.19 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8.49 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 9.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian lick hairy"
]
|
||||||||||||||||||||||||||||||
| 3 | 64.07 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 484681 543343 465355 470483 466138 474016 424421 462319 463772 443982 466118 512516 528258 484566 484643 486193 512851 520011 484472 485691 485777 506081 484377 500694 525691 462117 485600 443831 466069 486344 488734 485700 389117 609196 617641 599844 486277 502868 555031 486897 587098 443737 466081 466176 424660 466103 471046 507423 524029 484595 439623 474024 485589 519433 610695 770312 484592 519371 470596 466112 524073 564429 466145 528252 485703 524882 800535 493022 454065 484739 620165 470295 466180 606012 605586 555055 562423 598806 484706 462535 586573 516091 519727 475891 543579 490265 611477 ] |
||||||||||||||||||||||||||||||
| 4 | 13.14 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 389117 424421 424660 439623 443737 443831 443982 454065 462117 462319 462535 463772 465355 466069 466081 466103 466112 466118 466138 466145 466176 466180 470295 470483 470596 471046 474016 474024 475891 484377 484472 484566 484592 484595 484643 484681 484706 484739 485589 485600 485691 485700 485703 485777 486193 486277 486344 486897 488734 490265 493022 500694 502868 506081 507423 512516 512851 516091 519371 519433 519727 520011 524029 524073 524882 525691 528252 528258 543343 543579 555031 555055 562423 564429 586573 587098 598806 599844 605586 606012 609196 610695 611477 617641 620165 770312 800535 ] |
||||||||||||||||||||||||||||||
| 5 | 116.06 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 389117 424421 424660 439623 443737 443831 443982 454065 462117 462319 462535 463772 465355 466069 466081 466103 466112 466118 466138 466145 466176 466180 470295 470483 470596 471046 474016 474024 475891 484377 484472 484566 484592 484595 484643 484681 484706 484739 485589 485600 485691 485700 485703 485777 486193 486277 486344 486897 488734 490265 493022 500694 502868 506081 507423 512516 512851 516091 519371 519433 519727 520011 524029 524073 524882 525691 528252 528258 543343 543579 555031 555055 562423 564429 586573 587098 598806 599844 605586 606012 609196 610695 611477 617641 620165 770312 800535 ] |
||||||||||||||||||||||||||||||
| 6 | 14.95 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск лиза волосатая"
]
|
||||||||||||||||||||||||||||||
| 7 | 16.18 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.