Query Metrics
7
Database Queries
7
Different statements
205.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.71 ms (90.64%) |
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 233941 366053 386589 387944 388523 393122 398685 405987 410699 416646 422320 422816 425288 427162 428687 441957 450830 452997 453151 455345 457257 461314 462215 466703 472853 473454 473696 479690 491344 493119 493861 495101 498892 499545 500182 500958 502472 503294 503689 504044 504075 505924 506571 506743 511821 512144 513196 515296 515409 515443 515540 520298 524741 525228 528536 529396 529918 529986 531265 534467 536711 541030 541167 541298 541460 542915 543272 545623 548002 548373 548395 550237 551665 551914 552576 552937 553166 556843 557001 557581 559266 560084 560145 560275 561372 561660 562624 564283 564640 566332 567950 570033 575195 577481 578079 579441 580218 582036 584149 586994 589657 594941 600307 600437 600518 601143 603366 604422 605147 609076 610052 611298 622607 653506 657322 661060 663389 687155 690881 ] |
||||||||||||||||||||||||||||||
|
10.15 ms (4.93%) |
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 552576 557581 560084 560145 561372 561660 575195 577481 687155 657322 661060 663389 690881 653506 551665 552937 557001 570033 579441 589657 601143 605147 600307 600437 600518 604422 611298 610052 586994 594941 622607 603366 609076 398685 422320 233941 405987 422816 366053 388523 425288 503294 495101 491344 515443 525228 515296 386589 393122 387944 416646 441957 410699 427162 428687 452997 455345 457257 466703 479690 493119 450830 453151 473454 473696 462215 504044 504075 506571 512144 513196 524741 529396 531265 498892 499545 500182 500958 503689 528536 529986 536711 502472 505924 506743 515409 520298 526388 529918 511821 515540 534467 461314 472853 493861 541460 543272 548002 550237 556843 559266 560275 562624 584149 541030 541167 542915 553166 564283 564640 566332 567950 578079 580218 582036 541298 545623 548373 548395 551914 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"задрала"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.11%) |
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 233941 366053 386589 387944 388523 393122 398685 405987 410699 416646 422320 422816 425288 427162 428687 441957 450830 452997 453151 455345 457257 461314 462215 466703 472853 473454 473696 479690 491344 493119 493861 495101 498892 499545 500182 500958 502472 503294 503689 504044 504075 505924 506571 506743 511821 512144 513196 515296 515409 515443 515540 520298 524741 525228 528536 529396 529918 529986 531265 534467 536711 541030 541167 541298 541460 542915 543272 545623 548002 548373 548395 550237 551665 551914 552576 552937 553166 556843 557001 557581 559266 560084 560145 560275 561372 561660 562624 564283 564640 566332 567950 570033 575195 577481 578079 579441 580218 582036 584149 586994 589657 594941 600307 600437 600518 601143 603366 604422 605147 609076 610052 611298 622607 653506 657322 661060 663389 687155 690881 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"задра"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.