Query Metrics
7
Database Queries
7
Different statements
156.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.82 ms (83.48%) |
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 80505 153311 191207 365881 382815 401464 402063 406045 407432 415796 425536 429788 462230 494270 503008 516441 520742 522420 524286 528336 538440 544782 556814 565157 566416 569391 584196 605885 611773 612027 615810 625819 627554 628344 630049 644600 649700 663410 663904 664851 665206 665278 667517 667672 669750 669753 670057 684965 694614 695108 695968 696794 696817 699156 700544 700850 700854 709359 710897 714162 714586 716391 717797 718559 721993 723012 724489 724495 725447 725975 726954 732245 732413 732871 733171 733287 738400 738508 740490 742204 748145 750901 751220 751306 752446 757453 757595 765371 766643 773193 773984 774313 779308 782374 785461 785638 787980 788292 793077 795381 797384 800949 801829 802149 803126 803809 804591 805314 807630 810233 812183 813508 815771 817129 818667 819166 819742 821471 823441 823773 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (9.51%) |
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 612027 800949 779308 788292 793077 795381 802149 807630 750901 766643 732871 738400 742204 803126 804591 191207 415796 528336 726954 520742 80505 425536 694614 714586 813508 765371 774313 801829 406045 818667 823773 819742 823441 522420 569391 695108 584196 782374 785638 751306 630049 429788 538440 566416 669750 669753 665206 665278 667672 700850 565157 611773 797384 724489 733287 738508 733171 724495 709359 402063 821471 819166 817129 544782 667517 684965 710897 716391 663904 721993 723012 644600 615810 725447 757453 757595 773193 751220 752446 732245 773984 627554 699156 700544 803809 524286 717797 732413 718559 462230 494270 812183 382815 663410 695968 787980 810233 365881 815771 714162 401464 516441 664851 725975 670057 153311 503008 605885 649700 696817 700854 696794 628344 805314 785461 740490 748145 625819 407432 556814 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.93%) |
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 80505 153311 191207 365881 382815 401464 402063 406045 407432 415796 425536 429788 462230 494270 503008 516441 520742 522420 524286 528336 538440 544782 556814 565157 566416 569391 584196 605885 611773 612027 615810 625819 627554 628344 630049 644600 649700 663410 663904 664851 665206 665278 667517 667672 669750 669753 670057 684965 694614 695108 695968 696794 696817 699156 700544 700850 700854 709359 710897 714162 714586 716391 717797 718559 721993 723012 724489 724495 725447 725975 726954 732245 732413 732871 733171 733287 738400 738508 740490 742204 748145 750901 751220 751306 752446 757453 757595 765371 766643 773193 773984 774313 779308 782374 785461 785638 787980 788292 793077 795381 797384 800949 801829 802149 803126 803809 804591 805314 807630 810233 812183 813508 815771 817129 818667 819166 819742 821471 823441 823773 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits fucks"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ fucks"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ fucks"
]
|
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.