Query Metrics
7
Database Queries
7
Different statements
462.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
274.91 ms (59.48%) |
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 466271 439475 440913 432647 549728 680441 187919 425532 429809 820385 7169 401064 401130 447474 470966 799127 411370 441001 443820 443999 428139 443726 490438 716404 796079 451473 501462 818167 796148 320525 7396 404474 406896 440087 440399 408175 414708 423494 428548 449377 465164 460503 614347 777420 760827 463856 440403 404590 436948 426608 536422 282010 477072 513839 421939 439674 504093 322815 382352 33917 55966 411684 409164 437793 488454 446728 470147 465615 468545 755996 761134 726923 411821 412790 401101 463848 519585 493172 801269 750305 391472 404629 585158 479112 490138 433475 465524 571035 384420 383650 382134 58701 6591 387915 390378 397918 404491 406593 410954 428114 429531 430468 407378 432613 409932 416859 432727 420174 436883 430432 432650 465209 466693 477116 462607 452774 457644 458011 465707 465961 ] |
||||||||||||||||||||||||||||||
|
177.78 ms (38.47%) |
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 6591 7169 7396 33917 55966 58701 187919 282010 320525 322815 382134 382352 383650 384420 387915 390378 391472 397918 401064 401101 401130 404474 404491 404590 404629 406593 406896 407378 408175 409164 409932 410954 411370 411684 411821 412790 414708 416859 420174 421939 423494 425532 426608 428114 428139 428548 429531 429809 430432 430468 432613 432647 432650 432727 433475 436883 436948 437793 439475 439674 440087 440399 440403 440913 441001 443726 443820 443999 446728 447474 449377 451473 452774 457644 458011 460503 462607 463848 463856 465164 465209 465524 465615 465707 465961 466271 466693 468545 470147 470966 477072 477116 479112 488454 490138 490438 493172 501462 504093 513839 519585 536422 549728 571035 585158 614347 680441 716404 726923 750305 755996 760827 761134 777420 796079 796148 799127 801269 818167 820385 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.64%) |
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 6591 7169 7396 33917 55966 58701 187919 282010 320525 322815 382134 382352 383650 384420 387915 390378 391472 397918 401064 401101 401130 404474 404491 404590 404629 406593 406896 407378 408175 409164 409932 410954 411370 411684 411821 412790 414708 416859 420174 421939 423494 425532 426608 428114 428139 428548 429531 429809 430432 430468 432613 432647 432650 432727 433475 436883 436948 437793 439475 439674 440087 440399 440403 440913 441001 443726 443820 443999 446728 447474 449377 451473 452774 457644 458011 460503 462607 463848 463856 465164 465209 465524 465615 465707 465961 466271 466693 468545 470147 470966 477072 477116 479112 488454 490138 490438 493172 501462 504093 513839 519585 536422 549728 571035 585158 614347 680441 716404 726923 750305 755996 760827 761134 777420 796079 796148 799127 801269 818167 820385 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal boy-milf"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал парен milf"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал парен milf"
]
|
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.