Query Metrics
7
Database Queries
7
Different statements
178.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.99 ms (81.08%) |
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 45357 384015 390042 393456 394243 395518 395699 398164 398947 399500 399515 400171 400199 400588 401224 401956 403100 406203 409324 411952 412261 413433 415584 415655 417305 417662 418043 419093 419417 421071 421357 422272 422278 422498 424903 424982 425562 425835 428920 429043 430839 434609 435736 435747 436419 436809 437322 437815 442422 444428 444739 445511 449405 449853 450161 450181 450777 450830 451713 452766 453013 454048 457463 457875 459259 459544 460248 461260 465988 468793 471629 472913 476780 477815 482610 483499 486349 488616 496239 499125 499495 514887 515839 524204 524245 524277 524413 524598 526613 534845 539480 546754 553277 554963 563148 563151 565625 568057 583632 591296 598784 606569 607030 608413 683424 715247 728291 730381 743858 748892 758443 759493 765243 770006 774316 793997 809186 818488 827903 827909 ] |
||||||||||||||||||||||||||||||
|
23.38 ms (13.08%) |
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 395518 436419 445511 450777 514887 598784 809186 770006 45357 398947 384015 425835 459544 482610 563151 591296 419417 421357 435736 524245 483499 486349 393456 400588 449853 450830 793997 748892 758443 743858 759493 390042 468793 534845 430839 399500 417662 419093 444739 424982 818488 827909 827903 454048 526613 715247 730381 728291 422272 409324 472913 437322 444428 412261 568057 415655 421071 499125 395699 398164 401956 401224 422278 436809 435747 411952 429043 442422 465988 451713 524277 539480 496239 461260 553277 546754 554963 608413 607030 765243 774316 606569 413433 418043 434609 452766 415584 425562 450161 399515 403100 417305 499495 515839 437815 471629 394243 400171 400199 406203 424903 428920 422498 457463 477815 449405 450181 457875 460248 453013 459259 476780 524413 524204 524598 488616 583632 563148 683424 565625 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.61%) |
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 45357 384015 390042 393456 394243 395518 395699 398164 398947 399500 399515 400171 400199 400588 401224 401956 403100 406203 409324 411952 412261 413433 415584 415655 417305 417662 418043 419093 419417 421071 421357 422272 422278 422498 424903 424982 425562 425835 428920 429043 430839 434609 435736 435747 436419 436809 437322 437815 442422 444428 444739 445511 449405 449853 450161 450181 450777 450830 451713 452766 453013 454048 457463 457875 459259 459544 460248 461260 465988 468793 471629 472913 476780 477815 482610 483499 486349 488616 496239 499125 499495 514887 515839 524204 524245 524277 524413 524598 526613 534845 539480 546754 553277 554963 563148 563151 565625 568057 583632 591296 598784 606569 607030 608413 683424 715247 728291 730381 743858 748892 758443 759493 765243 770006 774316 793997 809186 818488 827903 827909 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step blonde"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step беловолосая"
]
|
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.