Query Metrics
7
Database Queries
7
Different statements
236.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.31 ms (90.30%) |
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 8064 9637 12708 34409 50344 80999 92130 97450 107874 135519 157046 163135 191474 191835 237173 268633 300296 310133 353299 357302 382027 382215 383053 384258 384480 384514 385045 385599 386385 387132 387374 391607 392890 393308 395940 397473 397663 398799 400331 400406 401388 402619 403866 405775 412732 414005 414223 415529 418565 422408 422731 429472 437390 443144 462244 468343 470690 478513 484056 487982 494626 510928 511593 512641 611985 702910 715701 724923 725332 725792 728090 729348 740119 742626 742822 745792 746230 746385 752081 753877 755855 756198 756320 757641 759630 762693 764067 764632 766380 769833 773126 773852 774225 774558 777710 779613 782086 791825 791848 791954 794630 796216 796935 801480 802874 803332 810901 814575 814641 814920 815698 818381 818977 821097 821587 823156 823320 823677 828451 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (5.53%) |
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 791848 794630 802874 803332 724923 725332 742822 756198 764067 774225 745792 755855 773126 729348 752081 759630 762693 764632 766380 773852 725792 728090 740119 742626 746230 746385 753877 756320 757641 769833 611985 627511 702910 715701 774558 777710 779613 782086 791825 791954 796216 796935 801480 810901 8064 163135 382027 384514 405775 353299 395940 387374 412732 50344 384480 392890 422731 470690 512641 386385 385599 384258 385045 383053 237173 135519 157046 191474 191835 107874 393308 391607 268633 310133 357302 300296 382215 34409 12708 9637 80999 92130 97450 387132 397473 397663 400406 400331 398799 402619 401388 403866 422408 429472 437390 414223 415529 414005 418565 443144 821587 823320 823677 814920 815698 818977 823156 818381 814575 814641 821097 828451 487982 478513 484056 462244 468343 494626 510928 511593 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.17%) |
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 8064 9637 12708 34409 50344 80999 92130 97450 107874 135519 157046 163135 191474 191835 237173 268633 300296 310133 353299 357302 382027 382215 383053 384258 384480 384514 385045 385599 386385 387132 387374 391607 392890 393308 395940 397473 397663 398799 400331 400406 401388 402619 403866 405775 412732 414005 414223 415529 418565 422408 422731 429472 437390 443144 462244 468343 470690 478513 484056 487982 494626 510928 511593 512641 611985 702910 715701 724923 725332 725792 728090 729348 740119 742626 742822 745792 746230 746385 752081 753877 755855 756198 756320 757641 759630 762693 764067 764632 766380 769833 773126 773852 774225 774558 777710 779613 782086 791825 791848 791954 794630 796216 796935 801480 802874 803332 810901 814575 814641 814920 815698 818381 818977 821097 821587 823156 823320 823677 828451 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарная"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"шикарная"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.