Query Metrics
7
Database Queries
7
Different statements
230.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.12 ms (88.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 426431 439838 454151 461543 465843 466131 466677 467347 470140 484278 496037 503220 507649 519001 525214 533514 533661 543637 545809 552086 552514 554068 558042 561696 561707 566231 573515 578360 582548 584797 589472 589899 590394 591747 595433 596306 597861 597987 598438 598751 598985 601277 603475 603876 603948 609900 616000 617211 618925 620233 620661 625206 626293 633120 651864 652602 653265 653504 653548 654392 666562 670456 675531 676453 676531 677014 677322 677333 693841 704215 704916 714444 714629 716804 718688 718690 718784 720434 720621 721419 722264 722522 722535 722591 722594 722596 722624 722627 722812 722895 723629 724285 725149 725390 727289 727852 728226 730724 733856 733873 733880 733910 735821 736101 739052 740617 741281 741518 744937 746983 747367 751900 754141 754589 756672 758986 761474 777570 789845 805721 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (6.58%) |
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 525214 484278 507649 533514 519001 470140 653265 677014 722594 651864 652602 718690 720434 721419 722596 545809 573515 597987 609900 598985 601277 633120 591747 595433 789845 805721 724285 739052 740617 758986 727852 728226 741518 756672 727289 733873 735821 754589 733910 754141 714444 722535 722591 777570 503220 723629 466677 454151 496037 533661 543637 558042 582548 584797 552514 554068 561696 561707 566231 578360 653504 653548 654392 677322 677333 718784 722264 722624 670456 675531 676531 718688 666562 676453 693841 704215 716804 720621 722522 722627 722895 552086 589472 597861 620661 590394 598438 598751 603948 625206 626293 589899 596306 616000 620233 617211 618925 730724 733880 725390 741281 733856 744937 747367 736101 751900 725149 746983 761474 603475 603876 704916 714629 722812 466131 467347 426431 439838 465843 461543 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.47%) |
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 426431 439838 454151 461543 465843 466131 466677 467347 470140 484278 496037 503220 507649 519001 525214 533514 533661 543637 545809 552086 552514 554068 558042 561696 561707 566231 573515 578360 582548 584797 589472 589899 590394 591747 595433 596306 597861 597987 598438 598751 598985 601277 603475 603876 603948 609900 616000 617211 618925 620233 620661 625206 626293 633120 651864 652602 653265 653504 653548 654392 666562 670456 675531 676453 676531 677014 677322 677333 693841 704215 704916 714444 714629 716804 718688 718690 718784 720434 720621 721419 722264 722522 722535 722591 722594 722596 722624 722627 722812 722895 723629 724285 725149 725390 727289 727852 728226 730724 733856 733873 733880 733910 735821 736101 739052 740617 741281 741518 744937 746983 747367 751900 754141 754589 756672 758986 761474 777570 789845 805721 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting russian"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг русск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.