Query Metrics
7
Database Queries
7
Different statements
248.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.30 ms (90.65%) |
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 13646 113794 394648 400942 406128 415515 415755 416029 417248 433288 439292 441120 452789 459331 467089 471111 493172 494156 527224 529658 530688 531794 531824 531861 533255 534562 536121 542762 543668 550897 559234 562881 572626 574465 576540 578478 590373 590795 590831 592409 592975 604261 605209 632125 649113 657159 660384 661987 665784 665802 669370 671049 672945 680278 701445 704911 705360 705459 705472 705479 710100 713181 713502 713503 722376 727829 728152 729228 729700 730355 733266 733454 735338 740244 740310 745326 752011 752122 752696 756353 758789 759948 761061 761366 761724 765438 765546 767791 771219 775693 779119 781320 784263 786911 788631 794763 794907 795310 796285 796486 799687 799697 801536 801918 802029 803621 803633 809351 816184 817025 817113 817172 817176 817181 817536 817556 819411 819418 826705 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (5.65%) |
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 590373 803621 759948 786911 493172 669370 452789 13646 467089 592975 394648 530688 534562 531861 572626 660384 701445 710100 713503 672945 713502 550897 590831 604261 788631 801918 803633 761724 765438 794907 799697 728152 730355 740310 752011 756353 752122 745326 752696 735338 761061 605209 632125 722376 113794 417248 536121 542762 705472 590795 796486 733454 767791 415515 705360 781320 816184 826705 817181 827870 529658 576540 657159 705459 705479 775693 801536 740244 761366 799687 809351 727829 729228 771219 729700 765546 784263 794763 578478 671049 459331 562881 758789 779119 439292 494156 733266 802029 400942 406128 471111 415755 441120 416029 433288 574465 665784 592409 661987 527224 817556 817536 819418 817025 817113 817172 817176 819411 531794 533255 531824 543668 559234 649113 680278 704911 665802 713181 795310 796285 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.87%) |
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 13646 113794 394648 400942 406128 415515 415755 416029 417248 433288 439292 441120 452789 459331 467089 471111 493172 494156 527224 529658 530688 531794 531824 531861 533255 534562 536121 542762 543668 550897 559234 562881 572626 574465 576540 578478 590373 590795 590831 592409 592975 604261 605209 632125 649113 657159 660384 661987 665784 665802 669370 671049 672945 680278 701445 704911 705360 705459 705472 705479 710100 713181 713502 713503 722376 727829 728152 729228 729700 730355 733266 733454 735338 740244 740310 745326 752011 752122 752696 756353 758789 759948 761061 761366 761724 765438 765546 767791 771219 775693 779119 781320 784263 786911 788631 794763 794907 795310 796285 796486 799687 799697 801536 801918 802029 803621 803633 809351 816184 817025 817113 817172 817176 817181 817536 817556 819411 819418 826705 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.59%) |
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.