Query Metrics
7
Database Queries
7
Different statements
400.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.52 ms (51.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
171.42 ms (42.85%) |
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 382376 385119 397077 397094 412616 452702 506277 539238 540067 541565 551721 555907 565239 566465 590391 594576 612987 613288 615199 615414 620954 622894 636386 638473 639354 642405 651538 656846 661638 662516 665090 668556 668733 674949 675694 678243 678458 678768 689048 694175 695410 697682 705830 707298 711658 713983 716385 718616 722198 722351 728918 732945 734415 746376 747487 747619 748120 751163 766929 768247 772355 773175 773617 773774 775595 775654 778437 779251 780372 783131 787776 788399 789446 789460 789512 790438 791583 792204 792231 792321 792418 793554 793895 795006 795073 795261 795340 795627 795953 797216 797265 799490 800170 801161 801782 801834 802366 803728 803729 805078 811548 811835 812117 813856 816809 818305 818842 823953 824213 824312 824932 825125 825227 826034 826147 826348 826585 826986 828560 828768 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (3.85%) |
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 668556 789446 797265 772355 412616 540067 551721 594576 812117 382376 452702 385119 397094 824213 824932 818305 823953 825125 825227 826034 826147 826986 816809 824312 818842 826585 828768 826348 828560 539238 506277 565239 566465 656846 661638 695410 707298 713983 716385 722198 722351 662516 668733 674949 675694 678768 718616 651538 678243 689048 697682 711658 615199 615414 620954 642405 612987 622894 639354 590391 775595 788399 790438 792418 795953 803729 805078 811548 775654 779251 787776 789460 791583 793554 795627 797216 801834 766929 773617 783131 792321 795006 795073 795261 799490 803728 811835 728918 734415 746376 748120 747487 773175 747619 768247 773774 732945 751163 780372 792204 792231 795340 800170 802366 813856 555907 665090 613288 778437 789512 793895 801161 705830 397077 541565 694175 678458 636386 638473 801782 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (0.86%) |
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 382376 385119 397077 397094 412616 452702 506277 539238 540067 541565 551721 555907 565239 566465 590391 594576 612987 613288 615199 615414 620954 622894 636386 638473 639354 642405 651538 656846 661638 662516 665090 668556 668733 674949 675694 678243 678458 678768 689048 694175 695410 697682 705830 707298 711658 713983 716385 718616 722198 722351 728918 732945 734415 746376 747487 747619 748120 751163 766929 768247 772355 773175 773617 773774 775595 775654 778437 779251 780372 783131 787776 788399 789446 789460 789512 790438 791583 792204 792231 792321 792418 793554 793895 795006 795073 795261 795340 795627 795953 797216 797265 799490 800170 801161 801782 801834 802366 803728 803729 805078 811548 811835 812117 813856 816809 818305 818842 823953 824213 824312 824932 825125 825227 826034 826147 826348 826585 826986 828560 828768 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife webcam"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
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.