Query Metrics
7
Database Queries
7
Different statements
386.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.64 ms (53.69%) |
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 392751 529418 530205 551002 553244 600235 602756 614866 619013 624649 629168 647108 662089 692076 704583 709698 714535 714989 719233 719972 720324 720864 724567 726959 727184 727979 730222 731399 732200 732875 734210 734722 735963 736228 740280 740974 742820 744623 744678 746945 747549 747798 748134 748430 749307 752034 761259 761301 761328 761433 762522 763144 763165 763186 763603 764622 764749 764788 765964 766046 766064 766069 766870 767345 767435 767781 767807 768263 768653 768809 769931 771684 772805 772823 773237 777797 778454 778775 779735 781338 781431 781441 781538 782608 783061 784086 784195 785265 785959 786251 787225 787409 788651 788658 789125 790131 790588 791767 792972 793759 795327 795795 796279 796303 797862 798694 798717 801347 803736 803748 803890 804844 805384 806313 809742 810338 ] |
||||||||||||||||||||||||||||||
|
160.63 ms (41.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 392751 529418 530205 551002 553244 600235 602756 614866 619013 624649 629168 647108 662089 692076 704583 709698 714535 714989 719233 719972 720324 720864 724567 726959 727184 727979 730222 731399 732200 732875 734210 734722 735963 736228 740280 740974 742820 744623 744678 746945 747549 747798 748134 748430 749307 752034 761259 761301 761328 761433 762522 763144 763165 763186 763603 764622 764749 764788 765964 766046 766064 766069 766870 767345 767435 767781 767807 768263 768653 768809 769931 771684 772805 772823 773237 777797 778454 778775 779735 781338 781431 781441 781538 782608 783061 784086 784195 785265 785959 786251 787225 787409 788651 788658 789125 790131 790588 791767 792972 793759 795327 795795 796279 796303 797862 798694 798717 801347 803736 803748 803890 804844 805384 806313 809742 810338 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (3.06%) |
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 747549 748134 764788 767345 767576 768263 773237 781338 781431 781538 784086 784195 785265 785959 787225 787409 788658 789125 790131 790588 791767 795327 798717 801347 803736 805384 809742 731399 732875 742820 761259 761301 761328 763165 763603 764749 765964 766064 768809 768810 724567 727979 734210 744623 764269 769681 771684 748430 752034 762522 763144 763186 766870 767435 767781 768653 769931 735963 740974 744678 761433 764622 766046 766069 767807 772805 772823 602756 629168 704583 720324 777797 778454 778775 779735 782608 783061 786251 792972 793759 796279 796303 797862 798694 803748 803890 804844 806313 810338 719972 720864 781441 709698 553244 662089 719233 647108 692076 600235 619013 795795 730222 734722 749307 740280 726959 732200 624649 392751 529418 530205 551002 714989 614866 736228 788651 727184 747798 746945 714535 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up dick"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up член"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up член"
]
|
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.