Query Metrics
7
Database Queries
7
Different statements
367.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.96 ms (56.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex group"
]
|
||||||||||||||||||||||||||||||
|
136.56 ms (37.20%) |
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 12594 58336 61369 65281 96059 96461 123554 129748 129791 231299 348409 381770 383019 383697 384516 385465 385919 387160 395275 396069 396800 399421 400537 402597 408508 419623 428672 447901 453641 486975 509375 530143 532361 536399 538840 538888 539139 542829 544792 550949 552070 554121 556408 558619 583958 583967 595767 603207 603213 604474 606511 612866 614627 617800 622225 622245 628350 629409 634462 640351 644274 645207 664963 670062 672396 675930 676344 681127 681307 686835 692432 694117 694207 696870 698140 698398 703046 703098 703209 703521 705541 708827 710102 714813 717856 721140 722464 722520 731682 731994 731999 732925 736435 737473 743817 748214 749918 756234 756766 772667 774642 775854 781992 788171 788182 788745 789329 790029 801231 801959 802794 808000 810350 814646 815219 817080 817889 818965 823944 827858 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (3.80%) |
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 670062 694207 710102 583958 622245 628350 603207 606511 612866 775854 788171 788182 788745 801231 802794 781992 748214 749918 756766 731682 732925 743817 617800 703209 705541 721140 790029 810350 387160 453641 486975 428672 542829 395275 58336 538888 532361 554121 672396 675930 686835 708827 664963 676344 603213 604474 530143 614627 737473 539139 544792 556408 722520 645207 696870 722464 550949 65281 756234 123554 129748 348409 96461 823944 681127 629409 61369 814646 827858 447901 536399 694117 703098 583967 622225 736435 731999 731994 703046 774642 419623 400537 96059 383019 129791 231299 381770 12594 396069 399421 402597 408508 817080 817889 815219 818965 509375 538840 552070 558619 698140 681307 692432 717856 595767 634462 640351 808000 801959 772667 644274 698398 703521 714813 789329 396800 385465 385919 384516 383697 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (0.92%) |
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 12594 58336 61369 65281 96059 96461 123554 129748 129791 231299 348409 381770 383019 383697 384516 385465 385919 387160 395275 396069 396800 399421 400537 402597 408508 419623 428672 447901 453641 486975 509375 530143 532361 536399 538840 538888 539139 542829 544792 550949 552070 554121 556408 558619 583958 583967 595767 603207 603213 604474 606511 612866 614627 617800 622225 622245 628350 629409 634462 640351 644274 645207 664963 670062 672396 675930 676344 681127 681307 686835 692432 694117 694207 696870 698140 698398 703046 703098 703209 703521 705541 708827 710102 714813 717856 721140 722464 722520 731682 731994 731999 732925 736435 737473 743817 748214 749918 756234 756766 772667 774642 775854 781992 788171 788182 788745 789329 790029 801231 801959 802794 808000 810350 814646 815219 817080 817889 818965 823944 827858 ] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс group"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс group"
]
|
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.