Query Metrics
7
Database Queries
7
Different statements
153.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.17 ms (80.36%) |
1 |
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 409995 414976 419627 420040 422599 422617 422618 422633 422652 423633 428476 430436 433497 444916 445737 446373 448445 448829 451259 454635 454802 468098 469075 473733 475308 475828 485216 486885 489424 491354 494694 495014 496086 501551 503151 504481 508518 508523 509802 510198 511313 516744 517842 518493 518996 520739 521805 525026 526553 530681 531117 531174 531186 531235 532661 532838 533372 533645 545305 551763 556797 565253 573393 579389 582810 586504 586573 589060 589524 591792 599844 607630 612434 614737 614858 617422 621125 622398 622938 630063 630526 631163 631972 635275 636295 636308 639739 639760 639796 639824 641978 642016 642063 643103 646176 646786 647854 647860 647885 647948 666899 666901 666902 666904 688581 688663 717318 727812 738493 741531 789494 ] |
||||||||||||||||||||||||||||||
|
19.68 ms (12.84%) |
1 |
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 520739 428476 486885 422617 422633 422599 475308 532838 501551 688581 688663 565253 485216 495014 517842 422652 454635 531186 666904 646786 586504 591792 630526 430436 414976 612434 521805 530681 582810 666899 647885 717318 491354 518493 727812 473733 420040 468098 589524 448829 451259 741531 525026 738493 469075 510198 533372 545305 666902 642063 586573 636295 614858 533645 489424 636308 531235 666901 631972 631163 494694 556797 422618 630063 504481 579389 607630 599844 445737 511313 531117 639796 639760 643103 475828 551763 508518 622938 518996 448445 454802 531174 639824 526553 622398 617422 532661 639739 647854 646176 419627 508523 573393 647860 496086 509802 423633 621125 446373 647948 614737 642016 789494 444916 409995 433497 641978 635275 503151 516744 589060 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.30%) |
1 |
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 409995 414976 419627 420040 422599 422617 422618 422633 422652 423633 428476 430436 433497 444916 445737 446373 448445 448829 451259 454635 454802 468098 469075 473733 475308 475828 485216 486885 489424 491354 494694 495014 496086 501551 503151 504481 508518 508523 509802 510198 511313 516744 517842 518493 518996 520739 521805 525026 526553 530681 531117 531174 531186 531235 532661 532838 533372 533645 545305 551763 556797 565253 573393 579389 582810 586504 586573 589060 589524 591792 599844 607630 612434 614737 614858 617422 621125 622398 622938 630063 630526 631163 631972 635275 636295 636308 639739 639760 639796 639824 641978 642016 642063 643103 646176 646786 647854 647860 647885 647948 666899 666901 666902 666904 688581 688663 717318 727812 738493 741531 789494 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy casting anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая кастинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая кастинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.