Query Metrics
7
Database Queries
7
Different statements
188.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.74 ms (84.35%) |
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 389208 406322 416208 418837 422342 424433 424660 443334 443745 443764 443780 444238 445396 446275 448333 451985 452028 453345 456614 457987 459877 460734 461056 462079 462305 463105 464301 466056 466073 466103 466107 466111 467033 467043 468834 472793 473920 474473 474494 474559 474678 474680 474696 476261 476399 479126 482243 483544 484381 484383 484448 484459 484469 484472 484557 484563 484618 484629 484636 484651 484653 484661 484668 484674 484690 484700 484705 484711 484737 487729 492760 496097 496118 497537 498057 499446 499814 501237 501240 501251 501254 502277 502304 502310 502819 503431 504521 506048 506053 510251 510913 518470 522902 523405 524895 527412 531165 533463 533738 534028 536752 537659 539210 541592 541643 545418 546993 549225 550434 559178 559720 576717 601018 601028 602960 659025 674018 674415 814072 823695 ] |
||||||||||||||||||||||||||||||
|
20.15 ms (10.71%) |
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 499814 510251 484448 484469 484557 484563 506053 518470 527412 484472 484711 496118 497537 502304 533463 484459 484618 484674 484690 484700 484705 487729 501254 502819 549225 550434 406322 416208 418837 814072 823695 451985 452028 457987 463105 476399 482243 483544 446275 456614 459877 461056 472793 474473 474559 467043 468834 501237 501251 502310 510913 533738 539210 531165 503431 504521 523405 524895 534028 536752 537659 464301 541592 546993 559720 659025 674415 674018 601018 601028 602960 389208 443764 443780 476261 443334 445396 460734 462079 462305 466073 466107 466111 474494 422342 424433 424660 467033 473920 444238 448333 466056 479126 443745 453345 466103 474678 474680 474696 506048 484381 484629 484636 484651 484737 496097 499446 492760 502277 522902 484383 484653 484661 484668 498057 501240 541643 576717 545418 559178 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.52%) |
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 389208 406322 416208 418837 422342 424433 424660 443334 443745 443764 443780 444238 445396 446275 448333 451985 452028 453345 456614 457987 459877 460734 461056 462079 462305 463105 464301 466056 466073 466103 466107 466111 467033 467043 468834 472793 473920 474473 474494 474559 474678 474680 474696 476261 476399 479126 482243 483544 484381 484383 484448 484459 484469 484472 484557 484563 484618 484629 484636 484651 484653 484661 484668 484674 484690 484700 484705 484711 484737 487729 492760 496097 496118 497537 498057 499446 499814 501237 501240 501251 501254 502277 502304 502310 502819 503431 504521 506048 506053 510251 510913 518470 522902 523405 524895 527412 531165 533463 533738 534028 536752 537659 539210 541592 541643 545418 546993 549225 550434 559178 559720 576717 601018 601028 602960 659025 674018 674415 814072 823695 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young group"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young group"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young group"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.77%) |
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.