Query Metrics
7
Database Queries
7
Different statements
163.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.11 ms (81.44%) |
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 160233 385680 391623 393761 395284 395550 397329 398004 398132 400126 402027 418282 418649 419808 421189 422642 422716 423444 424932 424995 424996 425513 427314 432451 432532 432538 432580 432711 433218 433358 433748 434017 434661 435174 441366 442469 442482 444067 447413 448340 451447 453018 454929 455574 457146 457346 459865 459866 459872 460247 468625 470284 482650 483251 484404 485456 489613 491573 495142 495358 505286 517023 517634 525287 527997 528027 548237 550440 551132 554506 560038 574049 582297 585098 589045 589989 598836 600977 604384 610021 610567 610808 614781 616807 617086 618398 618586 626394 644189 652852 695831 696109 703268 706286 709449 714199 714463 721579 723542 736291 736353 737848 738442 741286 742526 745673 748981 760117 760938 761467 765265 769380 771335 772449 772684 779450 789253 800538 809687 810382 ] |
||||||||||||||||||||||||||||||
|
21.75 ms (13.31%) |
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 616807 589989 604384 610021 618398 800538 810382 760117 765265 769380 772449 772684 736353 738442 745673 771335 736291 748981 761467 626394 703268 402027 391623 397329 421189 457146 418282 423444 434017 448340 457346 468625 433358 489613 495358 527997 528027 525287 160233 393761 395284 398004 398132 400126 434661 424932 432711 424996 419808 427314 442469 442482 585098 723542 455574 453018 495142 517634 470284 548237 554506 550440 551132 560038 574049 652852 695831 696109 714199 721579 709449 714463 582297 600977 610567 644189 589045 610808 598836 614781 618586 779450 809687 737848 742526 741286 760938 617086 706286 789253 395550 422642 425513 432538 433748 459872 422716 432451 432532 432580 444067 433218 459866 460247 484404 517023 485456 505286 491573 385680 424995 435174 441366 418649 482650 483251 451447 459865 447413 454929 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
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 160233 385680 391623 393761 395284 395550 397329 398004 398132 400126 402027 418282 418649 419808 421189 422642 422716 423444 424932 424995 424996 425513 427314 432451 432532 432538 432580 432711 433218 433358 433748 434017 434661 435174 441366 442469 442482 444067 447413 448340 451447 453018 454929 455574 457146 457346 459865 459866 459872 460247 468625 470284 482650 483251 484404 485456 489613 491573 495142 495358 505286 517023 517634 525287 527997 528027 548237 550440 551132 554506 560038 574049 582297 585098 589045 589989 598836 600977 604384 610021 610567 610808 614781 616807 617086 618398 618586 626394 644189 652852 695831 696109 703268 706286 709449 714199 714463 721579 723542 736291 736353 737848 738442 741286 742526 745673 748981 760117 760938 761467 765265 769380 771335 772449 772684 779450 789253 800538 809687 810382 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen step"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen step"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen step"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
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.