Query Metrics
7
Database Queries
7
Different statements
175.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.15 ms (86.67%) |
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 263929 370957 383631 386936 390931 395146 399043 399151 399604 400486 403381 407694 409391 417316 421828 422193 422236 428840 432154 435382 446817 448688 449609 449709 455201 456582 457023 457861 461372 464338 465276 468862 469523 473712 476338 476449 484363 484447 485534 491934 492103 492640 493817 498288 505295 509655 517375 519491 519856 522032 524446 525805 525998 528160 537248 537594 540157 554314 554895 556832 557256 557583 561464 561521 573739 580651 580742 582503 590164 590512 597512 603081 610026 612204 613286 617186 619518 623396 626298 626994 651214 687561 688325 696934 700634 710482 712951 714588 716033 716279 718729 723732 726757 727455 728102 729678 730819 742054 744436 745648 759635 759743 762185 776592 779768 788861 789528 793203 796478 801775 804965 812771 812802 813552 813750 814515 816917 818045 819342 827054 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (8.33%) |
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 613286 390931 804965 812802 417316 561464 590164 399151 729678 816917 484363 626298 759743 687561 723732 525998 557583 812771 742054 623396 788861 263929 814515 688325 617186 696934 525805 779768 759635 370957 403381 409391 464338 473712 610026 744436 476338 386936 400486 422236 485534 505295 522032 484447 509655 399604 537248 561521 461372 540157 776592 469523 710482 716279 718729 712951 716033 626994 612204 793203 727455 730819 726757 728102 619518 700634 714588 796478 421828 813750 603081 789528 456582 457861 519856 582503 556832 745648 801775 554895 524446 432154 435382 446817 449609 449709 457023 476449 517375 651214 580742 597512 762185 399043 407694 468862 492640 498288 491934 492103 519491 528160 383631 813552 448688 537594 573739 580651 590512 422193 428840 493817 395146 827054 818045 819342 465276 455201 554314 557256 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.48%) |
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 263929 370957 383631 386936 390931 395146 399043 399151 399604 400486 403381 407694 409391 417316 421828 422193 422236 428840 432154 435382 446817 448688 449609 449709 455201 456582 457023 457861 461372 464338 465276 468862 469523 473712 476338 476449 484363 484447 485534 491934 492103 492640 493817 498288 505295 509655 517375 519491 519856 522032 524446 525805 525998 528160 537248 537594 540157 554314 554895 556832 557256 557583 561464 561521 573739 580651 580742 582503 590164 590512 597512 603081 610026 612204 613286 617186 619518 623396 626298 626994 651214 687561 688325 696934 700634 710482 712951 714588 716033 716279 718729 723732 726757 727455 728102 729678 730819 742054 744436 745648 759635 759743 762185 776592 779768 788861 789528 793203 796478 801775 804965 812771 812802 813552 813750 814515 816917 818045 819342 827054 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.16 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom минет оральн секс"
]
|
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.