Query Metrics
7
Database Queries
7
Different statements
174.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.74 ms (84.55%) |
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 8167 9732 32923 34830 74588 231375 320078 383926 385064 386202 390493 391015 400843 404261 408741 414866 418858 420601 420619 420685 421735 425333 427540 428804 429033 430110 431496 436645 438979 440629 440951 444394 445580 445930 446397 447145 447384 448051 450254 452841 454784 457653 459736 460057 460816 462242 462681 465474 466675 469997 475814 478725 479240 482169 483478 484743 485856 487183 492405 492516 492788 495557 497244 509511 513199 517536 520706 525305 529884 530341 534218 542096 542291 546639 547881 552078 552197 553997 556605 558398 560143 560341 560625 565131 566671 570196 573492 574196 575209 577418 584320 586546 587212 588262 588554 598331 608635 613903 620789 629362 658193 667026 765887 774664 774814 777419 782645 782682 783448 784874 785074 791198 795103 797871 800954 802732 810233 810243 811271 814626 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (8.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 448051 575209 436645 658193 9732 74588 513199 629362 465474 414866 774664 784874 520706 482169 492516 492405 791198 483478 556605 565131 431496 404261 560341 492788 517536 765887 385064 32923 783448 525305 438979 445580 529884 8167 390493 558398 440629 782645 460057 570196 546639 553997 400843 802732 542291 566671 584320 420619 457653 466675 469997 613903 598331 552197 814626 485856 430110 810233 777419 452841 475814 560625 586546 418858 497244 459736 811271 447384 495557 552078 667026 797871 577418 574196 450254 478725 487183 542096 427540 383926 428804 530341 462242 460816 484743 810243 447145 408741 420601 34830 444394 547881 795103 509511 785074 587212 774814 620789 800954 421735 560143 425333 534218 454784 608635 479240 391015 573492 588554 446397 440951 420685 386202 231375 445930 588262 320078 462681 782682 429033 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (2.07%) |
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 8167 9732 32923 34830 74588 231375 320078 383926 385064 386202 390493 391015 400843 404261 408741 414866 418858 420601 420619 420685 421735 425333 427540 428804 429033 430110 431496 436645 438979 440629 440951 444394 445580 445930 446397 447145 447384 448051 450254 452841 454784 457653 459736 460057 460816 462242 462681 465474 466675 469997 475814 478725 479240 482169 483478 484743 485856 487183 492405 492516 492788 495557 497244 509511 513199 517536 520706 525305 529884 530341 534218 542096 542291 546639 547881 552078 552197 553997 556605 558398 560143 560341 560625 565131 566671 570196 573492 574196 575209 577418 584320 586546 587212 588262 588554 598331 608635 613903 620789 629362 658193 667026 765887 774664 774814 777419 782645 782682 783448 784874 785074 791198 795103 797871 800954 802732 810233 810243 811271 814626 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful big tits"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
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.