Query Metrics
7
Database Queries
7
Different statements
279.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
257.98 ms (92.28%) |
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 383249 388177 395273 395274 395310 396471 398261 402834 410318 413685 416611 418560 421443 426354 426361 428173 428177 434874 436627 442494 444338 444933 445266 445711 448520 450951 451594 453794 454790 455585 467970 475250 475482 478644 485389 492171 496385 499503 502634 505133 508427 510071 514995 519012 522188 537987 542648 543533 549121 553879 556181 562419 567967 586664 587282 587755 588231 590074 590847 591349 594413 594503 595533 597498 598493 616653 623440 625577 625980 626236 626255 626507 626509 627017 630994 635536 640466 641501 643590 646137 649688 653674 655021 656294 656569 657193 659055 660328 661606 671670 683026 685300 686729 687740 687771 690239 691402 695156 699451 702980 704684 713909 718139 720164 720283 720680 729619 736297 738976 741812 743706 745236 750691 754127 761954 773751 779819 783103 823972 828593 ] |
||||||||||||||||||||||||||||||
|
12.38 ms (4.43%) |
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 475250 383249 736297 761954 741812 773751 720283 388177 416611 413685 445266 436627 428177 448520 453794 455585 467970 475482 537987 514995 720164 586664 623440 626236 587755 588231 743706 626255 445711 444933 444338 454790 418560 505133 492171 499503 510071 594503 646137 683026 655021 659055 661606 699451 660328 704684 641501 625980 590074 627017 635536 702980 553879 691402 653674 656294 656569 549121 595533 729619 556181 695156 591349 508427 502634 542648 519012 686729 567967 496385 718139 685300 594413 783103 720680 543533 823972 738976 779819 395310 451594 598493 750691 442494 671670 640466 485389 396471 828593 562419 649688 657193 687771 690239 687740 587282 616653 626507 625577 590847 626509 630994 643590 745236 713909 522188 478644 597498 754127 428173 402834 426361 395273 395274 398261 421443 426354 410318 434874 450951 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.86%) |
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 383249 388177 395273 395274 395310 396471 398261 402834 410318 413685 416611 418560 421443 426354 426361 428173 428177 434874 436627 442494 444338 444933 445266 445711 448520 450951 451594 453794 454790 455585 467970 475250 475482 478644 485389 492171 496385 499503 502634 505133 508427 510071 514995 519012 522188 537987 542648 543533 549121 553879 556181 562419 567967 586664 587282 587755 588231 590074 590847 591349 594413 594503 595533 597498 598493 616653 623440 625577 625980 626236 626255 626507 626509 627017 630994 635536 640466 641501 643590 646137 649688 653674 655021 656294 656569 657193 659055 660328 661606 671670 683026 685300 686729 687740 687771 690239 691402 695156 699451 702980 704684 713909 718139 720164 720283 720680 729619 736297 738976 741812 743706 745236 750691 754127 761954 773751 779819 783103 823972 828593 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen cock"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen cock"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen cock"
]
|
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.