Query Metrics
7
Database Queries
7
Different statements
224.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.17 ms (89.01%) |
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 424280 515844 523594 530108 530159 536269 541186 543750 545017 545994 547163 549561 549789 550566 551481 551588 552691 552900 553082 554019 556382 557415 557690 558520 558865 560327 560566 560755 562294 562485 565849 567742 567969 568030 568188 571769 573198 573289 573791 574608 575603 575666 576836 577258 578082 582340 584140 588541 593239 593933 595800 598547 600227 603125 603136 604266 608765 610693 611178 614897 618532 620317 622510 625620 625699 632719 632905 648765 661005 661440 661540 662495 667242 667388 670064 673852 674909 679247 681343 682929 685889 686453 690032 692627 695515 709466 715652 716502 716504 716973 726458 727261 727382 735558 735562 736638 737140 738219 738770 742195 743111 748548 750360 751376 754264 754505 785251 786547 789493 793680 793982 809904 813925 816194 818234 821855 825967 826852 828249 828587 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (6.13%) |
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 692627 661440 620317 632719 603125 560755 550566 648765 567969 786547 727382 726458 715652 568030 551588 577258 604266 573791 600227 670064 545017 737140 738770 826852 818234 828587 547163 667242 603136 625620 625699 530108 556382 608765 685889 593933 557415 598547 816194 543750 584140 686453 809904 748548 751376 793982 750360 754264 754505 709466 785251 536269 551481 568188 595800 736638 821855 523594 560566 573289 553082 558520 549789 562294 571769 578082 727261 825967 673852 575603 541186 565849 662495 661005 674909 679247 695515 681343 690032 582340 588541 593239 622510 424280 661540 716504 552900 611178 667388 545994 614897 828249 575666 574608 552691 576836 618532 793680 632905 813925 530159 515844 549561 554019 562485 557690 558865 560327 567742 682929 716973 716502 573198 610693 735562 742195 789493 738219 735558 743111 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.25%) |
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 424280 515844 523594 530108 530159 536269 541186 543750 545017 545994 547163 549561 549789 550566 551481 551588 552691 552900 553082 554019 556382 557415 557690 558520 558865 560327 560566 560755 562294 562485 565849 567742 567969 568030 568188 571769 573198 573289 573791 574608 575603 575666 576836 577258 578082 582340 584140 588541 593239 593933 595800 598547 600227 603125 603136 604266 608765 610693 611178 614897 618532 620317 622510 625620 625699 632719 632905 648765 661005 661440 661540 662495 667242 667388 670064 673852 674909 679247 681343 682929 685889 686453 690032 692627 695515 709466 715652 716502 716504 716973 726458 727261 727382 735558 735562 736638 737140 738219 738770 742195 743111 748548 750360 751376 754264 754505 785251 786547 789493 793680 793982 809904 813925 816194 818234 821855 825967 826852 828249 828587 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск маленькая"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur small"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.