Query Metrics
7
Database Queries
7
Different statements
408.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.98 ms (51.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"having"
]
|
||||||||||||||||||||||||||||||
|
162.18 ms (39.72%) |
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 38452 102086 266061 381855 382519 382954 384397 385064 393537 407783 414050 417102 417758 424271 424350 426694 429568 440485 441967 443161 443509 443856 443985 446689 448340 449544 451225 451831 454661 457701 459161 460406 461228 462297 462762 465905 466918 467314 475537 475772 476963 477796 478721 480888 480934 480980 484115 486810 488324 489273 490183 490310 492154 493103 494499 494862 496396 497524 500215 504171 507189 509881 510671 511337 511653 513880 514210 514449 516196 518068 518287 522750 523177 523433 525160 525221 525904 525982 526362 528274 528461 535897 536207 539106 544752 544766 549782 551873 553122 557439 558174 566264 566839 570414 571218 578207 645240 657271 667052 668279 668676 675200 675233 675960 676008 677369 677677 682478 701051 705118 705346 708775 722812 731130 773262 774794 784592 785536 815543 821043 ] |
||||||||||||||||||||||||||||||
|
26.53 ms (6.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 773262 731130 701051 705118 708775 722812 774794 784592 785536 266061 382519 385064 393537 414050 424350 426694 443161 449544 462297 467314 38452 441967 477796 478721 381855 417758 443856 462762 440485 448340 457701 460406 461228 476963 480934 480980 424271 446689 509881 510671 484115 494499 511337 511653 514210 522750 523433 525982 528274 489273 493103 497524 500215 514449 516196 518068 523177 525160 382954 384397 102086 407783 429568 443509 443985 417102 815543 821043 451831 475537 475772 480888 490310 465905 486810 488324 451225 454661 459161 466918 492154 494862 504171 525221 536207 539106 507189 513880 496396 518287 525904 526362 528461 535897 490183 551873 558174 557439 566264 566839 578207 544752 544766 549782 553122 570414 571218 668676 677369 645240 657271 667052 668279 675200 675960 682478 675233 676008 677677 705346 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.74%) |
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 38452 102086 266061 381855 382519 382954 384397 385064 393537 407783 414050 417102 417758 424271 424350 426694 429568 440485 441967 443161 443509 443856 443985 446689 448340 449544 451225 451831 454661 457701 459161 460406 461228 462297 462762 465905 466918 467314 475537 475772 476963 477796 478721 480888 480934 480980 484115 486810 488324 489273 490183 490310 492154 493103 494499 494862 496396 497524 500215 504171 507189 509881 510671 511337 511653 513880 514210 514449 516196 518068 518287 522750 523177 523433 525160 525221 525904 525982 526362 528274 528461 535897 536207 539106 544752 544766 549782 551873 553122 557439 558174 566264 566839 570414 571218 578207 645240 657271 667052 668279 668676 675200 675233 675960 676008 677369 677677 682478 701051 705118 705346 708775 722812 731130 773262 774794 784592 785536 815543 821043 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"having"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"having"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.