Query Metrics
7
Database Queries
7
Different statements
144.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.95 ms (83.46%) |
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 154157 387408 388080 389492 393313 394282 395934 403549 415511 436419 436982 437104 440372 457942 468112 478239 486247 491875 495508 523365 525734 527486 527511 527517 527521 529066 530856 532552 534036 551908 564261 583626 587094 587390 591999 593149 593562 596924 604002 606315 610538 612083 612586 617142 619262 630428 635883 648671 654205 659172 666046 669345 670578 679241 697656 702065 721771 721959 722179 723017 724803 724933 725005 725106 725285 725301 726881 727501 728964 729610 735006 735207 739402 739417 742790 748343 748540 748669 749943 758306 759382 759836 763819 765160 765898 769472 771291 774800 776206 787418 791281 791653 792601 793778 796613 799668 799836 800076 800107 801407 801438 802316 805037 806032 806627 811915 811926 812863 815418 816990 817787 818010 818825 819947 821062 822263 823760 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (9.90%) |
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 659172 697656 593562 593149 604002 612586 774800 793778 799836 800076 811926 799668 806627 724803 725213 735207 748540 758306 801407 728964 726881 739417 735006 769574 721771 721959 722179 787418 389492 387408 495508 154157 403549 436982 436419 818010 818825 816990 819947 822263 815418 821062 457942 468112 525734 527517 529066 530856 527511 534036 523365 527521 532552 564261 551908 583626 654205 679241 723017 648671 666046 669345 670578 702065 587390 606315 591999 619262 635883 587094 596924 610538 612083 617142 630428 791281 802316 805037 803361 725005 725106 725285 725301 727501 729610 748669 765160 792601 800107 801438 724933 748343 759382 759836 769472 739402 742790 749943 763819 765898 771291 776206 791653 796613 806032 811915 812863 415511 478239 394282 393313 395934 388080 440372 437104 823760 817787 491875 486247 527486 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.06%) |
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 154157 387408 388080 389492 393313 394282 395934 403549 415511 436419 436982 437104 440372 457942 468112 478239 486247 491875 495508 523365 525734 527486 527511 527517 527521 529066 530856 532552 534036 551908 564261 583626 587094 587390 591999 593149 593562 596924 604002 606315 610538 612083 612586 617142 619262 630428 635883 648671 654205 659172 666046 669345 670578 679241 697656 702065 721771 721959 722179 723017 724803 724933 725005 725106 725285 725301 726881 727501 728964 729610 735006 735207 739402 739417 742790 748343 748540 748669 749943 758306 759382 759836 763819 765160 765898 769472 771291 774800 776206 787418 791281 791653 792601 793778 796613 799668 799836 800076 800107 801407 801438 802316 805037 806032 806627 811915 811926 812863 815418 816990 817787 818010 818825 819947 821062 822263 823760 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"does"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"does"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"does"
]
|
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.