Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.32 ms (83.39%) |
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 67698 68967 70745 143019 214560 230974 362958 381955 383076 384326 390613 397019 398709 403281 411574 428940 441550 447980 452032 452034 452048 454347 494408 501245 504208 515545 533622 534215 534795 543832 543858 548226 548888 550750 553206 558367 559863 595754 619427 622042 622045 622654 622658 628380 628389 631166 632713 632803 633879 634819 635789 637049 638963 654473 654486 655344 659314 660876 661905 664481 668155 668389 669157 670038 671729 672419 674131 680195 681135 683435 683802 690049 690321 696331 701964 705882 709306 714815 716715 718994 720058 723605 731950 735933 741102 741152 741244 749817 753166 758204 761547 775930 775949 776013 776017 776025 776572 787949 790973 792562 796430 796983 801149 802561 804111 805019 805673 808253 811437 813640 817464 818533 818537 820350 821122 821468 821609 821720 822305 827947 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (9.32%) |
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 674131 718994 632803 619427 622042 631166 776013 775949 805019 741244 749817 735933 622045 632713 705882 804111 143019 381955 452034 452048 534215 543832 543858 548226 595754 628389 452032 533622 504208 818537 494408 683802 683435 776025 731950 68967 384326 214560 230974 70745 390613 441550 818533 813640 723605 822305 817464 821122 821720 820350 821468 821609 827947 447980 501245 534795 558367 559863 548888 655344 659314 664481 668155 671729 672419 690321 701964 720058 654473 654486 660876 661905 668389 670038 681135 690049 716715 669157 696331 550750 553206 633879 635789 622654 776017 776572 808253 811437 753166 790973 796430 801149 805673 741102 741152 758204 761547 622658 634819 638963 709306 714815 775930 787949 792562 796983 802561 398709 362958 67698 411574 383076 403281 454347 515545 680195 637049 628380 397019 428940 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.95%) |
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 67698 68967 70745 143019 214560 230974 362958 381955 383076 384326 390613 397019 398709 403281 411574 428940 441550 447980 452032 452034 452048 454347 494408 501245 504208 515545 533622 534215 534795 543832 543858 548226 548888 550750 553206 558367 559863 595754 619427 622042 622045 622654 622658 628380 628389 631166 632713 632803 633879 634819 635789 637049 638963 654473 654486 655344 659314 660876 661905 664481 668155 668389 669157 670038 671729 672419 674131 680195 681135 683435 683802 690049 690321 696331 701964 705882 709306 714815 716715 718994 720058 723605 731950 735933 741102 741152 741244 749817 753166 758204 761547 775930 775949 776013 776017 776025 776572 787949 790973 792562 796430 796983 801149 802561 804111 805019 805673 808253 811437 813640 817464 818533 818537 820350 821122 821468 821609 821720 822305 827947 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group teens"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group teens"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group teens"
]
|
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.