Query Metrics
7
Database Queries
7
Different statements
161.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.62 ms (81.48%) |
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 36844 65533 249773 395574 395985 396645 396844 403397 404968 409995 415230 417491 418369 418494 422010 422409 424387 426323 428029 428587 429945 433164 437635 439769 439800 439886 443481 443590 443987 445795 446358 447146 447425 447434 447435 447438 447444 447480 447486 447499 447514 447519 447532 447549 447750 448519 448876 452593 454726 454836 454842 458172 460217 461462 462009 463965 464185 465879 468345 469189 473208 478485 482335 484525 484893 485138 485228 485389 486275 487189 487206 489522 490786 490982 491326 491667 491683 491689 491718 492553 492822 493480 493677 494892 496040 497426 497580 502634 502763 505130 510392 510393 510612 512257 512333 513313 513346 513655 514796 515096 519841 521082 521588 524793 526136 526776 527378 527610 527629 529557 530478 816623 818209 821035 821666 822180 823759 825566 826069 826221 ] |
||||||||||||||||||||||||||||||
|
19.33 ms (11.97%) |
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 424387 428587 433164 437635 447438 447514 447519 447549 448519 454836 458172 461462 404968 409995 415230 418369 418494 422409 426323 439769 439800 439886 443481 443590 443987 447146 447425 447434 447435 447444 447480 447532 447750 448876 454726 454842 463965 465879 473208 417491 428029 429945 447486 447499 452593 464185 512257 524793 526776 527629 486275 491667 491683 492822 493480 497426 497580 502763 505130 512333 513346 527378 484893 485138 487189 490786 490982 491326 491718 492553 510392 510393 510612 513313 513655 519841 521588 529557 530478 487206 489522 491689 496040 502634 514796 249773 395574 395985 65533 396645 396844 403397 422010 821666 823759 826069 816623 826221 825566 818209 821035 822180 36844 462009 469189 478485 482335 493677 445795 460217 485389 446358 468345 484525 485228 494892 515096 521082 526136 527610 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.72%) |
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 36844 65533 249773 395574 395985 396645 396844 403397 404968 409995 415230 417491 418369 418494 422010 422409 424387 426323 428029 428587 429945 433164 437635 439769 439800 439886 443481 443590 443987 445795 446358 447146 447425 447434 447435 447438 447444 447480 447486 447499 447514 447519 447532 447549 447750 448519 448876 452593 454726 454836 454842 458172 460217 461462 462009 463965 464185 465879 468345 469189 473208 478485 482335 484525 484893 485138 485228 485389 486275 487189 487206 489522 490786 490982 491326 491667 491683 491689 491718 492553 492822 493480 493677 494892 496040 497426 497580 502634 502763 505130 510392 510393 510612 512257 512333 513313 513346 513655 514796 515096 519841 521082 521588 524793 526136 526776 527378 527610 527629 529557 530478 816623 818209 821035 821666 822180 823759 825566 826069 826221 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white teen"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white teen"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white teen"
]
|
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.