Query Metrics
7
Database Queries
7
Different statements
170.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.03 ms (87.36%) |
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 384047 407698 409233 409305 409971 413130 420474 460555 467138 491867 527266 529845 530465 531055 532112 533187 533411 533821 535476 539570 541187 543258 543468 544321 547705 556800 557808 566555 570844 576579 586443 588219 597981 608826 616536 633009 642745 642764 643406 645842 647058 650012 654663 661944 662030 668605 677590 680878 681184 685475 686763 692222 699580 699698 707361 710419 724280 724842 728870 730452 734016 742911 746851 747540 748733 750922 762218 769950 770015 772007 772694 772997 773041 773073 774364 775626 777181 777450 779764 781244 783264 786142 788603 792538 797500 797703 797779 799248 801493 804383 808148 811381 814943 815908 815909 815920 815966 816023 816080 816181 816212 816724 817093 818212 818420 818632 819000 820653 821492 821916 822045 822316 822458 822783 824472 825882 827305 828006 828539 ] |
||||||||||||||||||||||||||||||
|
11.72 ms (6.87%) |
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 816080 816212 818212 819000 821492 822783 815908 815909 815920 815966 816023 820653 822045 825882 828006 827305 460555 491867 529845 533411 532112 527266 533187 533821 535476 530465 539570 467138 543468 547705 544321 543258 556800 566555 576579 645842 699698 647058 654663 668605 680878 685475 692222 699580 650012 661944 677590 557808 570844 583788 588219 597981 642745 586443 616536 643406 788603 792538 797500 797779 801493 804383 775626 777450 779764 797703 734016 742911 746851 747540 750922 772694 783264 808148 811381 769950 772007 772997 748733 762218 770015 773073 774364 724280 728870 730452 724842 773041 608826 633009 642764 710419 777181 781244 786142 799248 409233 409305 409971 384047 407698 413130 420474 816181 818420 818632 822458 814943 816724 822316 817093 821916 824472 828539 531055 541187 662030 686763 681184 707361 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.69%) |
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 384047 407698 409233 409305 409971 413130 420474 460555 467138 491867 527266 529845 530465 531055 532112 533187 533411 533821 535476 539570 541187 543258 543468 544321 547705 556800 557808 566555 570844 576579 586443 588219 597981 608826 616536 633009 642745 642764 643406 645842 647058 650012 654663 661944 662030 668605 677590 680878 681184 685475 686763 692222 699580 699698 707361 710419 724280 724842 728870 730452 734016 742911 746851 747540 748733 750922 762218 769950 770015 772007 772694 772997 773041 773073 774364 775626 777181 777450 779764 781244 783264 786142 788603 792538 797500 797703 797779 799248 801493 804383 808148 811381 814943 815908 815909 815920 815966 816023 816080 816181 816212 816724 817093 818212 818420 818632 819000 820653 821492 821916 822045 822316 822458 822783 824472 825882 827305 828006 828539 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick for mom"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член mom"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член mom"
]
|
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.