Query Metrics
7
Database Queries
7
Different statements
176.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.75 ms (87.66%) |
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 384514 384838 386283 388769 395508 412620 413089 415425 416407 417854 420322 424388 426934 427045 428443 428466 430486 434193 437338 439441 440702 440741 442415 442443 443818 447687 447813 449346 449853 450855 454046 454398 454862 454863 454869 457186 459371 459685 464480 467354 478948 482485 493188 493217 499326 506186 515009 515772 521361 530347 543638 547518 550616 552905 554248 556508 557484 559535 563112 563680 565650 579921 580266 591119 593873 596704 603014 604698 609423 610275 613239 622412 623147 623230 623358 625100 627626 644664 663375 663512 664831 664854 665342 687441 693396 697650 705070 707876 715387 726470 726561 726598 728271 728455 728927 738013 739612 742862 742956 748337 775155 776703 795287 799556 800942 801950 803719 805283 805819 807284 807728 809493 810521 810831 811219 812566 812785 817974 825328 ] |
||||||||||||||||||||||||||||||
|
12.27 ms (6.95%) |
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 416407 426934 454862 493188 554248 427045 412620 552905 687441 663375 697650 563680 604698 622412 609423 610275 805283 807284 812785 739612 774140 728455 742956 728927 805819 467354 430486 559535 424388 428466 384838 825328 817974 449853 515772 665342 693396 579921 596704 623147 625100 812566 803719 726598 420322 454863 440741 565650 493217 439441 482485 563112 664831 707876 663512 623230 603014 810521 795287 644664 417854 591119 454046 447687 521361 428443 395508 413089 415425 434193 440702 442415 447813 464480 530347 515009 547518 580266 543638 557484 705070 664854 715387 550616 627626 613239 593873 799556 801950 807728 809493 810831 775155 748337 726470 726561 728271 742862 738013 623358 776703 459371 442443 454398 459685 443818 388769 449346 506186 386283 800942 811219 384514 556508 437338 457186 499326 450855 454869 478948 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.75%) |
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 384514 384838 386283 388769 395508 412620 413089 415425 416407 417854 420322 424388 426934 427045 428443 428466 430486 434193 437338 439441 440702 440741 442415 442443 443818 447687 447813 449346 449853 450855 454046 454398 454862 454863 454869 457186 459371 459685 464480 467354 478948 482485 493188 493217 499326 506186 515009 515772 521361 530347 543638 547518 550616 552905 554248 556508 557484 559535 563112 563680 565650 579921 580266 591119 593873 596704 603014 604698 609423 610275 613239 622412 623147 623230 623358 625100 627626 644664 663375 663512 664831 664854 665342 687441 693396 697650 705070 707876 715387 726470 726561 726598 728271 728455 728927 738013 739612 742862 742956 748337 775155 776703 795287 799556 800942 801950 803719 805283 805819 807284 807728 809493 810521 810831 811219 812566 812785 817974 825328 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочит во сне"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк спящ"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.73%) |
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.