Query Metrics
7
Database Queries
7
Different statements
186.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.74 ms (85.74%) |
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 7891 403272 410786 414302 414961 418877 420493 420814 425881 432410 444814 444964 445728 446560 452766 453987 455419 456368 457012 459872 460431 460850 461893 462362 462996 464627 477743 479931 479953 481947 482888 486278 496169 497201 499868 504008 505304 511245 511453 516252 518883 522943 524064 524368 525452 528741 529542 536430 542921 549729 552345 552352 556482 561984 562946 564575 572250 577509 578356 578803 580401 598399 600820 606934 612465 617346 620473 626015 636554 639009 642389 658226 660613 662428 663151 667106 675492 676680 691462 694894 698228 709266 710966 714608 714925 715417 725440 727055 729181 731129 734085 743952 746101 752876 755483 763482 765580 767023 770958 772385 777924 779237 782350 788720 791093 795125 796237 797328 797857 800314 801258 803604 806162 807522 809001 809705 811528 814212 814263 817361 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (8.50%) |
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 770958 743952 767023 709266 795125 800314 811528 7891 460850 444964 814263 504008 698228 663151 714608 556482 600820 612465 777924 779237 796237 797857 809705 731129 755483 710966 715417 420814 814212 817361 453987 455419 499868 528741 562946 577509 658226 660613 691462 694894 561984 598399 606934 788720 807522 772385 791093 806162 729181 752876 763482 725440 727055 620473 782350 797328 803604 410786 432410 414302 452766 403272 444814 456368 481947 518883 497201 511453 524368 425881 462362 464627 457012 479931 461893 529542 505304 486278 572250 542921 580401 662428 676680 675492 714925 552345 552352 564575 642389 734085 746101 765580 809001 459872 462996 479953 414961 522943 536430 482888 516252 460431 549729 578356 578803 667106 639009 626015 617346 801258 636554 477743 418877 446560 525452 496169 511245 420493 445728 524064 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.66%) |
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 7891 403272 410786 414302 414961 418877 420493 420814 425881 432410 444814 444964 445728 446560 452766 453987 455419 456368 457012 459872 460431 460850 461893 462362 462996 464627 477743 479931 479953 481947 482888 486278 496169 497201 499868 504008 505304 511245 511453 516252 518883 522943 524064 524368 525452 528741 529542 536430 542921 549729 552345 552352 556482 561984 562946 564575 572250 577509 578356 578803 580401 598399 600820 606934 612465 617346 620473 626015 636554 639009 642389 658226 660613 662428 663151 667106 675492 676680 691462 694894 698228 709266 710966 714608 714925 715417 725440 727055 729181 731129 734085 743952 746101 752876 755483 763482 765580 767023 770958 772385 777924 779237 782350 788720 791093 795125 796237 797328 797857 800314 801258 803604 806162 807522 809001 809705 811528 814212 814263 817361 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"get cum"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"get cum"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"get cum"
]
|
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.