Query Metrics
7
Database Queries
7
Different statements
221.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.76 ms (89.88%) |
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 384521 395844 395846 397385 404664 405690 407266 407378 436719 478963 480212 480383 481047 499821 518562 524540 532953 534924 535374 535546 535878 536611 542207 547767 555066 560920 564765 570722 571441 582404 585532 596408 614347 620172 620247 621699 622335 622378 643373 646267 646292 647602 647630 648210 666579 668509 671714 673772 674081 675525 693208 694062 698038 700975 703509 705530 706622 707314 712555 713574 713876 716789 717720 717839 720621 724289 726003 728474 734386 734452 737598 741269 744317 746454 751582 755954 756230 757312 757331 766537 769726 770268 770930 772039 772907 777573 777580 785092 785525 786199 787287 787863 789986 790009 794533 796957 799290 799802 800287 805420 807497 807912 811065 812941 813945 814288 815199 815388 815727 815950 815951 816502 816538 818198 820039 821187 821532 822045 825571 825830 ] |
||||||||||||||||||||||||||||||
|
12.52 ms (5.66%) |
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 405690 813945 825830 814288 815388 816502 815727 534924 535878 564765 647602 668509 647630 666579 713574 717839 671714 673772 717720 560920 621699 777573 785525 787287 787863 799290 799802 770930 772907 766537 770268 772039 726003 716789 384521 693208 698038 585532 811065 794533 812941 734452 707314 535374 547767 741269 786199 816538 821187 822045 825571 646292 790009 815951 620247 620172 643373 734386 746454 769726 785092 712555 805420 818198 555066 542207 675525 720621 614347 777580 796957 757312 807912 789986 807497 478963 481047 395846 622335 820039 815950 694062 646267 648210 737598 744317 570722 703509 596408 724289 756230 706622 395844 397385 404664 407266 407378 436719 815199 821532 480383 535546 536611 499821 532953 518562 524540 480212 582404 571441 700975 705530 674081 713876 622378 800287 755954 728474 751582 757331 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.29%) |
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 384521 395844 395846 397385 404664 405690 407266 407378 436719 478963 480212 480383 481047 499821 518562 524540 532953 534924 535374 535546 535878 536611 542207 547767 555066 560920 564765 570722 571441 582404 585532 596408 614347 620172 620247 621699 622335 622378 643373 646267 646292 647602 647630 648210 666579 668509 671714 673772 674081 675525 693208 694062 698038 700975 703509 705530 706622 707314 712555 713574 713876 716789 717720 717839 720621 724289 726003 728474 734386 734452 737598 741269 744317 746454 751582 755954 756230 757312 757331 766537 769726 770268 770930 772039 772907 777573 777580 785092 785525 786199 787287 787863 789986 790009 794533 796957 799290 799802 800287 805420 807497 807912 811065 812941 813945 814288 815199 815388 815727 815950 815951 816502 816538 818198 820039 821187 821532 822045 825571 825830 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty milf анал"
]
|
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.