Query Metrics
7
Database Queries
7
Different statements
209.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.84 ms (89.69%) |
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 395381 396091 396464 399163 399647 418128 418622 418641 449319 450739 481871 500874 514017 525201 527670 534294 534330 545470 573993 577650 580288 584118 595339 597845 598220 599922 600171 607963 608002 608378 618306 618326 619167 624845 635270 640948 647854 650663 657197 661495 662086 678872 682885 682932 686138 692743 711631 714083 714097 716229 727483 728233 728750 728902 728916 728926 729278 734353 740806 740848 742975 744151 744155 748623 751424 751705 756786 761535 766347 767390 767479 769447 770254 771623 771884 772947 773019 773058 775227 776076 783893 783915 783939 784763 785058 785073 785109 785251 785966 786575 789646 792018 792340 792373 792665 793115 795024 795412 797051 797279 801523 803390 803391 803579 803986 806981 807009 807010 807585 808644 808674 809626 811343 813332 814033 814175 814232 815899 816524 826139 ] |
||||||||||||||||||||||||||||||
|
12.26 ms (5.85%) |
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 776076 742975 728750 785251 481871 545470 396464 815899 650663 682885 608002 784763 792340 792373 795412 801523 803390 803391 806981 772947 773019 751424 573993 766347 797279 729278 395381 807009 816524 814175 399163 399647 711631 795024 734353 773058 527670 803986 785058 783893 793115 808644 783915 771884 767390 769447 716229 618326 813332 584118 577650 678872 597845 619167 809626 640948 514017 814033 635270 789646 600171 661495 807585 803579 744151 608378 618306 775227 811343 748623 751705 785073 807010 418128 500874 662086 727483 647854 580288 624845 692743 792018 682932 786575 756786 771623 728902 728926 607963 792665 599922 595339 449319 686138 714097 714083 740848 761535 767479 770254 418641 598220 728916 534294 826139 740806 785966 534330 744155 396091 525201 657197 783939 785109 797051 808674 450739 418622 814232 728233 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.23%) |
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 395381 396091 396464 399163 399647 418128 418622 418641 449319 450739 481871 500874 514017 525201 527670 534294 534330 545470 573993 577650 580288 584118 595339 597845 598220 599922 600171 607963 608002 608378 618306 618326 619167 624845 635270 640948 647854 650663 657197 661495 662086 678872 682885 682932 686138 692743 711631 714083 714097 716229 727483 728233 728750 728902 728916 728926 729278 734353 740806 740848 742975 744151 744155 748623 751424 751705 756786 761535 766347 767390 767479 769447 770254 771623 771884 772947 773019 773058 775227 776076 783893 783915 783939 784763 785058 785073 785109 785251 785966 786575 789646 792018 792340 792373 792665 793115 795024 795412 797051 797279 801523 803390 803391 803579 803986 806981 807009 807010 807585 808644 808674 809626 811343 813332 814033 814175 814232 815899 816524 826139 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex and squirt"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
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.