Query Metrics
7
Database Queries
7
Different statements
202.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.78 ms (86.19%) |
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 387711 388554 391002 391380 392599 393102 395579 397883 398947 400209 401226 404429 407648 407685 407700 407703 407759 407761 407802 409109 411468 411695 411777 416791 417080 420119 422171 430377 450801 450847 454043 454211 454230 456605 457446 457989 458011 460127 460188 460677 460915 464553 466164 466965 467838 469283 469487 469509 470275 470289 471403 472166 474824 475884 479027 481937 482374 482386 484443 490167 490424 496112 504091 504104 506833 510824 516473 517267 518851 520864 522480 529398 533022 533568 534241 546687 546950 560400 561492 562976 562987 563123 563212 563436 563453 568156 573342 590303 590735 591137 591346 599726 702978 714752 714908 716324 725579 726831 728291 730352 732171 733817 734227 736399 738961 740792 770164 774763 781446 786455 788287 788295 789527 790640 796012 816766 818665 823637 823693 823710 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (8.53%) |
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 725579 392599 407685 469509 702978 816766 818665 823637 823693 533022 774763 789527 732171 407761 411777 458011 563436 546687 546950 736399 393102 397883 482386 454230 474824 391380 469283 407759 475884 522480 484443 520864 409109 404429 401226 482374 714908 733817 738961 388554 391002 457989 464553 467838 562976 563123 714752 591346 591137 781446 788287 790640 726831 728291 770164 716324 387711 407700 460127 411695 407802 529398 560400 479027 470275 411468 516473 490424 518851 395579 407703 420119 472166 534241 496112 504104 563212 561492 573342 563453 590303 788295 481937 417080 460915 470289 454211 407648 466965 510824 456605 506833 460677 796012 466164 398947 568156 734227 450801 454043 562987 590735 786455 469487 460188 416791 430377 533568 490167 740792 400209 471403 450847 517267 599726 422171 457446 504091 730352 823710 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.54%) |
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 387711 388554 391002 391380 392599 393102 395579 397883 398947 400209 401226 404429 407648 407685 407700 407703 407759 407761 407802 409109 411468 411695 411777 416791 417080 420119 422171 430377 450801 450847 454043 454211 454230 456605 457446 457989 458011 460127 460188 460677 460915 464553 466164 466965 467838 469283 469487 469509 470275 470289 471403 472166 474824 475884 479027 481937 482374 482386 484443 490167 490424 496112 504091 504104 506833 510824 516473 517267 518851 520864 522480 529398 533022 533568 534241 546687 546950 560400 561492 562976 562987 563123 563212 563436 563453 568156 573342 590303 590735 591137 591346 599726 702978 714752 714908 716324 725579 726831 728291 730352 732171 733817 734227 736399 738961 740792 770164 774763 781446 786455 788287 788295 789527 790640 796012 816766 818665 823637 823693 823710 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен mature mom"
]
|
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.