Query Metrics
7
Database Queries
7
Different statements
142.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.56 ms (82.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 391868 394173 400519 413072 418256 418383 420677 420761 421575 422382 422824 423523 423957 426809 432318 434432 434936 437959 438421 438725 438779 439838 440537 440613 442892 443020 444841 445224 455149 455785 457805 460388 461432 461719 462293 464721 465453 467798 468267 472113 474918 475125 475600 475852 475913 476953 478529 479281 479285 482083 482718 486126 489037 490002 495368 495454 495823 495992 497663 497818 498076 498809 500081 500184 501538 502378 504656 504870 507273 509293 510114 511099 511224 514021 514443 514775 517356 521333 524298 527978 528164 540739 542079 544015 546259 547751 549142 553251 554250 555987 558881 559459 560833 564962 569554 569996 570980 589743 740607 742326 742528 743641 747776 756165 764627 764958 765853 768988 770784 778375 780467 781586 783443 785102 786654 791921 799212 803258 803604 808547 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (10.73%) |
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 742326 742528 756165 764627 764958 765853 743641 740607 747776 768988 770784 778375 780467 781586 783443 785102 786654 791921 799212 803258 803604 808547 400519 418256 423957 432318 438421 438779 443020 444841 475125 394173 421575 439838 462293 474918 479285 391868 420677 467798 482083 418383 434432 461432 478529 434936 457805 475600 479281 511224 504870 514775 495992 500081 507273 521333 540739 495368 495454 500184 426809 482718 554250 564962 555987 570980 589743 413072 422382 464721 442892 475852 422824 455149 455785 461719 465453 420761 440537 440613 475913 460388 468267 517356 486126 497663 497818 498809 501538 509293 514021 524298 489037 490002 495823 498076 502378 510114 527978 438725 472113 437959 528164 514443 511099 423523 445224 476953 504656 542079 546259 547751 553251 569554 544015 559459 569996 549142 558881 560833 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.66%) |
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 391868 394173 400519 413072 418256 418383 420677 420761 421575 422382 422824 423523 423957 426809 432318 434432 434936 437959 438421 438725 438779 439838 440537 440613 442892 443020 444841 445224 455149 455785 457805 460388 461432 461719 462293 464721 465453 467798 468267 472113 474918 475125 475600 475852 475913 476953 478529 479281 479285 482083 482718 486126 489037 490002 495368 495454 495823 495992 497663 497818 498076 498809 500081 500184 501538 502378 504656 504870 507273 509293 510114 511099 511224 514021 514443 514775 517356 521333 524298 527978 528164 540739 542079 544015 546259 547751 549142 553251 554250 555987 558881 559459 560833 564962 569554 569996 570980 589743 740607 742326 742528 743641 747776 756165 764627 764958 765853 768988 770784 778375 780467 781586 783443 785102 786654 791921 799212 803258 803604 808547 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian face"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск face"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск face"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.05%) |
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.