Query Metrics
7
Database Queries
7
Different statements
237.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.44 ms (89.03%) |
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 88373 123010 187567 365885 381878 388100 396910 402735 407374 411332 411360 413475 418833 446501 448040 448052 454027 457338 458057 464464 464544 465731 467035 468147 473947 480242 482292 485086 485749 490919 494260 503314 503561 503569 505132 509702 510225 519208 536489 538957 542148 544824 546594 556847 565846 567909 573216 574990 592451 598811 606496 610847 615391 629009 640531 644669 645959 653567 671746 672138 675923 675971 675986 675995 676402 676508 679120 684551 698972 710096 710407 712466 716177 717669 725359 725399 728191 728194 732799 734345 735418 741780 742579 750809 752161 757206 770105 770836 772959 779175 781759 782760 786254 788811 788818 789521 789844 793877 794795 795483 795497 797195 797264 799793 800073 802109 802121 804004 807401 808679 811486 814245 814488 816068 816562 817320 818403 818848 820871 821228 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (6.98%) |
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 418833 482292 503561 505132 123010 407374 413475 814488 821228 816562 816068 817320 818403 818848 458057 448040 464544 538957 573216 684551 698972 710096 712466 672138 675986 675995 710407 645959 675923 675971 676402 679120 556847 565846 574990 598811 610847 606496 592451 615391 779175 781759 793877 795483 795497 799793 807401 808679 797195 725359 725399 732799 734345 741780 770836 786254 788811 789844 800073 811486 750809 728191 752161 757206 735418 770105 772959 742579 629009 716177 717669 782760 788818 789521 794795 797264 804004 187567 381878 402735 465731 480242 365885 411360 457338 473947 396910 490919 388100 446501 503314 485086 510225 671746 411332 88373 820871 814245 454027 503569 536489 494260 467035 544824 546594 802109 802121 728194 640531 644669 464464 468147 519208 509702 485749 676508 448052 567909 542148 653567 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.06%) |
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 88373 123010 187567 365885 381878 388100 396910 402735 407374 411332 411360 413475 418833 446501 448040 448052 454027 457338 458057 464464 464544 465731 467035 468147 473947 480242 482292 485086 485749 490919 494260 503314 503561 503569 505132 509702 510225 519208 536489 538957 542148 544824 546594 556847 565846 567909 573216 574990 592451 598811 606496 610847 615391 629009 640531 644669 645959 653567 671746 672138 675923 675971 675986 675995 676402 676508 679120 684551 698972 710096 710407 712466 716177 717669 725359 725399 728191 728194 732799 734345 735418 741780 742579 750809 752161 757206 770105 770836 772959 779175 781759 782760 786254 788811 788818 789521 789844 793877 794795 795483 795497 797195 797264 799793 800073 802109 802121 804004 807401 808679 811486 814245 814488 816068 816562 817320 818403 818848 820871 821228 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting stockings"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.65%) |
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.