Query Metrics
7
Database Queries
7
Different statements
365.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
340.83 ms (93.28%) |
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 20617 98711 197511 213205 233618 387186 388022 390839 428710 429825 505454 520524 524604 546674 558726 562232 564576 568651 572112 582321 593196 593261 594871 597725 600822 601115 604461 623633 624067 624703 627212 629552 630777 641319 650968 655241 658121 668174 674245 689908 689943 693454 698814 699642 704222 706433 713085 723848 724168 724991 728877 729789 730078 730855 731094 739959 741764 744791 745991 749845 750671 751780 752852 755367 755495 756223 758310 758511 759711 760358 762879 765308 765997 768392 768834 771166 773151 774215 775617 780906 780968 782710 783210 783265 783297 783375 786431 787182 789474 791678 792547 793894 795743 797477 797824 798956 801309 801407 802613 803018 804257 806139 807134 808249 809295 812801 813026 813856 813895 815569 817039 818723 819181 819803 821374 823475 825526 826125 826678 826680 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (4.11%) |
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 213205 755367 826678 817039 629552 821374 826680 825526 826125 752852 819803 813856 524604 693454 674245 572112 793894 745991 724991 786431 815569 505454 546674 689908 750671 731094 751780 773151 803018 233618 741764 582321 600822 601115 630777 197511 98711 819181 813895 564576 658121 597725 593261 623633 780906 791678 812801 730855 765997 768834 723848 762879 749845 604461 713085 787182 802613 806139 818723 558726 562232 698814 594871 593196 797824 809295 783265 783375 789474 801309 804257 758310 758511 760358 783210 797477 755495 765308 771166 706433 428710 780968 823475 689943 650968 668174 699642 655241 641319 624067 624703 627212 795743 807134 808249 813026 724168 729789 730078 782710 792547 798956 801407 744791 756223 774215 728877 759711 768392 739959 775617 783297 387186 20617 429825 388022 704222 390839 520524 568651 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.73%) |
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 20617 98711 197511 213205 233618 387186 388022 390839 428710 429825 505454 520524 524604 546674 558726 562232 564576 568651 572112 582321 593196 593261 594871 597725 600822 601115 604461 623633 624067 624703 627212 629552 630777 641319 650968 655241 658121 668174 674245 689908 689943 693454 698814 699642 704222 706433 713085 723848 724168 724991 728877 729789 730078 730855 731094 739959 741764 744791 745991 749845 750671 751780 752852 755367 755495 756223 758310 758511 759711 760358 762879 765308 765997 768392 768834 771166 773151 774215 775617 780906 780968 782710 783210 783265 783297 783375 786431 787182 789474 791678 792547 793894 795743 797477 797824 798956 801309 801407 802613 803018 804257 806139 807134 808249 809295 812801 813026 813856 813895 815569 817039 818723 819181 819803 821374 823475 825526 826125 826678 826680 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot and sexy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot sexy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot sexy"
]
|
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.