Query Metrics
7
Database Queries
7
Different statements
164.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.04 ms (82.87%) |
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 27423 31583 154127 182735 208554 313463 391799 406346 410193 416173 445727 449921 452225 465435 465437 467096 467784 475280 476024 477247 480651 494801 495382 502832 511579 525931 526180 527550 529055 529574 530680 535603 535616 539983 540132 541486 547781 550575 551464 553773 554668 554829 556618 556744 558713 560502 565801 567001 570846 570882 570890 574926 575647 576316 580346 580925 583557 584363 596252 607661 611232 614297 621496 622011 625819 627835 629210 632907 633408 636751 641444 641924 651101 651648 652357 658469 661360 666054 667325 669933 675349 680971 687304 687616 698374 718015 723206 724160 734120 735907 736074 754086 768460 768471 768503 768680 768951 768994 774578 774736 780137 780896 785136 785415 787163 788143 792372 793980 798821 798842 802259 802917 803705 804272 804391 805366 809000 811848 811907 814302 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (9.20%) |
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 556618 570846 580346 669933 651101 680971 558713 570882 574926 629210 632907 611232 641924 785415 787163 768680 788143 793980 803705 735907 768471 768951 768994 614297 774578 774736 780896 802259 804391 27423 208554 313463 449921 675349 551464 698374 814302 495382 539983 529574 530680 535603 554668 560502 570890 584363 576316 652357 687304 718015 556744 565801 627835 792372 811907 768460 724160 768503 736074 622011 625819 785136 811848 465437 467784 476024 406346 527550 805366 621496 529055 502832 633408 494801 525931 477247 154127 475280 31583 467096 547781 554829 651648 658469 804272 567001 553773 575647 550575 661360 666054 667325 687616 641444 798821 802917 754086 723206 798842 452225 465435 480651 410193 391799 182735 540132 541486 580925 511579 780137 734120 583557 607661 416173 445727 809000 535616 526180 596252 636751 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц дилд соло"
]
|
||||||||||||||||||||||||||||||
|
3.27 ms (1.99%) |
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 27423 31583 154127 182735 208554 313463 391799 406346 410193 416173 445727 449921 452225 465435 465437 467096 467784 475280 476024 477247 480651 494801 495382 502832 511579 525931 526180 527550 529055 529574 530680 535603 535616 539983 540132 541486 547781 550575 551464 553773 554668 554829 556618 556744 558713 560502 565801 567001 570846 570882 570890 574926 575647 576316 580346 580925 583557 584363 596252 607661 611232 614297 621496 622011 625819 627835 629210 632907 633408 636751 641444 641924 651101 651648 652357 658469 661360 666054 667325 669933 675349 680971 687304 687616 698374 718015 723206 724160 734120 735907 736074 754086 768460 768471 768503 768680 768951 768994 774578 774736 780137 780896 785136 785415 787163 788143 792372 793980 798821 798842 802259 802917 803705 804272 804391 805366 809000 811848 811907 814302 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public dildo solo"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
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.