Query Metrics
7
Database Queries
7
Different statements
179.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.69 ms (84.60%) |
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 394130 396501 401558 406780 420363 424955 425065 436573 437297 438809 457512 463426 471860 473345 473738 478665 489248 489627 499771 507513 513464 513551 514090 514377 514982 518177 518391 521432 522148 524479 524748 525039 526265 527523 528951 529553 529564 529715 530755 534178 536388 538259 538779 539538 540917 541377 541730 543639 544397 545198 551431 552535 553722 556174 556198 557847 558205 560668 561818 564705 564778 566735 567122 569981 573191 576307 577816 579236 580157 582348 584576 584913 585842 594339 602581 603603 605850 609899 618447 620196 621029 624920 628258 630250 636156 640792 641070 641088 642323 649860 649869 649885 656804 659389 666356 669251 671392 673807 677021 680141 680197 682936 687432 690450 691026 693281 697135 699237 699624 699738 706656 712695 714761 723167 817722 818523 818797 820410 822306 823092 ] |
||||||||||||||||||||||||||||||
|
16.75 ms (9.34%) |
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 473738 551431 552535 569981 577816 560668 584913 561818 558205 641088 641070 436573 437297 438809 457512 406780 425065 471860 473345 478665 424955 463426 499771 513464 514377 518391 524479 529564 489627 507513 529553 534178 514090 513551 514982 521432 524748 536388 564705 680197 394130 396501 401558 420363 817722 818797 820410 823092 818523 822306 489248 529715 539538 518177 522148 528951 530755 525039 526265 527523 538779 538259 540917 544397 556198 564778 580157 541730 553722 556174 541377 543639 545198 573191 579236 649860 659389 673807 680141 687432 690450 699738 649869 656804 669251 671392 677021 693281 699237 699624 706656 712695 714761 649885 666356 682936 691026 697135 723167 557847 566735 567122 576307 582348 584576 594339 605850 620196 624920 630250 636156 640792 602581 603603 618447 642323 585842 609899 621029 628258 ] |
||||||||||||||||||||||||||||||
|
2.97 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 394130 396501 401558 406780 420363 424955 425065 436573 437297 438809 457512 463426 471860 473345 473738 478665 489248 489627 499771 507513 513464 513551 514090 514377 514982 518177 518391 521432 522148 524479 524748 525039 526265 527523 528951 529553 529564 529715 530755 534178 536388 538259 538779 539538 540917 541377 541730 543639 544397 545198 551431 552535 553722 556174 556198 557847 558205 560668 561818 564705 564778 566735 567122 569981 573191 576307 577816 579236 580157 582348 584576 584913 585842 594339 602581 603603 605850 609899 618447 620196 621029 624920 628258 630250 636156 640792 641070 641088 642323 649860 649869 649885 656804 659389 666356 669251 671392 673807 677021 680141 680197 682936 687432 690450 691026 693281 697135 699237 699624 699738 706656 712695 714761 723167 817722 818523 818797 820410 822306 823092 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sport teen"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная teen"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спортивная teen"
]
|
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.