Query Metrics
7
Database Queries
7
Different statements
165.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.52 ms (84.97%) |
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 6768 125762 329464 381921 384518 385548 386662 387085 391372 392207 395306 395563 396051 396467 399088 399853 400841 400982 401989 402020 411443 413135 417739 417744 428610 429439 430809 432797 433089 436577 438830 441442 443467 445854 446361 446645 447109 447140 448824 451529 451749 451755 452987 453468 453825 454090 455937 456930 458206 458921 461743 463882 464696 466484 473756 473773 473967 475451 477883 482538 483902 485306 487862 494526 495824 497976 499121 499774 501155 501723 505454 505977 508204 510687 512306 512879 516019 518929 522188 527927 529708 530632 530697 533016 533049 533660 533696 533986 536253 537881 537891 538272 538812 542245 565277 600659 631003 631009 633918 706667 707093 719947 722234 723914 727288 739879 739882 747988 753824 757639 761718 769924 783386 802765 808317 820806 823045 823972 828589 828849 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (9.74%) |
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 719947 329464 499774 565277 413135 458206 483902 477883 448824 529708 473756 722234 802765 723914 769924 429439 438830 456930 411443 385548 384518 125762 6768 396467 402020 820806 823045 823972 828849 828589 455937 466484 505454 516019 533986 501155 538812 538272 542245 706667 600659 631003 631009 633918 783386 808317 753824 727288 757639 739879 739882 747988 761718 707093 387085 386662 395306 395563 392207 381921 391372 396051 399088 399853 400841 400982 401989 417739 428610 430809 441442 432797 433089 417744 436577 443467 445854 446645 451529 451749 451755 453468 463882 475451 487862 446361 447109 453825 464696 473773 482538 447140 452987 454090 458921 461743 473967 485306 497976 501723 505977 518929 530697 495824 499121 512306 512879 530632 533016 533660 537881 510687 533049 533696 494526 508204 522188 527927 536253 537891 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.41%) |
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 6768 125762 329464 381921 384518 385548 386662 387085 391372 392207 395306 395563 396051 396467 399088 399853 400841 400982 401989 402020 411443 413135 417739 417744 428610 429439 430809 432797 433089 436577 438830 441442 443467 445854 446361 446645 447109 447140 448824 451529 451749 451755 452987 453468 453825 454090 455937 456930 458206 458921 461743 463882 464696 466484 473756 473773 473967 475451 477883 482538 483902 485306 487862 494526 495824 497976 499121 499774 501155 501723 505454 505977 508204 510687 512306 512879 516019 518929 522188 527927 529708 530632 530697 533016 533049 533660 533696 533986 536253 537881 537891 538272 538812 542245 565277 600659 631003 631009 633918 706667 707093 719947 722234 723914 727288 739879 739882 747988 753824 757639 761718 769924 783386 802765 808317 820806 823045 823972 828589 828849 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen white"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen white"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen white"
]
|
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.