Query Metrics
7
Database Queries
7
Different statements
174.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.46 ms (88.57%) |
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 6858 397325 397341 397856 398733 403112 516019 548965 549009 549550 557328 561852 571415 575460 575798 576992 583379 596245 597132 600358 602886 604211 604242 607265 611003 625978 626295 626880 629735 630392 639137 646211 647192 656562 656569 657134 657191 671255 672669 673696 676740 679171 686570 686581 689146 690443 692092 695467 699542 701079 701753 705753 706256 711112 712141 717221 717241 720680 722667 723271 724118 724240 728322 731261 734432 734990 735712 742846 742916 743092 748340 754220 755174 756160 758830 760481 760933 761383 761679 765366 765540 766799 769040 769314 771429 771607 776040 777029 777637 778628 778644 778951 778964 779683 781335 782674 783180 783275 783707 786372 788621 789193 790446 790586 790770 791200 791363 791426 792953 792989 793196 794067 796532 800521 804708 804900 806617 812018 814502 827835 ] |
||||||||||||||||||||||||||||||
|
10.91 ms (6.25%) |
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 686581 646211 657191 679171 705753 722667 647192 695467 701753 706256 548965 549550 571415 576992 611003 604211 626295 639137 596245 604242 625978 626880 778628 789193 793196 800521 812018 782674 796532 804708 734432 743092 760933 761383 766799 783180 786372 788621 790770 791363 792953 794067 731261 735712 742846 758830 761679 728322 755174 765366 769314 724118 742916 754220 765540 724240 734990 748340 760481 771429 699542 701079 712141 717221 717241 723271 776040 777029 783275 783707 791426 804900 397325 6858 397856 561852 575798 575460 720680 711112 656569 689146 790446 791200 778951 792989 806617 756160 769040 771607 777637 403112 600358 397341 398733 814502 827835 516019 583379 549009 657134 692092 671255 676740 690443 656562 672669 673696 686570 557328 607265 597132 602886 629735 630392 778644 778964 779683 790586 781335 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.50%) |
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 6858 397325 397341 397856 398733 403112 516019 548965 549009 549550 557328 561852 571415 575460 575798 576992 583379 596245 597132 600358 602886 604211 604242 607265 611003 625978 626295 626880 629735 630392 639137 646211 647192 656562 656569 657134 657191 671255 672669 673696 676740 679171 686570 686581 689146 690443 692092 695467 699542 701079 701753 705753 706256 711112 712141 717221 717241 720680 722667 723271 724118 724240 728322 731261 734432 734990 735712 742846 742916 743092 748340 754220 755174 756160 758830 760481 760933 761383 761679 765366 765540 766799 769040 769314 771429 771607 776040 777029 777637 778628 778644 778951 778964 779683 781335 782674 783180 783275 783707 786372 788621 789193 790446 790586 790770 791200 791363 791426 792953 792989 793196 794067 796532 800521 804708 804900 806617 812018 814502 827835 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens anal fuck"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens анал секс"
]
|
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.