Query Metrics
7
Database Queries
7
Different statements
407.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.08 ms (50.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
181.00 ms (44.43%) |
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 10171 185247 385681 390987 403616 406362 425846 490700 496326 507123 544258 556800 563243 604379 604390 618314 625743 636400 648536 650151 664194 675460 675481 675745 677630 679089 680878 685600 686265 689160 694325 697467 699101 700897 702374 705353 706407 707729 712998 713642 714785 716710 718427 721197 725902 727784 729064 729966 733969 734036 734135 734320 734990 739602 740243 741521 751697 752809 752966 759364 762194 763892 764325 766292 767686 767781 770693 772492 773151 773525 776146 779546 780287 782095 783383 783387 783436 783781 790185 791323 792535 793430 793574 794406 796704 799113 799544 799608 800137 800364 803102 803272 805880 813607 815933 816639 816941 817099 817325 817962 818487 818510 819889 820196 820802 821004 821183 821542 822910 823178 823485 825110 825440 825462 825688 826048 826640 826745 827464 827520 ] |
||||||||||||||||||||||||||||||
|
12.74 ms (3.13%) |
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 648536 675460 679089 707729 700897 618314 783781 780287 796704 799113 734320 767686 772492 793574 800364 805880 729966 740243 752966 739602 767781 725902 716710 776146 783436 799544 803272 425846 779546 604379 705353 185247 675481 793430 727784 762194 721197 406362 825110 821004 686265 689160 664194 625743 794406 783387 792535 733969 734036 759364 729064 751697 763892 741521 718427 385681 10171 823178 819889 490700 507123 496326 694325 697467 702374 636400 782095 791323 773151 783383 790185 403616 816639 816941 818487 826640 817962 827464 827520 823485 815933 544258 699101 680878 712998 604390 800137 803102 734135 770693 773525 799608 764325 752809 734990 766292 390987 826048 813607 817099 820196 825688 826745 818510 820802 822910 817325 821183 821542 825440 825462 563243 556800 650151 677630 706407 714785 675745 713642 685600 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (0.77%) |
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 10171 185247 385681 390987 403616 406362 425846 490700 496326 507123 544258 556800 563243 604379 604390 618314 625743 636400 648536 650151 664194 675460 675481 675745 677630 679089 680878 685600 686265 689160 694325 697467 699101 700897 702374 705353 706407 707729 712998 713642 714785 716710 718427 721197 725902 727784 729064 729966 733969 734036 734135 734320 734990 739602 740243 741521 751697 752809 752966 759364 762194 763892 764325 766292 767686 767781 770693 772492 773151 773525 776146 779546 780287 782095 783383 783387 783436 783781 790185 791323 792535 793430 793574 794406 796704 799113 799544 799608 800137 800364 803102 803272 805880 813607 815933 816639 816941 817099 817325 817962 818487 818510 819889 820196 820802 821004 821183 821542 822910 823178 823485 825110 825440 825462 825688 826048 826640 826745 827464 827520 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"all sex"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"all секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"all секс"
]
|
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.