Query Metrics
7
Database Queries
7
Different statements
181.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.99 ms (89.31%) |
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 16762 21397 61369 96581 151180 161318 172220 190903 307458 336072 336704 360336 382006 382252 383508 385947 386316 391294 394738 396953 397219 397859 398461 398554 398556 399009 400598 400996 401157 401834 407562 407708 409201 412613 423975 437320 443135 454466 456724 461282 469955 491214 494932 503069 523897 529600 545924 546145 547044 550636 560455 617536 630654 634631 649242 654167 660061 660400 663459 664848 665248 665270 665506 665876 669652 669742 670902 671223 681170 693487 695108 710339 718538 724492 724728 728305 729076 729296 730357 733495 733511 734264 734265 736765 742495 745354 745952 747173 748366 748473 754161 759688 781829 781883 781896 787781 792592 795088 796851 797014 800924 801061 801705 801796 801947 801984 802352 802616 804059 804127 814723 823849 824283 824538 826119 826165 826482 826705 827963 827964 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (6.56%) |
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 781829 398556 681170 665506 792592 802616 748366 665248 665270 654167 781883 796851 382252 503069 494932 398461 469955 161318 360336 407562 397859 401157 801705 742495 401834 827963 787781 397219 386316 523897 399009 827964 529600 547044 671223 729296 754161 804059 724492 733511 748473 710339 824283 550636 545924 802352 801947 728305 733495 734264 734265 729076 801796 804127 96581 307458 61369 665876 398554 826482 826119 824538 823849 826165 560455 546145 649242 695108 801061 801984 800924 747173 736765 759688 724728 718538 781896 797014 190903 491214 664848 617536 745952 336704 400996 814723 669652 21397 336072 383508 172220 400598 663459 669742 745354 391294 423975 826705 660061 670902 730357 456724 394738 382006 16762 443135 407708 409201 385947 151180 412613 396953 660400 461282 437320 454466 693487 634631 795088 630654 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
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 16762 21397 61369 96581 151180 161318 172220 190903 307458 336072 336704 360336 382006 382252 383508 385947 386316 391294 394738 396953 397219 397859 398461 398554 398556 399009 400598 400996 401157 401834 407562 407708 409201 412613 423975 437320 443135 454466 456724 461282 469955 491214 494932 503069 523897 529600 545924 546145 547044 550636 560455 617536 630654 634631 649242 654167 660061 660400 663459 664848 665248 665270 665506 665876 669652 669742 670902 671223 681170 693487 695108 710339 718538 724492 724728 728305 729076 729296 730357 733495 733511 734264 734265 736765 742495 745354 745952 747173 748366 748473 754161 759688 781829 781883 781896 787781 792592 795088 796851 797014 800924 801061 801705 801796 801947 801984 802352 802616 804059 804127 814723 823849 824283 824538 826119 826165 826482 826705 827963 827964 ] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс полная"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс пышками"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс полная"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.73%) |
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.