Query Metrics
7
Database Queries
7
Different statements
174.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.68 ms (87.33%) |
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 80510 370957 428977 433355 434583 447413 453497 453688 454683 455077 459852 460346 460663 479608 490036 496236 498023 505911 507329 508934 509435 510028 512601 517064 517196 518091 523824 525635 542425 546374 547081 551091 556930 556934 567608 569964 570173 571495 584809 586490 588041 592222 593702 598636 598733 599567 606660 608294 610610 611290 615036 617435 621043 628458 636241 641624 647670 650134 680624 682291 684216 689699 696430 705702 712948 734003 740312 742943 743084 744338 744436 750768 754199 755342 758971 760926 761291 762246 763599 770348 773444 773545 776933 778246 780394 790079 792128 792186 794446 796487 797499 799598 800069 800597 805199 805773 809322 813143 814268 814967 817235 818785 819047 819335 820550 820810 820895 821655 821677 822207 823150 823176 823247 823266 823439 823632 824251 825463 826661 827315 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (7.42%) |
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 454683 370957 479608 792128 744436 790079 433355 518091 823247 805773 797499 734003 773545 770348 617435 820810 825463 817235 820550 823150 823176 824251 682291 615036 776933 799598 800597 809322 813143 742943 750768 762246 805199 755342 760926 758971 740312 743084 744338 763599 712948 794446 611290 641624 460346 551091 599567 592222 814268 754199 447413 507329 696430 796487 509435 460663 508934 571495 593702 608294 567608 523824 512601 780394 80510 428977 459852 547081 650134 556934 586490 598733 761291 434583 453497 496236 822207 820895 517064 680624 705702 621043 773444 800069 610610 778246 792186 689699 569964 584809 588041 505911 455077 490036 498023 598636 510028 542425 546374 453688 525635 517196 684216 823266 823439 823632 826661 818785 819047 821655 821677 814967 819335 827315 556930 570173 647670 606660 628458 636241 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.50%) |
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 80510 370957 428977 433355 434583 447413 453497 453688 454683 455077 459852 460346 460663 479608 490036 496236 498023 505911 507329 508934 509435 510028 512601 517064 517196 518091 523824 525635 542425 546374 547081 551091 556930 556934 567608 569964 570173 571495 584809 586490 588041 592222 593702 598636 598733 599567 606660 608294 610610 611290 615036 617435 621043 628458 636241 641624 647670 650134 680624 682291 684216 689699 696430 705702 712948 734003 740312 742943 743084 744338 744436 750768 754199 755342 758971 760926 761291 762246 763599 770348 773444 773545 776933 778246 780394 790079 792128 792186 794446 796487 797499 799598 800069 800597 805199 805773 809322 813143 814268 814967 817235 818785 819047 819335 820550 820810 820895 821655 821677 822207 823150 823176 823247 823266 823439 823632 824251 825463 826661 827315 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.81%) |
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.