Query Metrics
7
Database Queries
7
Different statements
179.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.44 ms (82.16%) |
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 20190 203504 385198 386987 388350 402238 402531 402626 404185 406062 416621 422055 428582 443902 452779 454354 462003 465496 471660 481305 483513 493606 524096 531667 535706 548940 590360 591952 592322 594226 598306 598805 604138 604479 609194 612419 620144 620158 620175 620310 624177 625523 632015 633611 634415 650969 693859 705452 707329 717911 717974 719926 720713 721132 721875 724203 727050 727476 727852 728170 728308 728944 733149 733851 735946 737120 739998 740450 740744 740773 743057 743376 747073 750554 753462 756683 759756 760401 761179 762819 765270 766523 766660 766691 766735 767588 768729 770139 770242 771013 771019 771039 772480 773352 775701 779684 781332 782182 782666 784822 786571 786878 788305 788327 791529 793166 796491 796527 797520 797839 798736 800276 800573 802177 803108 809654 810243 811445 812405 824961 ] |
||||||||||||||||||||||||||||||
|
21.61 ms (12.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 592322 598805 604479 612419 591952 598306 624177 632015 633611 590360 594226 604138 779684 781332 782666 802177 809654 782182 784822 786571 788305 798736 800573 810243 728944 737120 743057 743376 750554 760401 766523 767588 770139 771039 772480 786878 788327 796527 797839 811445 812405 724203 727852 747073 756683 759756 771019 727050 727476 728308 761179 765270 766660 773352 733149 735946 753462 768729 770242 728170 733851 739998 740744 766691 766735 771013 620158 620310 625523 707329 717974 719926 720713 721875 791529 797520 800276 803108 20190 385198 443902 428582 386987 388350 402238 402531 404185 481305 493606 203504 824961 535706 531667 650969 693859 705452 548940 634415 620144 620175 793166 775701 796491 740450 740773 762819 609194 717911 721132 524096 402626 406062 416621 422055 454354 471660 452779 483513 462003 465496 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.57%) |
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 20190 203504 385198 386987 388350 402238 402531 402626 404185 406062 416621 422055 428582 443902 452779 454354 462003 465496 471660 481305 483513 493606 524096 531667 535706 548940 590360 591952 592322 594226 598306 598805 604138 604479 609194 612419 620144 620158 620175 620310 624177 625523 632015 633611 634415 650969 693859 705452 707329 717911 717974 719926 720713 721132 721875 724203 727050 727476 727852 728170 728308 728944 733149 733851 735946 737120 739998 740450 740744 740773 743057 743376 747073 750554 753462 756683 759756 760401 761179 762819 765270 766523 766660 766691 766735 767588 768729 770139 770242 771013 771019 771039 772480 773352 775701 779684 781332 782182 782666 784822 786571 786878 788305 788327 791529 793166 796491 796527 797520 797839 798736 800276 800573 802177 803108 809654 810243 811445 812405 824961 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal natural"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.