Query Metrics
7
Database Queries
7
Different statements
170.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.30 ms (85.75%) |
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 385680 394532 395550 395661 403031 408326 408437 417339 418649 422642 422716 424995 425513 432437 432451 432477 432479 432496 432530 432532 432538 432580 432624 433218 433461 433572 433599 433742 433748 434093 434220 435174 441366 442416 443310 444067 446220 447413 448341 451447 454929 455787 459865 459866 459872 459896 460247 482650 483251 484404 485456 491573 502604 505286 505399 514272 517023 519275 523422 525591 526785 532826 533522 534494 542021 548842 555851 557361 558055 559687 559856 560038 566939 569414 573402 574049 576990 577468 579848 582297 589045 589108 590118 590382 592311 598836 600977 604330 604338 610567 610808 614781 617086 618586 631948 644189 652852 695831 696109 696128 698289 702077 704560 706280 706286 709449 714199 714463 720922 721579 731279 736920 737848 741286 742526 760938 761574 779450 789253 809687 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (8.83%) |
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 560038 574049 702077 652852 695831 696109 714199 721579 709449 714463 548842 582297 600977 610567 644189 589045 590118 610808 598836 614781 618586 779450 809687 737848 742526 741286 760938 617086 706286 789253 432437 432530 434220 395550 408437 422642 425513 432538 433748 459872 422716 432451 432532 432580 433461 443310 444067 403031 432624 433218 433599 434093 459866 432496 433742 442416 460247 484404 517023 519275 485456 505286 514272 491573 385680 408326 424995 435174 441366 418649 482650 459896 483251 451447 459865 446220 447413 454929 534494 502604 525591 532826 523422 505399 526785 533522 542021 555851 557361 569414 573402 576990 566939 704560 696128 698289 558055 559687 559856 577468 579848 604330 590382 589108 604338 592311 761574 731279 736920 631948 706280 720922 394532 395661 417339 432477 432479 433572 448341 455787 ] |
||||||||||||||||||||||||||||||
|
2.53 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 385680 394532 395550 395661 403031 408326 408437 417339 418649 422642 422716 424995 425513 432437 432451 432477 432479 432496 432530 432532 432538 432580 432624 433218 433461 433572 433599 433742 433748 434093 434220 435174 441366 442416 443310 444067 446220 447413 448341 451447 454929 455787 459865 459866 459872 459896 460247 482650 483251 484404 485456 491573 502604 505286 505399 514272 517023 519275 523422 525591 526785 532826 533522 534494 542021 548842 555851 557361 558055 559687 559856 560038 566939 569414 573402 574049 576990 577468 579848 582297 589045 589108 590118 590382 592311 598836 600977 604330 604338 610567 610808 614781 617086 618586 631948 644189 652852 695831 696109 696128 698289 702077 704560 706280 706286 709449 714199 714463 720922 721579 731279 736920 737848 741286 742526 760938 761574 779450 789253 809687 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step teen"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step teen"
]
|
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.