Query Metrics
8
Database Queries
8
Different statements
1327.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
691.01 ms (52.04%) |
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 181804 480902 387548 761247 383188 411381 72393 619151 795004 689328 490944 824903 491130 544865 472873 425998 446308 722968 397888 806004 821155 818455 452975 439650 461410 460844 703085 811493 753544 720536 689356 811490 808491 517701 820715 587471 801856 388891 824281 556658 807913 443719 397907 816055 816001 817223 815793 815917 803013 485869 443707 522511 181902 391044 817295 439472 419520 443943 383643 720603 708841 599595 412343 382702 490914 387470 584403 750713 519238 472505 462030 787649 650643 439544 411372 385780 397886 559459 766698 522608 795585 603656 501234 490936 581385 191139 820145 820852 812093 408136 466261 760786 739940 318463 468534 496561 556647 797637 799256 187699 536637 470451 525065 391967 387113 604854 797632 818854 817247 823278 366052 107102 393027 814902 816524 820817 817109 731310 789322 522377 ] |
||||||||||||||||||||||||||||||
|
217.71 ms (16.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf чулк нижн бел куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
209.40 ms (15.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
182.36 ms (13.73%) |
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 72393 107102 181804 181902 187699 191139 318463 366052 382702 383188 383643 385780 387113 387470 387548 388891 391044 391967 393027 397886 397888 397907 408136 411372 411381 412343 419520 425998 439472 439544 439650 443707 443719 443943 446308 452975 460844 461410 462030 466261 468534 470451 472505 472873 480902 485869 490914 490936 490944 491130 496561 501234 517701 519238 522377 522511 522608 525065 536637 544865 556647 556658 559459 581385 584403 587471 599595 603656 604854 619151 650643 689328 689356 703085 708841 720536 720603 722968 731310 739940 750713 753544 760786 761247 766698 787649 789322 795004 795585 797632 797637 799256 801856 803013 806004 807913 808491 811490 811493 812093 814902 815793 815917 816001 816055 816524 817109 817223 817247 817295 818455 818854 820145 820715 820817 820852 821155 823278 824281 824903 ] |
||||||||||||||||||||||||||||||
|
20.26 ms (1.53%) |
1 |
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance` FROM `search_log` WHERE MATCH (`query`) AGAINST (?) AND `query` <> ? AND `blocked` = 0 ORDER BY `relevance` DESC LIMIT ?
Parameters:
[ "milf stockings cunnilingus" "milf stockings cunnilingus" "milf stockings cunnilingus" 20 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.22%) |
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 72393 107102 181804 181902 187699 191139 318463 366052 382702 383188 383643 385780 387113 387470 387548 388891 391044 391967 393027 397886 397888 397907 408136 411372 411381 412343 419520 425998 439472 439544 439650 443707 443719 443943 446308 452975 460844 461410 462030 466261 468534 470451 472505 472873 480902 485869 490914 490936 490944 491130 496561 501234 517701 519238 522377 522511 522608 525065 536637 544865 556647 556658 559459 581385 584403 587471 599595 603656 604854 619151 650643 689328 689356 703085 708841 720536 720603 722968 731310 739940 750713 753544 760786 761247 766698 787649 789322 795004 795585 797632 797637 799256 801856 803013 806004 807913 808491 811490 811493 812093 814902 815793 815917 816001 816055 816524 817109 817223 817247 817295 818455 818854 820145 820715 820817 820852 821155 823278 824281 824903 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf stockings cunnilingus"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf чулк нижн бел куннилингус оральн секс"
]
|
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.