Query Metrics
7
Database Queries
7
Different statements
196.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.54 ms (89.53%) |
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 397106 397564 438659 450763 457648 460352 470621 483021 538149 542404 547084 552645 558662 563813 567270 586894 595074 596333 604912 605190 609063 609543 611907 615005 616137 619026 624765 625799 632209 633477 638065 644115 644171 645606 676711 680514 680519 686064 687391 689977 690652 701207 705749 708704 709367 711709 714372 717122 717159 718648 718971 719129 722048 725641 726303 727252 728012 728549 732233 735477 736318 736329 736954 736958 740482 742863 744385 746900 747009 748024 749698 749737 750263 750560 751190 754192 755658 755956 759026 759596 760019 764313 767692 767884 768749 770914 778703 778871 779004 779542 780840 784977 787451 788688 789920 790628 790646 791159 792978 793740 793964 796966 797812 799604 799794 801007 803611 803683 804446 804880 805183 807999 810339 817203 818979 821942 821997 822077 827074 827474 ] |
||||||||||||||||||||||||||||||
|
10.45 ms (5.33%) |
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 625799 807999 792978 799794 740482 796966 397106 827074 818979 563813 687391 705749 714372 689977 708704 632209 604912 595074 638065 778871 793964 799604 805183 778703 784977 788688 793740 804446 728549 746900 787451 797812 803683 726303 728012 732233 767884 755956 764313 717122 780840 817203 709367 719129 722048 605190 619026 644171 779542 736318 749698 750560 760019 748024 759026 736954 768749 750263 751190 611907 624765 718648 718971 790646 457648 686064 552645 789920 803611 759596 711709 397564 438659 821942 558662 680519 567270 633477 779004 790628 791159 736329 749737 754192 747009 770914 744385 735477 736958 615005 460352 822077 821997 827474 450763 470621 483021 538149 542404 547084 645606 676711 680514 690652 701207 717159 586894 616137 609063 609543 644115 596333 801007 725641 742863 755658 767692 804880 810339 727252 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.53%) |
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 397106 397564 438659 450763 457648 460352 470621 483021 538149 542404 547084 552645 558662 563813 567270 586894 595074 596333 604912 605190 609063 609543 611907 615005 616137 619026 624765 625799 632209 633477 638065 644115 644171 645606 676711 680514 680519 686064 687391 689977 690652 701207 705749 708704 709367 711709 714372 717122 717159 718648 718971 719129 722048 725641 726303 727252 728012 728549 732233 735477 736318 736329 736954 736958 740482 742863 744385 746900 747009 748024 749698 749737 750263 750560 751190 754192 755658 755956 759026 759596 760019 764313 767692 767884 768749 770914 778703 778871 779004 779542 780840 784977 787451 788688 789920 790628 790646 791159 792978 793740 793964 796966 797812 799604 799794 801007 803611 803683 804446 804880 805183 807999 810339 817203 818979 821942 821997 822077 827074 827474 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"good girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"good девушк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"good девушк"
]
|
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.