Query Metrics
7
Database Queries
7
Different statements
268.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
242.51 ms (90.42%) |
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 337134 423959 448078 456831 460485 506312 506444 514346 531573 536268 541547 552092 555642 567008 568350 572713 582469 606280 607253 612488 614821 616771 619360 627927 634737 636261 638145 638173 652665 658553 662074 671472 673462 678608 680611 701200 701509 704977 709323 713271 714286 716634 719780 721252 722086 723123 724550 724697 727614 728814 732582 734037 734294 734343 734356 734856 735463 740072 744522 744766 745610 748335 752176 756947 761397 762970 763579 763589 768126 768363 769350 771159 772922 773829 775621 777479 778797 778959 779036 779228 779636 779895 780002 782774 785944 786421 786999 787576 788596 788979 789154 790829 790952 791049 791491 791494 793383 793682 794481 795412 795492 800273 800628 801057 801129 801595 802976 805054 805621 807008 814993 816810 817727 817938 818623 819189 819335 820646 823170 826538 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (5.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 740072 790829 801057 734356 756947 735463 745610 732582 634737 775621 801595 724550 823170 423959 816810 820646 826538 817727 817938 818623 819189 819335 456831 448078 552092 568350 572713 555642 582469 673462 680611 713271 721252 671472 678608 714286 719780 614821 616771 619360 636261 638173 607253 627927 612488 606280 786999 795412 795492 805054 780002 791494 794481 807008 734343 752176 761397 785944 787576 789154 748335 724697 734856 768126 768363 728814 762970 769350 772922 773829 701200 709323 777479 778797 779036 782774 788979 790952 791049 791491 800273 802976 460485 514346 506312 337134 779636 779895 771159 788596 744522 536268 506444 652665 658553 662074 716634 779228 793383 793682 805621 727614 734037 801129 744766 734294 763589 763579 638145 778959 786421 814993 531573 567008 541547 701509 704977 723123 722086 800628 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.05%) |
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 337134 423959 448078 456831 460485 506312 506444 514346 531573 536268 541547 552092 555642 567008 568350 572713 582469 606280 607253 612488 614821 616771 619360 627927 634737 636261 638145 638173 652665 658553 662074 671472 673462 678608 680611 701200 701509 704977 709323 713271 714286 716634 719780 721252 722086 723123 724550 724697 727614 728814 732582 734037 734294 734343 734356 734856 735463 740072 744522 744766 745610 748335 752176 756947 761397 762970 763579 763589 768126 768363 769350 771159 772922 773829 775621 777479 778797 778959 779036 779228 779636 779895 780002 782774 785944 786421 786999 787576 788596 788979 789154 790829 790952 791049 791491 791494 793383 793682 794481 795412 795492 800273 800628 801057 801129 801595 802976 805054 805621 807008 814993 816810 817727 817938 818623 819189 819335 820646 823170 826538 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс face"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck face"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс face"
]
|
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.