Query Metrics
7
Database Queries
7
Different statements
226.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.07 ms (88.93%) |
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 555161 557469 559789 571698 576245 579991 585780 587100 594111 594942 598461 607031 610129 617817 622005 623987 623997 630983 636232 645202 650944 664183 668801 671782 672841 673297 673326 675596 675974 679113 679652 680588 681359 687920 690450 692296 696381 699745 701266 710405 710682 713017 714156 716329 716707 717794 719811 722230 725524 727482 729274 731978 732873 733118 737113 737136 737349 740985 742165 742211 742632 743138 743278 746290 750071 750216 750873 751539 751880 755334 757889 758959 759013 759493 760916 761300 767329 767419 767459 769148 769664 770262 770790 772249 772434 773789 777776 781815 783282 783376 786072 786511 786665 786835 787798 789109 789166 789838 792175 792376 794260 794794 795137 795194 795687 796247 797107 798976 799712 800049 800236 802953 804678 804702 807952 808157 809682 810169 810511 812869 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (6.16%) |
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 668801 672841 673326 675596 687920 690450 692296 696381 701266 716329 645202 664183 679113 710682 713017 714156 716707 722230 650944 671782 673297 675974 679652 680588 681359 555161 557469 559789 571698 576245 579991 585780 598461 622005 587100 594942 610129 623987 630983 636232 594111 607031 617817 623997 781815 787798 792175 795137 795687 796247 804678 804702 810169 810511 812869 786511 786835 789109 792376 795194 797107 798976 809682 725524 740985 743138 743278 759013 767459 786072 789166 789838 794260 794794 799712 800049 800236 802953 807952 808157 731978 742165 758959 770262 727482 733118 737136 737349 742211 742632 746290 750216 751880 755334 760916 761300 769148 769664 772249 773789 729274 750873 751539 757889 759493 767329 772434 732873 737113 750071 767419 770790 699745 710405 717794 719811 777776 783282 783376 786665 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.31%) |
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 555161 557469 559789 571698 576245 579991 585780 587100 594111 594942 598461 607031 610129 617817 622005 623987 623997 630983 636232 645202 650944 664183 668801 671782 672841 673297 673326 675596 675974 679113 679652 680588 681359 687920 690450 692296 696381 699745 701266 710405 710682 713017 714156 716329 716707 717794 719811 722230 725524 727482 729274 731978 732873 733118 737113 737136 737349 740985 742165 742211 742632 743138 743278 746290 750071 750216 750873 751539 751880 755334 757889 758959 759013 759493 760916 761300 767329 767419 767459 769148 769664 770262 770790 772249 772434 773789 777776 781815 783282 783376 786072 786511 786665 786835 787798 789109 789166 789838 792175 792376 794260 794794 795137 795194 795687 796247 797107 798976 799712 800049 800236 802953 804678 804702 807952 808157 809682 810169 810511 812869 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"грязн"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"грязную"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"грязн"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.