Query Metrics
7
Database Queries
7
Different statements
205.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.95 ms (85.02%) |
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 384042 389803 392704 415926 416448 420700 420804 424770 425948 427497 429155 434336 437193 439135 439345 444204 444487 446473 446986 448572 448902 450268 450392 451695 454133 456397 457054 457577 458870 459334 459339 460816 465065 466645 466860 466909 473738 473838 474312 475593 478514 483478 483737 485297 488797 489067 490592 492695 493788 495550 497690 499484 501475 502630 510573 512225 514986 515992 518185 523571 527832 532442 532603 533917 534413 536105 537319 537492 538354 541409 542096 542706 547757 555037 561905 564641 564955 565298 567106 567334 570415 579418 582438 583027 584486 585788 587912 595572 595646 600242 601695 604767 606076 616013 652886 659199 669907 669936 680709 684666 688148 710357 723681 730871 730875 740407 750426 750637 751418 751692 756840 766415 774708 776141 781849 782057 784871 791385 793022 797068 ] |
||||||||||||||||||||||||||||||
|
20.98 ms (10.20%) |
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 776141 782057 797068 793022 750637 730875 750426 723681 730871 740407 751418 751692 710357 791385 439345 448572 451695 384042 392704 420700 448902 466645 444204 456397 437193 454133 459334 501475 502630 489067 492695 495550 514986 483478 499484 515992 527832 564955 616013 389803 429155 415926 595572 466909 473838 474312 457054 465065 534413 536105 537319 532442 537492 579418 584486 542706 564641 565298 567106 570415 583027 542096 555037 652886 669907 669936 688148 659199 547757 595646 585788 601695 604767 600242 766415 781849 458870 425948 460816 475593 420804 446986 450392 518185 488797 523571 532603 490592 434336 439135 424770 444487 459339 446473 457577 538354 510573 466860 473738 541409 567334 582438 680709 684666 561905 606076 587912 756840 774708 784871 427497 450268 485297 493788 512225 416448 478514 483737 497690 533917 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.38%) |
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 384042 389803 392704 415926 416448 420700 420804 424770 425948 427497 429155 434336 437193 439135 439345 444204 444487 446473 446986 448572 448902 450268 450392 451695 454133 456397 457054 457577 458870 459334 459339 460816 465065 466645 466860 466909 473738 473838 474312 475593 478514 483478 483737 485297 488797 489067 490592 492695 493788 495550 497690 499484 501475 502630 510573 512225 514986 515992 518185 523571 527832 532442 532603 533917 534413 536105 537319 537492 538354 541409 542096 542706 547757 555037 561905 564641 564955 565298 567106 567334 570415 579418 582438 583027 584486 585788 587912 595572 595646 600242 601695 604767 606076 616013 652886 659199 669907 669936 680709 684666 688148 710357 723681 730871 730875 740407 750426 750637 751418 751692 756840 766415 774708 776141 781849 782057 784871 791385 793022 797068 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute solo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute соло"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute соло"
]
|
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.