Query Metrics
8
Database Queries
8
Different statements
327.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.69 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло сквирт"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.71 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01’Ê{3~sK¶µÌGŠÝ\x02Ô"
]
|
||||||||||||||||||||||||||||||
| 4 | 15.27 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 431396 444378 692743 398499 814419 678834 582571 750626 784048 759308 751329 785979 414223 439260 820020 825791 533099 551543 580934 678837 683061 634638 776081 777807 777984 780239 793259 801827 785340 806664 808651 810150 724987 739930 756713 750653 785170 418594 595339 555236 546971 669945 669957 777926 784513 786088 773059 807066 450162 494546 528407 579863 547795 579539 583807 756768 627446 439244 263039 403035 814164 824867 537651 661422 683062 705478 651587 661061 695470 714238 556896 588332 629771 587465 629797 776084 780242 807008 783929 784105 808158 767731 751313 752758 705427 795386 809618 382108 418577 442527 434345 468658 473607 457054 466510 514086 534777 506510 472378 544401 669877 669936 705005 708232 708714 681251 587442 639326 786906 755554 809428 811057 738518 756491 770253 791012 412688 427716 429705 417030 ] |
||||||||||||||||||||||||||||||
| 5 | 3.15 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 263039 382108 398499 403035 412688 414223 417030 418577 418594 427716 429705 431396 434345 439244 439260 442527 444378 450162 457054 466510 468658 472378 473607 494546 506510 514086 528407 533099 534777 537651 544401 546971 547795 551543 555236 556896 579539 579863 580934 582571 583807 587442 587465 588332 595339 627446 629771 629797 634638 639326 651587 661061 661422 669877 669936 669945 669957 678834 678837 681251 683061 683062 692743 695470 705005 705427 705478 708232 708714 714238 724987 738518 739930 750626 750653 751313 751329 752758 755554 756491 756713 756768 759308 767731 770253 773059 776081 776084 777807 777926 777984 780239 780242 783929 784048 784105 784513 785170 785340 785979 786088 786906 791012 793259 795386 801827 806664 807008 807066 808158 808651 809428 809618 810150 811057 814164 814419 820020 824867 825791 ] |
||||||||||||||||||||||||||||||
| 6 | 300.60 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 263039 382108 398499 403035 412688 414223 417030 418577 418594 427716 429705 431396 434345 439244 439260 442527 444378 450162 457054 466510 468658 472378 473607 494546 506510 514086 528407 533099 534777 537651 544401 546971 547795 551543 555236 556896 579539 579863 580934 582571 583807 587442 587465 588332 595339 627446 629771 629797 634638 639326 651587 661061 661422 669877 669936 669945 669957 678834 678837 681251 683061 683062 692743 695470 705005 705427 705478 708232 708714 714238 724987 738518 739930 750626 750653 751313 751329 752758 755554 756491 756713 756768 759308 767731 770253 773059 776081 776084 777807 777926 777984 780239 780242 783929 784048 784105 784513 785170 785340 785979 786088 786906 791012 793259 795386 801827 806664 807008 807066 808158 808651 809428 809618 810150 811057 814164 814419 820020 824867 825791 ] |
||||||||||||||||||||||||||||||
| 7 | 2.10 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.61 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.