Query Metrics
7
Database Queries
7
Different statements
196.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.55 ms (86.89%) |
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 2291 13428 31015 45799 188389 188462 188501 233617 345630 388500 390045 390508 390794 391917 394152 396981 397167 411688 417789 418954 420300 420903 421795 423095 424118 424124 424547 424765 425984 428115 428610 428840 432438 440755 442070 446750 450287 452189 452810 453323 453334 453562 453571 453719 454461 454958 460368 461902 462605 462707 467016 467837 469393 472403 473376 473384 479261 480903 481747 484181 484561 491860 492005 496512 501553 502827 505833 507167 508422 508653 510334 517705 518399 518975 519333 519751 520114 522211 522218 522486 524803 524991 528581 529166 531566 532341 536430 541850 543404 544109 549689 549727 557605 558755 561506 563724 565632 570177 573196 581013 582262 602704 602753 607576 613117 630142 650664 664241 665113 665142 668807 690882 728009 728469 730994 748521 749248 758278 766248 815051 ] |
||||||||||||||||||||||||||||||
|
15.84 ms (8.07%) |
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 730994 758278 728009 748521 728469 749248 766248 602704 602753 607576 613117 630142 233617 394152 462605 188462 2291 421795 424118 462707 467016 479261 345630 418954 428840 452810 472403 188389 388500 390794 440755 453562 454461 467837 473376 480903 424124 481747 510334 520114 484181 502827 519751 496512 518399 522211 508653 519333 522218 524991 528581 536430 188501 391917 45799 13428 31015 390045 390508 396981 397167 411688 423095 428610 432438 442070 425984 428115 417789 420300 420903 424547 424765 815051 450287 453323 446750 453719 461902 473384 491860 492005 452189 453334 453571 454958 469393 484561 507167 505833 517705 531566 532341 508422 524803 501553 518975 522486 529166 460368 549689 549727 558755 561506 565632 570177 581013 582262 541850 543404 544109 563724 573196 557605 650664 664241 668807 665113 690882 665142 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.48%) |
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 2291 13428 31015 45799 188389 188462 188501 233617 345630 388500 390045 390508 390794 391917 394152 396981 397167 411688 417789 418954 420300 420903 421795 423095 424118 424124 424547 424765 425984 428115 428610 428840 432438 440755 442070 446750 450287 452189 452810 453323 453334 453562 453571 453719 454461 454958 460368 461902 462605 462707 467016 467837 469393 472403 473376 473384 479261 480903 481747 484181 484561 491860 492005 496512 501553 502827 505833 507167 508422 508653 510334 517705 518399 518975 519333 519751 520114 522211 522218 522486 524803 524991 528581 529166 531566 532341 536430 541850 543404 544109 549689 549727 557605 558755 561506 563724 565632 570177 573196 581013 582262 602704 602753 607576 613117 630142 650664 664241 665113 665142 668807 690882 728009 728469 730994 748521 749248 758278 766248 815051 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding chubby"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding chubby"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding chubby"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.