Query Metrics
7
Database Queries
7
Different statements
164.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.63 ms (82.69%) |
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 390533 390642 391668 391944 411014 411478 414125 415050 417367 421050 425118 425181 426629 427128 427141 427292 428412 429859 429861 430178 434293 434376 435535 436132 439531 439572 439688 444538 445745 445961 447305 448257 456240 457541 460900 461924 462553 465148 467879 467893 471102 474800 476785 477143 477145 477246 478775 480905 484706 489228 490507 490996 495470 497560 498018 500335 500342 504781 506105 511864 512442 514043 519699 526905 528055 530005 530310 531177 531524 533765 534119 534561 536264 536382 538977 541274 542705 544404 547235 548157 552819 553808 554235 556339 556888 556909 560106 565247 569261 569554 571648 571846 575401 578724 583085 583474 599362 605725 630395 653520 662046 679357 683259 686581 700171 714497 716543 730857 738342 741981 754207 754946 762514 765731 765995 777130 786985 797561 827950 ] |
||||||||||||||||||||||||||||||
|
18.98 ms (11.57%) |
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 530005 714497 605725 434376 390533 391668 428412 439572 439688 474800 390642 429859 425118 448257 460900 489228 571648 686581 679357 700171 599362 630395 777130 797561 738342 741981 754207 765995 730857 754946 761775 762514 765731 786985 504781 554235 583085 417367 434293 436132 439531 457541 461924 467879 467893 471102 480905 411478 427292 444538 465148 421050 429861 477145 411014 414125 447305 462553 476785 477246 415050 445961 456240 500335 534561 495470 497560 498018 500342 506105 519699 528055 536382 484706 531524 531177 683259 565247 445745 478775 430178 490996 490507 391944 425181 426629 427128 427141 435535 827950 477143 533765 534119 536264 511864 512442 514043 538977 526905 530310 541274 547235 552819 553808 556339 556888 560106 569261 569554 571846 578724 548157 556909 575401 542705 544404 583474 662046 716543 653520 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.60%) |
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 390533 390642 391668 391944 411014 411478 414125 415050 417367 421050 425118 425181 426629 427128 427141 427292 428412 429859 429861 430178 434293 434376 435535 436132 439531 439572 439688 444538 445745 445961 447305 448257 456240 457541 460900 461924 462553 465148 467879 467893 471102 474800 476785 477143 477145 477246 478775 480905 484706 489228 490507 490996 495470 497560 498018 500335 500342 504781 506105 511864 512442 514043 519699 526905 528055 530005 530310 531177 531524 533765 534119 534561 536264 536382 538977 541274 542705 544404 547235 548157 552819 553808 554235 556339 556888 556909 560106 565247 569261 569554 571648 571846 575401 578724 583085 583474 599362 605725 630395 653520 662046 679357 683259 686581 700171 714497 716543 730857 738342 741981 754207 754946 762514 765731 765995 777130 786985 797561 827950 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
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.