Query Metrics
7
Database Queries
7
Different statements
172.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.11 ms (83.04%) |
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 415425 417011 419248 419265 421547 423177 423363 423642 425112 425554 426080 427580 430430 431740 432732 434629 435774 436490 436578 436608 437402 440164 442415 442443 445859 445884 448729 449849 451162 452696 453872 453952 453957 454538 454874 458317 459255 460318 462475 463065 463222 464796 465539 466286 469500 472411 473617 473703 475309 477408 481636 482277 482741 484943 485841 486925 489609 490031 490468 492137 492474 493214 493773 498187 498424 498639 499154 499326 502867 504937 505549 506036 514776 521494 523760 524518 525173 525696 532820 536906 538280 543907 546600 549499 549815 551584 551778 551787 553102 554248 556206 557922 560919 562409 563575 563718 563924 566337 570838 570960 571804 574035 578569 579686 586401 598178 609672 617020 619125 663318 668459 681910 682259 684975 693629 716974 724896 771275 776703 803144 ] |
||||||||||||||||||||||||||||||
|
19.13 ms (11.10%) |
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 415425 419265 423642 426080 442415 445859 460318 477408 490468 449849 458317 464796 492474 454538 505549 525173 473703 563924 571804 578569 549499 556206 557922 570960 682259 668459 693629 554248 560919 562409 563575 563718 570838 598178 586401 619125 803144 724896 771275 609672 617020 716974 776703 431740 434629 442443 448729 465539 430430 436578 440164 445884 473617 453957 463065 437402 472411 514776 485841 486925 489609 524518 498639 579686 423177 435774 417011 466286 499326 551584 423363 453872 482277 425554 425112 499154 502867 551787 553102 451162 492137 523760 484943 419248 521494 421547 427580 432732 436490 436608 463222 469500 452696 453952 454874 462475 475309 481636 482741 490031 459255 493773 498424 525696 504937 506036 532820 536906 498187 538280 493214 543907 551778 566337 549815 574035 684975 663318 681910 546600 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov sleeping"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
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 415425 417011 419248 419265 421547 423177 423363 423642 425112 425554 426080 427580 430430 431740 432732 434629 435774 436490 436578 436608 437402 440164 442415 442443 445859 445884 448729 449849 451162 452696 453872 453952 453957 454538 454874 458317 459255 460318 462475 463065 463222 464796 465539 466286 469500 472411 473617 473703 475309 477408 481636 482277 482741 484943 485841 486925 489609 490031 490468 492137 492474 493214 493773 498187 498424 498639 499154 499326 502867 504937 505549 506036 514776 521494 523760 524518 525173 525696 532820 536906 538280 543907 546600 549499 549815 551584 551778 551787 553102 554248 556206 557922 560919 562409 563575 563718 563924 566337 570838 570960 571804 574035 578569 579686 586401 598178 609672 617020 619125 663318 668459 681910 682259 684975 693629 716974 724896 771275 776703 803144 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов спящ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
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.