Query Metrics
7
Database Queries
7
Different statements
161.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.00 ms (83.70%) |
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 385697 392538 399176 401117 408262 411700 416974 419220 419387 428603 430168 430542 431504 432565 432613 432692 432728 441157 441320 442064 444406 444558 444836 447921 448176 449169 450371 453174 453494 454401 454713 456600 458532 460024 463810 469294 470403 471612 471671 472906 475294 478333 479779 479787 482192 482195 482769 483736 492365 492523 495561 496771 500442 510177 512961 513761 518243 519497 520670 525042 526164 530725 531153 534218 534294 535546 537107 540541 550672 565907 580438 588144 589591 589647 591727 603156 604164 604489 615974 620480 623180 632570 633738 655927 684053 704925 713091 716247 720132 724194 726662 726663 726924 737130 737173 737179 737202 738480 740958 742244 755573 760811 765477 765736 769308 770833 777065 789690 790218 796168 798333 800578 801963 806022 806138 808622 808972 810817 814924 820768 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (10.00%) |
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 820768 482769 471671 530725 537107 526164 534294 580438 716247 704925 713091 684053 633738 603156 796168 806022 808972 798333 800578 742244 755573 769308 801963 724194 726663 770833 737173 738480 760811 765477 726662 737179 737202 726924 737130 765736 720132 777065 806138 808622 810817 419220 565907 655927 589647 591727 518243 588144 456600 460024 454401 454713 385697 401117 416974 419387 432613 441157 441320 444558 447921 450371 453174 492365 463810 535546 520670 540541 483736 604489 615974 604164 623180 632570 458532 399176 479787 411700 478333 534218 513761 392538 469294 470403 472906 512961 525042 428603 430542 500442 492523 519497 408262 740958 471612 790218 789690 475294 432565 482195 442064 453494 589591 510177 620480 496771 432692 444836 432728 444406 430168 431504 814924 448176 449169 479779 531153 495561 482192 550672 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.79%) |
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 385697 392538 399176 401117 408262 411700 416974 419220 419387 428603 430168 430542 431504 432565 432613 432692 432728 441157 441320 442064 444406 444558 444836 447921 448176 449169 450371 453174 453494 454401 454713 456600 458532 460024 463810 469294 470403 471612 471671 472906 475294 478333 479779 479787 482192 482195 482769 483736 492365 492523 495561 496771 500442 510177 512961 513761 518243 519497 520670 525042 526164 530725 531153 534218 534294 535546 537107 540541 550672 565907 580438 588144 589591 589647 591727 603156 604164 604489 615974 620480 623180 632570 633738 655927 684053 704925 713091 716247 720132 724194 726662 726663 726924 737130 737173 737179 737202 738480 740958 742244 755573 760811 765477 765736 769308 770833 777065 789690 790218 796168 798333 800578 801963 806022 806138 808622 808972 810817 814924 820768 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina mature anal"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская mature анал"
]
|
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.