Query Metrics
7
Database Queries
7
Different statements
185.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.32 ms (87.20%) |
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 213136 239808 366052 383985 392760 395549 395931 396656 421283 422076 423123 430787 435052 444083 444734 446252 449952 451463 455175 460272 464260 466782 469130 473239 473493 483822 485522 492731 500628 500720 501505 508293 514687 515137 517001 520932 521166 521171 522928 523291 535337 544525 553291 554458 556984 559907 561086 567308 570179 571822 578470 583907 584079 588331 600800 600819 600826 600883 612403 619451 621686 623569 623991 637521 640317 645935 665319 666796 666830 667694 672211 675581 688633 695724 699201 702065 704068 709911 711679 713329 717692 718733 721773 724888 726977 727006 727239 727491 736905 740985 742695 748799 750326 755498 760122 760814 771291 774524 779039 782407 784142 786573 786763 788797 793098 796243 802467 805354 807834 810734 813573 813786 814332 815095 815138 815139 817006 818435 823644 823953 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (7.92%) |
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 396656 815139 492731 817006 446252 444734 395549 421283 584079 675581 727239 383985 515137 435052 473239 535337 570179 571822 500628 517001 485522 588331 556984 718733 702065 709911 771291 727006 637521 520932 815138 742695 666830 818435 621686 805354 774524 796243 810734 473493 464260 823644 814332 717692 583907 554458 559907 578470 667694 623991 726977 395931 430787 600819 740985 802467 612403 423123 750326 786763 623569 449952 466782 813573 514687 501505 521166 444083 665319 522928 813786 455175 786573 760814 782407 469130 815095 567308 695724 793098 823953 788797 704068 721773 807834 760122 366052 392760 666796 645935 784142 672211 727491 508293 779039 688633 600800 748799 213136 239808 640317 724888 460272 500720 544525 553291 711679 736905 713329 619451 523291 600883 483822 699201 600826 755498 521171 422076 451463 561086 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.29%) |
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 213136 239808 366052 383985 392760 395549 395931 396656 421283 422076 423123 430787 435052 444083 444734 446252 449952 451463 455175 460272 464260 466782 469130 473239 473493 483822 485522 492731 500628 500720 501505 508293 514687 515137 517001 520932 521166 521171 522928 523291 535337 544525 553291 554458 556984 559907 561086 567308 570179 571822 578470 583907 584079 588331 600800 600819 600826 600883 612403 619451 621686 623569 623991 637521 640317 645935 665319 666796 666830 667694 672211 675581 688633 695724 699201 702065 704068 709911 711679 713329 717692 718733 721773 724888 726977 727006 727239 727491 736905 740985 742695 748799 750326 755498 760122 760814 771291 774524 779039 782407 784142 786573 786763 788797 793098 796243 802467 805354 807834 810734 813573 813786 814332 815095 815138 815139 817006 818435 823644 823953 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boss fuck secretary"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boss секс секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boss секс секретарш"
]
|
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.