Query Metrics
7
Database Queries
7
Different statements
169.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.01 ms (83.26%) |
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 382432 395235 395249 396586 396816 401199 403589 420023 422434 438839 447111 501245 502236 530824 542437 544350 546434 549341 550750 552613 552957 557157 563964 564071 568030 570444 571451 574487 574829 586388 591190 591520 603126 603371 612230 622585 622658 624371 629072 629858 634819 651875 654473 654499 654601 654619 654670 655344 655976 657050 657346 657411 657705 658359 658670 659314 659565 660525 661249 662777 663508 663899 664304 665404 666614 670038 684248 684326 696331 700798 704865 714815 716715 724105 727382 732887 734239 742215 742227 743335 745520 751762 758304 764515 764617 787949 789299 789313 789543 793458 793729 793732 797573 798566 804169 804706 806044 809174 810234 810730 817145 817464 817622 817883 819122 819993 821468 821552 821572 821817 822137 822305 822406 823246 823421 825462 825552 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (10.19%) |
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 727382 401199 591190 549341 403589 557157 793729 758304 822406 816024 823421 764515 724105 422434 651875 825462 447111 396816 654837 564071 716715 819993 657705 570444 502236 574487 438839 663899 825552 823246 822137 544350 655344 659314 603126 788760 396586 654473 742215 742227 700798 821817 821552 817145 659565 661249 670038 654601 797573 743335 793732 806044 395235 789313 530824 574829 657050 658359 660525 654499 654670 655976 657346 657411 662777 664304 658670 603371 789543 810234 787949 810730 654619 591520 684326 382432 704865 764617 622658 821572 501245 793458 714815 817622 789299 821468 666614 586388 734239 629072 420023 817883 552613 665404 696331 550750 804706 809174 634819 395249 822305 817464 819122 568030 571451 546434 552957 563964 684248 663508 612230 622585 624371 629858 798566 804169 732887 745520 751762 542437 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.00%) |
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 382432 395235 395249 396586 396816 401199 403589 420023 422434 438839 447111 501245 502236 530824 542437 544350 546434 549341 550750 552613 552957 557157 563964 564071 568030 570444 571451 574487 574829 586388 591190 591520 603126 603371 612230 622585 622658 624371 629072 629858 634819 651875 654473 654499 654601 654619 654670 655344 655976 657050 657346 657411 657705 658359 658670 659314 659565 660525 661249 662777 663508 663899 664304 665404 666614 670038 684248 684326 696331 700798 704865 714815 716715 724105 727382 732887 734239 742215 742227 743335 745520 751762 758304 764515 764617 787949 789299 789313 789543 793458 793729 793732 797573 798566 804169 804706 806044 809174 810234 810730 817145 817464 817622 817883 819122 819993 821468 821552 821572 821817 822137 822305 822406 823246 823421 825462 825552 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут худую сучку"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс худая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
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.