Query Metrics
7
Database Queries
7
Different statements
214.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.51 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.93 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рыжая с ванн"
]
|
||||||||||||||||||||||||||||||
| 3 | 10.51 ms |
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 521244 444612 815594 452146 523727 546372 672713 677038 658907 695117 558514 576213 615835 612839 615819 801280 808621 519958 527360 497749 608771 400991 523370 663348 647609 578680 810765 730352 641377 419674 439682 421820 454563 489542 491747 519309 417406 465335 490894 742635 422582 469539 448314 534324 677973 716147 574869 628314 602964 811466 752158 400995 462695 491078 487315 802756 431046 442726 602960 603128 442946 430836 469774 493176 472311 510668 488301 541759 551069 581432 726527 541821 511282 522957 566082 599987 598954 430404 527447 528030 567050 535486 542917 565675 425520 544038 554358 460742 460750 499852 ] |
||||||||||||||||||||||||||||||
| 4 | 2.44 ms |
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 400991 400995 417406 419674 421820 422582 425520 430404 430836 431046 439682 442726 442946 444612 448314 452146 454563 460742 460750 462695 465335 469539 469774 472311 487315 488301 489542 490894 491078 491747 493176 497749 499852 510668 511282 519309 519958 521244 522957 523370 523727 527360 527447 528030 534324 535486 541759 541821 542917 544038 546372 551069 554358 558514 565675 566082 567050 574869 576213 578680 581432 598954 599987 602960 602964 603128 608771 612839 615819 615835 628314 641377 647609 658907 663348 672713 677038 677973 695117 716147 726527 730352 742635 752158 801280 802756 808621 810765 811466 815594 ] |
||||||||||||||||||||||||||||||
| 5 | 195.35 ms |
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 400991 400995 417406 419674 421820 422582 425520 430404 430836 431046 439682 442726 442946 444612 448314 452146 454563 460742 460750 462695 465335 469539 469774 472311 487315 488301 489542 490894 491078 491747 493176 497749 499852 510668 511282 519309 519958 521244 522957 523370 523727 527360 527447 528030 534324 535486 541759 541821 542917 544038 546372 551069 554358 558514 565675 566082 567050 574869 576213 578680 581432 598954 599987 602960 602964 603128 608771 612839 615819 615835 628314 641377 647609 658907 663348 672713 677038 677973 695117 716147 726527 730352 742635 752158 801280 802756 808621 810765 811466 815594 ] |
||||||||||||||||||||||||||||||
| 6 | 1.71 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая ван"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.31 ms |
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.