Query Metrics
7
Database Queries
7
Different statements
607.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.40 ms (35.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск saggy"
]
|
||||||||||||||||||||||||||||||
|
208.07 ms (34.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
165.30 ms (27.22%) |
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 391527 391528 391947 417071 426688 448412 448892 448897 448900 453682 454136 460425 461942 471104 474197 476636 476986 479086 479308 484447 491242 493342 496665 500700 504325 506407 522450 533052 533733 535607 543689 543759 544952 545875 546893 562747 563454 566353 566737 601409 605307 605875 610835 620696 623385 644861 657634 662410 667907 667980 668829 672841 683272 695381 708215 711362 720658 722085 725204 731575 732903 735881 738363 738527 741710 742386 744172 754641 754785 755875 759489 761797 762521 762669 765152 765495 766315 768161 768452 768734 768830 769138 770640 778300 779386 781667 782614 783609 789348 789353 789361 789379 792334 793051 795203 796262 796459 797131 797316 798289 799531 801496 804091 805615 808541 811144 818008 818719 819265 819369 819867 819921 824206 825738 825743 825904 826127 826219 826581 827812 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (2.18%) |
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 826127 391947 491242 522450 533733 454136 471104 391527 484447 417071 644861 448412 543759 562747 543689 563454 672841 720658 683272 605875 610835 779386 783609 808541 741710 765152 738527 742386 762669 623385 448892 479308 460425 479086 448900 426688 448897 476986 453682 493342 496665 500700 504325 506407 818719 819369 825904 826581 818008 819921 826219 824206 825738 825743 819867 535607 533052 544952 545875 566737 667980 657634 667907 668829 708215 695381 566353 620696 601409 605307 792334 797131 799531 805615 778300 782614 789348 789353 796262 797316 798289 801496 731575 754641 781667 789361 789379 796459 811144 725204 754785 766315 768734 732903 738363 755875 759489 768161 768452 768830 735881 744172 761797 765495 769138 762521 770640 711362 722085 793051 795203 804091 391528 819265 827812 476636 474197 461942 546893 662410 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.51%) |
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 391527 391528 391947 417071 426688 448412 448892 448897 448900 453682 454136 460425 461942 471104 474197 476636 476986 479086 479308 484447 491242 493342 496665 500700 504325 506407 522450 533052 533733 535607 543689 543759 544952 545875 546893 562747 563454 566353 566737 601409 605307 605875 610835 620696 623385 644861 657634 662410 667907 667980 668829 672841 683272 695381 708215 711362 720658 722085 725204 731575 732903 735881 738363 738527 741710 742386 744172 754641 754785 755875 759489 761797 762521 762669 765152 765495 766315 768161 768452 768734 768830 769138 770640 778300 779386 781667 782614 783609 789348 789353 789361 789379 792334 793051 795203 796262 796459 797131 797316 798289 799531 801496 804091 805615 808541 811144 818008 818719 819265 819369 819867 819921 824206 825738 825743 825904 826127 826219 826581 827812 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск saggy"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian saggy"
]
|
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.