Query Metrics
7
Database Queries
7
Different statements
152.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.21 ms (84.93%) |
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 4450 129916 390134 391677 391761 396312 399062 410146 412574 418347 418620 418662 422027 429095 429257 455145 456262 462650 464145 475058 475541 479815 481231 494896 501746 505110 509600 525443 525658 529056 547694 550491 551394 554249 557792 559078 561013 562437 572718 572719 574198 574280 577819 577865 579001 589725 589735 591180 591393 593998 594014 594018 594066 594077 597259 598991 601871 610504 620716 622531 622565 625134 628828 640050 644493 660845 661702 665588 666730 672269 673229 673860 673877 676927 686210 687913 689442 701967 708667 709228 714580 720096 723935 725098 725141 731060 732775 735446 735647 736022 736980 739318 740597 742507 748416 748632 749294 754205 755854 758560 760313 760330 765347 769405 771013 771765 775148 787506 788440 788672 789786 790256 793575 804862 805346 806868 810728 812844 813476 814487 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (8.95%) |
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 390134 399062 418662 412574 462650 455145 525443 479815 554249 559078 561013 557792 562437 661702 666730 686210 673860 687913 720096 708667 594066 589735 622531 589725 622565 628828 788672 789786 813476 775148 812844 788440 793575 810728 749294 760330 735446 765347 725098 620716 701967 475541 481231 391761 418347 418620 475058 129916 410146 814487 547694 673229 672269 551394 594077 771013 4450 429095 456262 505110 501746 396312 422027 529056 577865 665588 673877 709228 574280 577819 601871 640050 598991 644493 593998 594018 625134 790256 806868 735647 771765 714580 787506 574198 572718 572719 660845 591180 731060 742507 760313 769405 494896 550491 754205 464145 676927 597259 594014 805346 736022 736980 755854 732775 748632 429257 525658 509600 689442 579001 610504 591393 804862 725141 758560 723935 740597 739318 748416 391677 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.72%) |
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 4450 129916 390134 391677 391761 396312 399062 410146 412574 418347 418620 418662 422027 429095 429257 455145 456262 462650 464145 475058 475541 479815 481231 494896 501746 505110 509600 525443 525658 529056 547694 550491 551394 554249 557792 559078 561013 562437 572718 572719 574198 574280 577819 577865 579001 589725 589735 591180 591393 593998 594014 594018 594066 594077 597259 598991 601871 610504 620716 622531 622565 625134 628828 640050 644493 660845 661702 665588 666730 672269 673229 673860 673877 676927 686210 687913 689442 701967 708667 709228 714580 720096 723935 725098 725141 731060 732775 735446 735647 736022 736980 739318 740597 742507 748416 748632 749294 754205 755854 758560 760313 760330 765347 769405 771013 771765 775148 787506 788440 788672 789786 790256 793575 804862 805346 806868 810728 812844 813476 814487 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.83%) |
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.