Query Metrics
7
Database Queries
7
Different statements
191.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.97 ms (85.80%) |
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 17058 61726 100642 150798 187928 310679 382885 383237 384540 386403 386630 386665 386717 391659 393108 395278 395724 397095 397353 397882 397977 399632 401480 404185 406361 409942 411813 413112 416258 417389 427203 435054 437256 439214 440932 443901 453833 454278 456156 465392 467955 468102 468697 476180 477070 486253 514814 530452 535053 541568 553757 561002 565347 583882 584068 593606 597898 600283 607254 612419 624409 630399 634563 637010 639293 643329 644315 644974 649105 663510 671579 693356 694062 706331 708817 719022 719025 726922 728443 731360 731772 731834 733071 739460 740773 742452 744593 744632 746682 746819 755341 761502 764351 766668 766690 767257 767279 769904 776204 778889 782428 788131 788650 789540 792656 797863 800852 803673 803919 804995 805784 810839 811474 812965 815137 815804 817054 823408 826127 828535 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (8.47%) |
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 409942 817054 823408 719022 639293 812965 746819 788131 767279 630399 395278 397882 435054 612419 742452 404185 427203 477070 693356 397095 553757 624409 800852 761502 767257 731834 746682 792656 565347 634563 637010 382885 61726 535053 584068 776204 386717 100642 393108 395724 401480 406361 416258 413112 443901 465392 671579 804995 744632 150798 454278 391659 411813 644974 815137 456156 649105 719025 708817 600283 644315 797863 789540 803673 731360 766668 726922 744593 755341 769904 739460 728443 766690 782428 788650 397353 187928 514814 439214 486253 803919 733071 810839 384540 815804 826127 828535 597898 731772 386665 386630 805784 740773 764351 811474 467955 468697 530452 437256 694062 643329 397977 17058 476180 663510 706331 593606 778889 383237 310679 386403 399632 417389 440932 468102 453833 583882 561002 541568 607254 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.71%) |
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 17058 61726 100642 150798 187928 310679 382885 383237 384540 386403 386630 386665 386717 391659 393108 395278 395724 397095 397353 397882 397977 399632 401480 404185 406361 409942 411813 413112 416258 417389 427203 435054 437256 439214 440932 443901 453833 454278 456156 465392 467955 468102 468697 476180 477070 486253 514814 530452 535053 541568 553757 561002 565347 583882 584068 593606 597898 600283 607254 612419 624409 630399 634563 637010 639293 643329 644315 644974 649105 663510 671579 693356 694062 706331 708817 719022 719025 726922 728443 731360 731772 731834 733071 739460 740773 742452 744593 744632 746682 746819 755341 761502 764351 766668 766690 767257 767279 769904 776204 778889 782428 788131 788650 789540 792656 797863 800852 803673 803919 804995 805784 810839 811474 812965 815137 815804 817054 823408 826127 828535 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex boobs anal"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс boobs анал"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс boobs анал"
]
|
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.