Query Metrics
7
Database Queries
7
Different statements
123.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.76 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde tiny teen"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.89 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 434661 624214 562774 634423 536490 671648 761092 748192 463943 468587 391626 524110 404351 445551 565053 445567 443300 388566 392544 399853 412180 565044 565055 399058 698289 467844 673817 398425 472429 495673 530800 443310 396057 396553 468781 398388 443314 424497 468793 447327 418049 449019 462742 698302 597141 394532 456254 469656 415966 518917 428972 404366 408994 513718 472451 528034 459668 473054 538229 489082 393590 404346 565051 620291 473824 481786 397350 399253 519275 489607 414548 468603 463919 416635 416536 827610 517727 520736 456120 447337 494699 419627 465613 475508 448816 462450 ] |
||||||||||||||||||||||||||||||
| 4 | 2.99 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 388566 391626 392544 393590 394532 396057 396553 397350 398388 398425 399058 399253 399853 404346 404351 404366 408994 412180 414548 415966 416536 416635 418049 419627 424497 428972 434661 443300 443310 443314 445551 445567 447327 447337 448816 449019 456120 456254 459668 462450 462742 463919 463943 465613 467844 468587 468603 468781 468793 469656 472429 472451 473054 473824 475508 481786 489082 489607 494699 495673 513718 517727 518917 519275 520736 524110 528034 530800 536490 538229 562774 565044 565051 565053 565055 597141 620291 624214 634423 671648 673817 698289 698302 748192 761092 827610 ] |
||||||||||||||||||||||||||||||
| 5 | 99.93 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 388566 391626 392544 393590 394532 396057 396553 397350 398388 398425 399058 399253 399853 404346 404351 404366 408994 412180 414548 415966 416536 416635 418049 419627 424497 428972 434661 443300 443310 443314 445551 445567 447327 447337 448816 449019 456120 456254 459668 462450 462742 463919 463943 465613 467844 468587 468603 468781 468793 469656 472429 472451 473054 473824 475508 481786 489082 489607 494699 495673 513718 517727 518917 519275 520736 524110 528034 530800 536490 538229 562774 565044 565051 565053 565055 597141 620291 624214 634423 671648 673817 698289 698302 748192 761092 827610 ] |
||||||||||||||||||||||||||||||
| 6 | 1.76 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая tiny teen"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.58 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая tiny teen"
]
|
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.