Query Metrics
7
Database Queries
7
Different statements
153.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.86 ms (81.92%) |
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 538816 538837 538949 541398 541637 541674 541725 541873 541887 543480 544278 544478 547430 549220 550327 559324 560076 560085 560924 560958 561026 561028 562843 563530 563532 563540 566696 566697 566760 567396 568287 570394 571441 571445 573763 574237 574269 574291 576625 576632 576633 576636 576694 576695 576703 576707 576722 577357 580252 580258 581348 583885 587763 587795 590948 590954 592388 598348 605330 605344 610047 615741 615748 615757 619466 619470 620145 620148 620163 620164 621305 621307 621313 621976 622372 622981 629899 643007 644264 644278 644306 644323 644643 644922 644968 648204 648256 651199 670093 670113 670773 671739 671756 684029 690803 690810 690831 690902 691820 692237 692786 693030 694563 695249 697266 699574 699606 699607 699697 703039 703080 706899 708422 716177 716323 723480 748695 784247 789844 801471 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (10.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 567396 670773 699607 651199 690810 694563 699606 695249 708422 620145 622372 644264 643007 789844 748695 706899 716177 801471 644922 697266 670093 587795 605330 605344 784247 644306 549220 560958 576633 571441 574237 671739 576703 610047 590948 592388 644323 563540 561026 587763 644968 541637 566760 671756 684029 691820 693030 703080 692786 619470 620163 644278 644643 703039 723480 690803 538837 538949 538816 541873 544278 547430 573763 576632 577357 581348 598348 621313 621976 574291 543480 562843 690902 563530 620148 541887 559324 576695 568287 690831 716323 550327 620164 619466 544478 560076 570394 692237 648204 561028 576636 576707 576722 580252 560085 566696 541674 563532 574269 576625 576694 580258 648256 699697 590954 622981 615741 615757 621305 615748 629899 560924 566697 670113 621307 699574 571445 541398 583885 541725 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.30%) |
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 538816 538837 538949 541398 541637 541674 541725 541873 541887 543480 544278 544478 547430 549220 550327 559324 560076 560085 560924 560958 561026 561028 562843 563530 563532 563540 566696 566697 566760 567396 568287 570394 571441 571445 573763 574237 574269 574291 576625 576632 576633 576636 576694 576695 576703 576707 576722 577357 580252 580258 581348 583885 587763 587795 590948 590954 592388 598348 605330 605344 610047 615741 615748 615757 619466 619470 620145 620148 620163 620164 621305 621307 621313 621976 622372 622981 629899 643007 644264 644278 644306 644323 644643 644922 644968 648204 648256 651199 670093 670113 670773 671739 671756 684029 690803 690810 690831 690902 691820 692237 692786 693030 694563 695249 697266 699574 699606 699607 699697 703039 703080 706899 708422 716177 716323 723480 748695 784247 789844 801471 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal hairy vintage"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал волосатая vintage"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал волосатая vintage"
]
|
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.