Query Metrics
7
Database Queries
7
Different statements
147.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.68 ms (83.31%) |
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 7213 172164 383158 383270 384139 390345 397350 398188 400850 400975 404491 404722 405897 406921 408765 411471 411899 412015 413567 413795 415553 415919 416286 417313 417875 418867 419124 419807 420143 421734 422382 425478 425816 427326 430290 430683 438970 440758 443229 444336 446737 448826 450371 452227 452398 453030 453270 454328 456211 457174 458137 459228 459879 460073 460554 462362 462602 463084 465193 467275 468772 469011 469014 469831 469945 470304 472166 473459 474443 474444 474752 475314 477892 480411 482733 485159 486782 486855 488885 489598 498671 502609 506783 509429 509636 511283 512923 514273 517356 521056 521152 522203 523101 524247 524468 526980 529542 530372 531269 531403 532851 535591 536604 536884 542486 542689 547567 560106 561313 568365 574355 574372 647302 658110 714675 729999 808863 815772 818680 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (10.24%) |
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 523101 542689 400850 404722 417313 422382 416286 469011 470304 411899 419124 459879 469014 509429 517356 384139 172164 7213 404491 405897 408765 421734 430290 425478 427326 446737 450371 462362 465193 448826 457174 468772 469831 472166 474444 486782 453030 454328 458137 462602 467275 474752 475314 477892 482733 532851 535591 536884 521056 529542 506783 512923 524468 531403 474443 480411 488885 547567 560106 542486 561313 574355 647302 658110 729999 808863 400975 413567 459228 463084 469945 398188 418867 419807 443229 411471 425816 438970 444336 383158 397350 413795 415553 430683 456211 417875 512847 509636 514273 524247 485159 489598 498671 526980 521152 502609 415919 452227 511283 486855 568365 460554 522203 383270 390345 420143 406921 412015 440758 815772 818680 452398 473459 453270 460073 531269 536604 530372 574372 714675 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.88%) |
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 7213 172164 383158 383270 384139 390345 397350 398188 400850 400975 404491 404722 405897 406921 408765 411471 411899 412015 413567 413795 415553 415919 416286 417313 417875 418867 419124 419807 420143 421734 422382 425478 425816 427326 430290 430683 438970 440758 443229 444336 446737 448826 450371 452227 452398 453030 453270 454328 456211 457174 458137 459228 459879 460073 460554 462362 462602 463084 465193 467275 468772 469011 469014 469831 469945 470304 472166 473459 474443 474444 474752 475314 477892 480411 482733 485159 486782 486855 488885 489598 498671 502609 506783 509429 509636 511283 512923 514273 517356 521056 521152 522203 523101 524247 524468 526980 529542 530372 531269 531403 532851 535591 536604 536884 542486 542689 547567 560106 561313 568365 574355 574372 647302 658110 714675 729999 808863 815772 818680 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge white tits"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные white сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные white сиськ"
]
|
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.