Query Metrics
7
Database Queries
7
Different statements
144.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.86 ms (82.73%) |
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 7008 383633 395354 396792 398676 412442 412508 417643 417693 418617 418645 418656 419027 421658 422032 427699 429214 429219 429229 429231 429235 429237 436608 446793 452395 455933 458649 459255 459538 459711 462135 462306 462834 466635 468116 469102 477543 483051 485864 489144 491193 492496 492498 501776 501784 505416 506577 508276 510836 517862 522732 527314 529101 535703 537475 538523 554093 554164 554251 554722 561897 562435 566071 571163 572261 572943 572972 572982 574089 577845 577883 577889 577895 578342 579691 582064 584162 593172 593977 594008 594057 594079 594093 594095 594261 595941 598208 598881 606223 616481 617203 617672 618465 622472 622675 627121 628063 631470 642270 660310 670566 712509 724556 747310 756861 758847 763536 780561 785292 787911 788294 788407 788936 790933 800846 800854 800856 806877 806884 811829 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (10.41%) |
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 595941 785292 780561 787911 756861 800846 806884 622472 622675 631470 489144 577883 572261 554093 606223 594008 617672 788294 811829 747310 758847 800854 429237 468116 485864 510836 419027 574089 462306 491193 7008 412508 537475 712509 660310 594093 594261 763536 800856 418645 429229 429231 398676 466635 501784 492498 501776 418656 427699 422032 436608 458649 452395 459711 529101 538523 535703 505416 462834 571163 572943 572972 577895 554164 561897 566071 577845 578342 562435 582064 584162 670566 554251 554722 572982 577889 579691 594057 598208 616481 593977 627121 642270 594079 598881 628063 593172 594095 617203 618465 788407 788936 790933 806877 724556 421658 459538 477543 417643 429214 412442 462135 417693 446793 455933 517862 508276 506577 522732 483051 492496 527314 383633 395354 396792 418617 429219 429235 469102 459255 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.17%) |
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 7008 383633 395354 396792 398676 412442 412508 417643 417693 418617 418645 418656 419027 421658 422032 427699 429214 429219 429229 429231 429235 429237 436608 446793 452395 455933 458649 459255 459538 459711 462135 462306 462834 466635 468116 469102 477543 483051 485864 489144 491193 492496 492498 501776 501784 505416 506577 508276 510836 517862 522732 527314 529101 535703 537475 538523 554093 554164 554251 554722 561897 562435 566071 571163 572261 572943 572972 572982 574089 577845 577883 577889 577895 578342 579691 582064 584162 593172 593977 594008 594057 594079 594093 594095 594261 595941 598208 598881 606223 616481 617203 617672 618465 622472 622675 627121 628063 631470 642270 660310 670566 712509 724556 747310 756861 758847 763536 780561 785292 787911 788294 788407 788936 790933 800846 800854 800856 806877 806884 811829 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 year"
]
|
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.