Query Metrics
7
Database Queries
7
Different statements
159.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.50 ms (84.21%) |
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 414123 417822 417893 419876 419892 424783 425083 425207 428410 433995 444746 449563 451872 453192 456110 457672 457936 458625 460261 461637 463092 464145 465106 465114 465117 468062 468469 468704 469001 469986 472603 473064 477077 478487 482711 484528 491465 494997 496378 497681 497687 502705 505092 505094 505102 519810 520137 522396 523573 528102 531611 532487 535532 535841 536757 537860 538031 539518 540068 540301 543154 544779 547080 548102 564304 564392 568228 573308 574117 579448 583953 584731 585270 586692 590794 591936 596116 599876 600832 602070 604457 604466 604495 604531 604681 606503 607126 610029 614990 622716 634553 636574 636576 645990 647629 649187 649857 649964 651613 655832 674043 681297 687881 693155 694632 699347 700169 704187 708279 708923 715089 715371 718945 719832 720116 720306 814634 818284 825044 825237 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (8.72%) |
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 414123 433995 419876 424783 425083 419892 425207 417822 417893 428410 444746 814634 818284 825044 825237 451872 456110 457936 468469 477077 484528 491465 449563 453192 468062 482711 457672 458625 461637 463092 465114 465117 472603 473064 478487 497687 502705 505094 535532 537860 494997 497681 505102 531611 540068 496378 505092 520137 522396 528102 536757 538031 539518 540301 519810 523573 532487 535841 460261 464145 465106 468704 469001 469986 544779 564392 547080 548102 574117 579448 584731 543154 564304 583953 645990 649857 649964 681297 704187 715089 649187 651613 655832 687881 693155 700169 708923 720116 647629 674043 694632 699347 708279 715371 718945 719832 720306 568228 573308 585270 590794 596116 604457 604466 604531 604681 606503 607126 622716 636574 591936 602070 604495 610029 614990 634553 636576 586692 599876 600832 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.16%) |
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 414123 417822 417893 419876 419892 424783 425083 425207 428410 433995 444746 449563 451872 453192 456110 457672 457936 458625 460261 461637 463092 464145 465106 465114 465117 468062 468469 468704 469001 469986 472603 473064 477077 478487 482711 484528 491465 494997 496378 497681 497687 502705 505092 505094 505102 519810 520137 522396 523573 528102 531611 532487 535532 535841 536757 537860 538031 539518 540068 540301 543154 544779 547080 548102 564304 564392 568228 573308 574117 579448 583953 584731 585270 586692 590794 591936 596116 599876 600832 602070 604457 604466 604495 604531 604681 606503 607126 610029 614990 622716 634553 636574 636576 645990 647629 649187 649857 649964 651613 655832 674043 681297 687881 693155 694632 699347 700169 704187 708279 708923 715089 715371 718945 719832 720116 720306 814634 818284 825044 825237 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc then"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc"
]
|
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.