Query Metrics
7
Database Queries
7
Different statements
149.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.72 ms (85.18%) |
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 122190 182749 192691 198857 341691 393326 395718 398643 445416 454984 458277 463398 467581 489280 491776 500971 513511 530295 530377 531849 533432 537797 537888 540559 541064 544713 545389 545409 545410 545488 547961 547983 548882 548889 554816 555481 563407 564554 566786 586886 594604 602966 609906 612976 617427 619307 620471 632601 632632 634198 646224 650373 651317 652132 652850 653051 653600 654097 655586 659856 664481 664517 673526 677784 680100 680176 680615 681515 685775 687381 690000 692261 693147 694127 695923 696331 698449 704991 708494 713113 714279 714281 715743 717066 720834 722945 730246 734412 734591 734839 737997 738556 740578 743888 744390 745311 745907 745936 755191 767036 767546 771282 773183 777876 782439 783006 784414 792480 792710 792753 793262 796430 808298 817139 817624 820672 822304 823345 823721 825706 ] |
||||||||||||||||||||||||||||||
|
12.68 ms (8.45%) |
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 632601 609906 454984 467581 489280 491776 198857 192691 817139 825706 823345 458277 531849 533432 544713 563407 547983 554816 541064 664481 673526 680615 687381 692261 653600 694127 722945 655586 685775 690000 696331 714279 720834 548882 594604 619307 612976 620471 784414 808298 782439 783006 792753 793262 734839 767546 771282 792480 792710 796430 734412 737997 745907 767036 738556 743888 744390 740578 773183 730246 734591 745311 745936 698449 717066 777876 632632 445416 530377 537888 500971 540559 545389 545409 545410 545488 566786 680100 677784 680176 586886 634198 602966 617427 395718 755191 122190 393326 341691 182749 398643 817624 823721 822304 820672 463398 513511 530295 537797 555481 547961 564554 548889 646224 650373 652132 654097 681515 693147 695923 704991 708494 714281 651317 664517 713113 715743 652850 653051 659856 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.66%) |
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 122190 182749 192691 198857 341691 393326 395718 398643 445416 454984 458277 463398 467581 489280 491776 500971 513511 530295 530377 531849 533432 537797 537888 540559 541064 544713 545389 545409 545410 545488 547961 547983 548882 548889 554816 555481 563407 564554 566786 586886 594604 602966 609906 612976 617427 619307 620471 632601 632632 634198 646224 650373 651317 652132 652850 653051 653600 654097 655586 659856 664481 664517 673526 677784 680100 680176 680615 681515 685775 687381 690000 692261 693147 694127 695923 696331 698449 704991 708494 713113 714279 714281 715743 717066 720834 722945 730246 734412 734591 734839 737997 738556 740578 743888 744390 745311 745907 745936 755191 767036 767546 771282 773183 777876 782439 783006 784414 792480 792710 792753 793262 796430 808298 817139 817624 820672 822304 823345 823721 825706 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens double"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens double"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens double"
]
|
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.