Query Metrics
7
Database Queries
7
Different statements
177.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.40 ms (87.10%) |
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 387173 437511 453593 465175 469243 476828 483152 489262 491360 526366 527465 533262 537307 537830 541961 544217 548483 557446 564811 568386 573160 574644 576621 580853 582765 605241 605583 606634 608047 613175 623830 626242 642727 646332 664235 669703 672791 678796 678820 687518 696332 703498 706704 710799 713647 723988 724189 724458 724744 727921 729856 731401 731757 733353 734635 738091 738223 740136 741547 744413 745976 746127 746129 746680 750900 751364 752208 752290 752336 752383 752409 752430 752452 755041 755326 758926 759744 765033 767371 769334 773363 774951 781896 783501 788971 789750 790407 794122 794695 794733 794815 796024 796051 796305 796338 796980 799276 800494 801537 802215 804666 804782 805342 805362 805365 808433 808515 810360 811060 811258 812247 812386 813304 816620 818240 818954 819021 820024 823439 827624 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (7.66%) |
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 783501 790407 794815 796051 796305 796338 802215 812386 723988 729856 746127 788971 794122 796980 799276 804666 808433 808515 724744 731401 744413 746680 752430 769334 731757 755326 765033 733353 750900 752336 752409 751364 703498 781896 805342 812247 527465 387173 818954 819021 823439 816620 818240 820024 827624 491360 469243 533262 537830 557446 568386 582765 544217 548483 573160 574644 564811 576621 646332 664235 672791 696332 710799 669703 678820 687518 713647 678796 706704 580853 605583 613175 605241 606634 608047 623830 774951 794695 796024 805365 800494 801537 804782 805362 810360 740136 746129 767371 773363 789750 758926 724189 752208 752290 752452 724458 738223 752383 755041 759744 727921 734635 738091 741547 745976 626242 642727 794733 811060 811258 813304 453593 437511 476828 483152 465175 537307 526366 489262 541961 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.39%) |
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 387173 437511 453593 465175 469243 476828 483152 489262 491360 526366 527465 533262 537307 537830 541961 544217 548483 557446 564811 568386 573160 574644 576621 580853 582765 605241 605583 606634 608047 613175 623830 626242 642727 646332 664235 669703 672791 678796 678820 687518 696332 703498 706704 710799 713647 723988 724189 724458 724744 727921 729856 731401 731757 733353 734635 738091 738223 740136 741547 744413 745976 746127 746129 746680 750900 751364 752208 752290 752336 752383 752409 752430 752452 755041 755326 758926 759744 765033 767371 769334 773363 774951 781896 783501 788971 789750 790407 794122 794695 794733 794815 796024 796051 796305 796338 796980 799276 800494 801537 802215 804666 804782 805342 805362 805365 808433 808515 810360 811060 811258 812247 812386 813304 816620 818240 818954 819021 820024 823439 827624 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation saggy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк saggy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк saggy"
]
|
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.