Query Metrics
8
Database Queries
8
Different statements
212.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.65 ms (87.16%) |
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 225519 417871 419822 421154 428169 428596 439034 439393 441126 446540 455087 459170 468175 475512 488820 492145 492192 493515 496454 510303 513457 513968 524678 529701 530306 531929 533164 533777 534331 535522 535766 537217 538248 539741 541274 542264 542411 545224 546666 547434 547458 547472 547609 549231 559401 559781 564288 568093 572181 580989 584025 584164 585726 593656 604311 604514 607254 608174 617430 619376 620922 620978 623176 634021 637567 639363 639552 641628 644036 647689 647839 655153 660365 664189 666484 669390 670826 671032 672275 677397 693489 696100 700674 706250 707102 711089 713022 715830 720714 724302 731328 736350 742298 746884 748927 756196 760814 762301 765355 765437 770900 773903 777575 780950 786993 787563 788187 791252 791802 793597 795169 798734 801287 802025 804326 804758 810422 813218 817278 824883 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (7.03%) |
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 655153 660365 693489 604514 620922 641628 756196 770900 724302 780950 670826 672275 647839 720714 513457 547458 664189 637567 798734 793597 804326 748927 742298 746884 706250 428596 455087 541274 468175 459170 421154 529701 533164 538248 530306 533777 535766 545224 580989 564288 671032 696100 711089 547434 623176 639363 634021 639552 795169 810422 786993 765355 773903 604311 644036 715830 817278 492145 572181 617430 801287 547609 559401 647689 707102 713022 777575 802025 765437 762301 439393 549231 419822 700674 787563 813218 547472 584164 608174 417871 542264 584025 593656 510303 585726 620978 439034 441126 492192 446540 496454 524678 428169 475512 488820 539741 513968 542411 568093 607254 731328 791802 225519 677397 669390 559781 619376 788187 736350 760814 804758 824883 493515 534331 535522 537217 531929 546666 666484 791252 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.36%) |
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 225519 417871 419822 421154 428169 428596 439034 439393 441126 446540 455087 459170 468175 475512 488820 492145 492192 493515 496454 510303 513457 513968 524678 529701 530306 531929 533164 533777 534331 535522 535766 537217 538248 539741 541274 542264 542411 545224 546666 547434 547458 547472 547609 549231 559401 559781 564288 568093 572181 580989 584025 584164 585726 593656 604311 604514 607254 608174 617430 619376 620922 620978 623176 634021 637567 639363 639552 641628 644036 647689 647839 655153 660365 664189 666484 669390 670826 671032 672275 677397 693489 696100 700674 706250 707102 711089 713022 715830 720714 724302 731328 736350 742298 746884 748927 756196 760814 762301 765355 765437 770900 773903 777575 780950 786993 787563 788187 791252 791802 793597 795169 798734 801287 802025 804326 804758 810422 813218 817278 824883 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck gape anal"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большая большие дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01—\x03Éd°r'§íÓ†ú”ˆ7"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.