Query Metrics
7
Database Queries
7
Different statements
172.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.54 ms (84.76%) |
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 96342 388546 395696 434310 448816 449123 452014 464343 466404 471165 477097 484673 489328 506195 517466 518473 524628 530637 530659 533042 533363 533689 537236 537888 540294 540511 541082 543401 543840 544636 545611 548752 550681 550741 556016 559120 565369 566079 573158 590191 593992 597600 598783 604172 606515 615961 619168 624850 628181 628707 634780 635233 637128 642766 644998 649138 649953 651601 654256 670949 673332 674995 675043 676777 677974 680974 683963 684316 684369 692463 702047 705794 706030 712814 713176 717034 719862 719930 720281 720950 723536 724556 724564 726252 733050 733178 737105 743380 744293 744856 747656 751565 751646 770823 771960 775820 785289 785963 787575 788177 790386 793441 793468 801978 804186 807512 807549 807918 808946 809184 809937 810109 810689 813350 815395 817340 818284 818309 820690 820765 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (9.10%) |
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 524628 649953 635233 634780 751565 642766 489328 434310 452014 533042 540511 530659 533363 566079 449123 484673 537888 537236 518473 674995 713176 448816 733178 548752 807918 545611 651601 820690 543840 644998 395696 565369 606515 677974 649138 593992 673332 471165 597600 723536 712814 809937 820765 790386 619168 702047 705794 807549 692463 533689 787575 684369 654256 675043 775820 573158 590191 810689 550681 785289 540294 550741 733050 813350 818309 743380 541082 506195 624850 747656 604172 818284 808946 809184 744856 388546 530637 684316 726252 466404 793468 771960 680974 724564 517466 788177 544636 628707 615961 810109 676777 556016 744293 804186 543401 477097 670949 724556 559120 817340 598783 628181 737105 785963 751646 719930 96342 464343 807512 717034 815395 801978 719862 637128 770823 720950 793441 683963 720281 706030 ] |
||||||||||||||||||||||||||||||
|
3.58 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 96342 388546 395696 434310 448816 449123 452014 464343 466404 471165 477097 484673 489328 506195 517466 518473 524628 530637 530659 533042 533363 533689 537236 537888 540294 540511 541082 543401 543840 544636 545611 548752 550681 550741 556016 559120 565369 566079 573158 590191 593992 597600 598783 604172 606515 615961 619168 624850 628181 628707 634780 635233 637128 642766 644998 649138 649953 651601 654256 670949 673332 674995 675043 676777 677974 680974 683963 684316 684369 692463 702047 705794 706030 712814 713176 717034 719862 719930 720281 720950 723536 724556 724564 726252 733050 733178 737105 743380 744293 744856 747656 751565 751646 770823 771960 775820 785289 785963 787575 788177 790386 793441 793468 801978 804186 807512 807549 807918 808946 809184 809937 810109 810689 813350 815395 817340 818284 818309 820690 820765 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс втроем жёсткое"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
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.