Query Metrics
7
Database Queries
7
Different statements
161.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.96 ms (81.34%) |
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 399192 400857 416169 417438 418834 418861 419124 425070 426369 427113 427311 427536 430291 433186 437577 437797 440657 442783 444135 444844 445543 447704 448216 449169 450382 451840 453384 453425 454911 455048 455899 455956 459240 459890 462959 464557 466747 466855 469488 469550 472028 472244 474549 475185 475632 476112 478036 478298 478928 478973 480568 480834 481519 481663 481970 482123 482684 483184 483534 484521 484942 487191 487632 487643 490869 491997 492096 492703 493464 493788 493825 495143 495660 496119 496809 497236 497952 501461 502679 504799 507036 508160 509309 509703 510596 511413 511476 513550 513603 515736 515796 517922 518241 519995 520551 521813 524846 526170 528753 529075 532721 535535 538416 546044 547864 558303 558762 582439 587130 588329 602312 612008 613129 623421 629882 633498 650488 671950 676535 802379 ] |
||||||||||||||||||||||||||||||
|
18.93 ms (11.76%) |
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 521813 528753 400857 427311 426369 448216 425070 475632 495660 509703 487632 511476 510596 613129 588329 444844 558762 633498 612008 478973 518241 493464 501461 513603 416169 437577 437797 440657 417438 430291 433186 418834 482684 449169 455899 474549 447704 451840 454911 466855 469488 469550 476112 482123 484521 484942 455048 459890 472244 481663 493825 532721 538416 496809 535535 495143 497236 507036 515796 464557 478036 478298 480834 547864 546044 558303 650488 671950 676535 802379 418861 453425 462959 475185 455956 459240 466747 472028 399192 427536 442783 453384 481970 419124 444135 450382 480568 481519 427113 478928 508160 519995 524846 483184 492703 502679 511413 513550 517922 520551 526170 529075 487191 490869 491997 504799 509309 515736 487643 492096 493788 496119 497952 623421 483534 582439 602312 629882 587130 445543 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.80%) |
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 399192 400857 416169 417438 418834 418861 419124 425070 426369 427113 427311 427536 430291 433186 437577 437797 440657 442783 444135 444844 445543 447704 448216 449169 450382 451840 453384 453425 454911 455048 455899 455956 459240 459890 462959 464557 466747 466855 469488 469550 472028 472244 474549 475185 475632 476112 478036 478298 478928 478973 480568 480834 481519 481663 481970 482123 482684 483184 483534 484521 484942 487191 487632 487643 490869 491997 492096 492703 493464 493788 493825 495143 495660 496119 496809 497236 497952 501461 502679 504799 507036 508160 509309 509703 510596 511413 511476 513550 513603 515736 515796 517922 518241 519995 520551 521813 524846 526170 528753 529075 532721 535535 538416 546044 547864 558303 558762 582439 587130 588329 602312 612008 613129 623421 629882 633498 650488 671950 676535 802379 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышная красотка"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пышн красивая"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.