Query Metrics
7
Database Queries
7
Different statements
227.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.88 ms (87.53%) |
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 182033 182203 381810 392422 398116 398124 401642 402634 402643 407398 413446 414048 416656 427122 428305 428308 430369 432268 432936 433001 434339 439125 443239 448000 448057 448063 448065 448551 450255 452803 452817 452823 452826 452827 452833 453997 458099 463621 467058 467929 468237 468255 469054 469131 469140 469176 469199 469733 475457 476049 476654 476657 476668 476692 480209 481961 486240 486765 487535 494546 502767 502774 510280 514147 545390 550891 551898 564170 567600 578301 585430 591217 604229 604667 620743 620957 634109 637197 642134 660409 692688 702336 704334 715288 717620 720160 723361 724264 728268 730338 738460 738480 738485 744383 756771 756779 758340 758941 766825 774874 777005 782825 782827 783034 784648 786610 791010 791549 791882 796648 796685 796709 797080 800502 800530 800543 802182 806393 807562 808333 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (7.63%) |
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 514147 476668 476692 551898 476654 467058 476049 487535 567600 660409 692688 704334 782825 738460 728268 774874 777005 401642 486765 486240 182033 443239 448063 469131 467929 637197 407398 806393 784648 476657 416656 414048 458099 604229 620743 398116 791882 182203 392422 428308 448057 717620 720160 782827 800502 758340 738480 738485 797080 428305 545390 452823 494546 585430 480209 448065 450255 510280 413446 448551 452827 453997 469176 502774 564170 807562 808333 730338 786610 468255 481961 756771 723361 452833 758941 475457 796709 800530 591217 433001 578301 604667 468237 796648 783034 744383 791010 791549 452817 502767 432268 469199 802182 724264 463621 469733 402643 642134 715288 402634 430369 434339 469054 452826 448000 766825 469140 439125 427122 432936 452803 381810 550891 702336 620957 800543 398124 634109 796685 756779 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.40%) |
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 182033 182203 381810 392422 398116 398124 401642 402634 402643 407398 413446 414048 416656 427122 428305 428308 430369 432268 432936 433001 434339 439125 443239 448000 448057 448063 448065 448551 450255 452803 452817 452823 452826 452827 452833 453997 458099 463621 467058 467929 468237 468255 469054 469131 469140 469176 469199 469733 475457 476049 476654 476657 476668 476692 480209 481961 486240 486765 487535 494546 502767 502774 510280 514147 545390 550891 551898 564170 567600 578301 585430 591217 604229 604667 620743 620957 634109 637197 642134 660409 692688 702336 704334 715288 717620 720160 723361 724264 728268 730338 738460 738480 738485 744383 756771 756779 758340 758941 766825 774874 777005 782825 782827 783034 784648 786610 791010 791549 791882 796648 796685 796709 797080 800502 800530 800543 802182 806393 807562 808333 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateurs dildo machine"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск дилд machine"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск дилд machine"
]
|
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.