Query Metrics
7
Database Queries
7
Different statements
228.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.21 ms (89.30%) |
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 373897 391930 394453 420527 427266 434447 434792 437772 438748 443118 444147 447662 448414 448737 452954 452963 452978 453865 457423 461088 464533 464720 465429 466274 466294 466453 469196 469197 469686 470202 470724 470987 471981 473298 480991 486039 488051 489049 490853 492343 492641 492643 492926 494411 495298 496432 500210 501185 501905 502729 503336 503398 503512 508041 516496 517373 519068 520215 520963 522059 522548 526748 538331 543641 552270 552703 561881 565565 567766 571833 572765 575424 581402 585710 593384 598144 598482 602607 610616 613880 619902 620692 621160 623731 660274 674184 680777 686590 698165 700928 700989 702305 702310 708135 712956 718792 730042 731232 732695 734465 738288 738333 739647 742443 743684 743805 749616 758447 761601 777009 778523 778734 780784 790701 792938 800934 802225 811748 824648 825533 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (6.85%) |
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 489049 522548 492643 427266 447662 598144 470202 572765 780784 461088 465429 494411 492641 502729 373897 825533 538331 674184 702305 702310 712956 660274 698165 708135 598482 623731 619902 790701 802225 811748 731232 732695 734465 742443 761601 738288 738333 749616 758447 730042 743684 739647 743805 700928 718792 777009 778523 778734 792938 800934 473298 496432 508041 490853 443118 464533 470724 575424 585710 620692 464720 471981 453865 469197 420527 434447 466453 448737 452954 466274 501905 486039 492343 495298 503512 501185 503398 520963 571833 552270 567766 565565 593384 602607 466294 470987 448414 480991 434792 437772 457423 469686 438748 503336 488051 492926 500210 520215 526748 516496 519068 517373 581402 610616 621160 452963 452978 444147 613880 552703 469196 394453 391930 824648 522059 561881 543641 680777 700989 686590 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.14%) |
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 373897 391930 394453 420527 427266 434447 434792 437772 438748 443118 444147 447662 448414 448737 452954 452963 452978 453865 457423 461088 464533 464720 465429 466274 466294 466453 469196 469197 469686 470202 470724 470987 471981 473298 480991 486039 488051 489049 490853 492343 492641 492643 492926 494411 495298 496432 500210 501185 501905 502729 503336 503398 503512 508041 516496 517373 519068 520215 520963 522059 522548 526748 538331 543641 552270 552703 561881 565565 567766 571833 572765 575424 581402 585710 593384 598144 598482 602607 610616 613880 619902 620692 621160 623731 660274 674184 680777 686590 698165 700928 700989 702305 702310 708135 712956 718792 730042 731232 732695 734465 738288 738333 739647 742443 743684 743805 749616 758447 761601 777009 778523 778734 780784 790701 792938 800934 802225 811748 824648 825533 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк русск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation russian"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк русск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.