Query Metrics
7
Database Queries
7
Different statements
118.67 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping with sister"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.96 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 400708 424995 428265 429695 437555 417438 428166 429782 427332 447825 453437 459533 453568 457182 454051 491748 512221 516444 520885 517824 518233 525185 528425 529134 561155 560489 577468 584560 599376 614060 424917 479632 417839 416039 442605 447054 509819 523786 505310 511078 514781 524509 504765 514772 400341 441447 417493 457680 451380 509384 524334 528445 551816 619849 421043 516128 490097 513659 801033 461016 525142 552322 652289 584752 618718 426908 395452 480087 611241 489281 523215 703268 518450 441645 496100 471628 579732 584739 623615 430394 446435 521461 608111 608737 619107 528116 516876 442434 531920 617205 ] |
||||||||||||||||||||||||||||||
| 4 | 2.72 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 395452 400341 400708 416039 417438 417493 417839 421043 424917 424995 426908 427332 428166 428265 429695 429782 430394 437555 441447 441645 442434 442605 446435 447054 447825 451380 453437 453568 454051 457182 457680 459533 461016 471628 479632 480087 489281 490097 491748 496100 504765 505310 509384 509819 511078 512221 513659 514772 514781 516128 516444 516876 517824 518233 518450 520885 521461 523215 523786 524334 524509 525142 525185 528116 528425 528445 529134 531920 551816 552322 560489 561155 577468 579732 584560 584739 584752 599376 608111 608737 611241 614060 617205 618718 619107 619849 623615 652289 703268 801033 ] |
||||||||||||||||||||||||||||||
| 5 | 94.54 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 395452 400341 400708 416039 417438 417493 417839 421043 424917 424995 426908 427332 428166 428265 429695 429782 430394 437555 441447 441645 442434 442605 446435 447054 447825 451380 453437 453568 454051 457182 457680 459533 461016 471628 479632 480087 489281 490097 491748 496100 504765 505310 509384 509819 511078 512221 513659 514772 514781 516128 516444 516876 517824 518233 518450 520885 521461 523215 523786 524334 524509 525142 525185 528116 528425 528445 529134 531920 551816 552322 560489 561155 577468 579732 584560 584739 584752 599376 608111 608737 611241 614060 617205 618718 619107 619849 623615 652289 703268 801033 ] |
||||||||||||||||||||||||||||||
| 6 | 1.36 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ sister"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.35 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ sister"
]
|
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.