Query Metrics
7
Database Queries
7
Different statements
358.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.10 ms (57.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
129.49 ms (36.13%) |
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 14225 26026 382669 385596 389819 391923 392079 396379 397619 398567 419969 427208 444236 452212 452217 453397 454390 455065 459936 461023 465555 465653 466848 478611 493020 497742 503483 503974 515961 527275 529740 531787 533952 533962 544669 545467 546046 563768 567090 582431 584017 584020 585365 588420 589120 592648 601746 602530 605676 631615 636464 643287 648005 653392 661536 662900 664579 666152 674197 675956 697178 710191 728619 732179 732570 732944 732993 733516 733564 736097 738209 738255 738840 739294 739353 741700 741750 742056 744466 745354 745952 745964 747062 747067 751520 757226 759714 774410 781814 781874 781884 781895 781909 782015 784831 792592 792643 794175 794179 795101 796860 796868 797175 797333 801014 802274 805632 808024 812371 812391 813310 813793 819361 821761 823746 824331 824688 824833 826601 826781 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (3.93%) |
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 805632 808024 781874 812371 736097 781909 797333 391923 567090 588420 697178 546046 382669 823746 824688 826601 529740 531787 662900 666152 813310 732179 738209 738840 745964 795101 385596 465555 26026 821761 824331 454390 455065 497742 503483 527275 544669 812391 792592 794175 732944 732570 801014 478611 774410 452212 466848 661536 710191 605676 643287 592648 733516 444236 826781 14225 389819 533962 545467 584017 674197 733564 745354 728619 732993 738255 741700 742056 744466 757226 739353 751520 747067 396379 493020 392079 398567 648005 653392 675956 601746 631615 602530 427208 819361 813793 465653 452217 515961 503974 563768 582431 584020 589120 585365 797175 781814 781895 741750 781884 792643 745952 747062 739294 782015 784831 794179 796860 796868 802274 461023 397619 453397 419969 664579 636464 759714 824833 459936 533952 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.67%) |
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 14225 26026 382669 385596 389819 391923 392079 396379 397619 398567 419969 427208 444236 452212 452217 453397 454390 455065 459936 461023 465555 465653 466848 478611 493020 497742 503483 503974 515961 527275 529740 531787 533952 533962 544669 545467 546046 563768 567090 582431 584017 584020 585365 588420 589120 592648 601746 602530 605676 631615 636464 643287 648005 653392 661536 662900 664579 666152 674197 675956 697178 710191 728619 732179 732570 732944 732993 733516 733564 736097 738209 738255 738840 739294 739353 741700 741750 742056 744466 745354 745952 745964 747062 747067 751520 757226 759714 774410 781814 781874 781884 781895 781909 782015 784831 792592 792643 794175 794179 795101 796860 796868 797175 797333 801014 802274 805632 808024 812371 812391 813310 813793 819361 821761 823746 824331 824688 824833 826601 826781 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur bbw"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск bbw"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск bbw"
]
|
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.