Query Metrics
7
Database Queries
7
Different statements
360.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.26 ms (58.64%) |
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 4245 58701 102892 110738 172420 204646 282858 319863 329840 383210 383650 384139 384595 386798 388685 389585 390990 391296 395999 396142 396145 396150 396259 396716 397918 398274 401114 402458 406125 406616 406793 410264 412541 414172 419862 419910 441020 452157 452611 452998 453355 457501 459831 460302 460698 463903 473973 490848 492170 497645 517564 531114 536245 543592 553269 560946 572020 601150 620245 621270 626533 640407 649121 655296 664491 664536 671607 671649 688025 693186 702675 707314 707323 712549 716720 718542 719582 719638 720705 730346 736286 743067 743900 743928 748798 751092 755419 756219 757438 765770 766464 766800 767207 769749 777132 778903 779750 784265 786041 790518 790865 793394 798999 799586 800558 806044 809117 809128 811077 814580 815898 816492 817362 821090 821380 821534 821552 823226 824184 827984 ] |
||||||||||||||||||||||||||||||
|
128.68 ms (35.72%) |
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 4245 58701 102892 110738 172420 204646 282858 319863 329840 383210 383650 384139 384595 386798 388685 389585 390990 391296 395999 396142 396145 396150 396259 396716 397918 398274 401114 402458 406125 406616 406793 410264 412541 414172 419862 419910 441020 452157 452611 452998 453355 457501 459831 460302 460698 463903 473973 490848 492170 497645 517564 531114 536245 543592 553269 560946 572020 601150 620245 621270 626533 640407 649121 655296 664491 664536 671607 671649 688025 693186 702675 707314 707323 712549 716720 718542 719582 719638 720705 730346 736286 743067 743900 743928 748798 751092 755419 756219 757438 765770 766464 766800 767207 769749 777132 778903 779750 784265 786041 790518 790865 793394 798999 799586 800558 806044 809117 809128 811077 814580 815898 816492 817362 821090 821380 821534 821552 823226 824184 827984 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (3.77%) |
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 743928 757438 671607 620245 396142 823226 814580 572020 655296 671649 718542 766464 799586 707314 790865 800558 806044 441020 396150 110738 473973 517564 402458 412541 497645 664536 460302 463903 452157 414172 553269 712549 793394 707323 388685 102892 778903 452611 531114 58701 406125 601150 543592 560946 490848 398274 384595 282858 688025 719638 720705 406793 459831 384139 204646 621270 452998 329840 389585 821380 716720 664491 693186 809128 736286 748798 765770 769749 756219 4245 824184 419910 492170 383650 410264 419862 172420 827984 798999 766800 767207 386798 743067 383210 536245 396716 649121 640407 626533 777132 779750 809117 784265 811077 743900 719582 790518 390990 406616 397918 453355 457501 391296 460698 396145 816492 815898 821090 821552 821534 786041 755419 319863 751092 401114 396259 817362 730346 395999 702675 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.38%) |
1 |
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.