Query Metrics
7
Database Queries
7
Different statements
151.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.27 ms (81.96%) |
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 7157 185143 320786 384864 386178 387652 389518 390292 390304 391064 399352 401489 404286 404737 405505 406203 406435 407549 408017 411132 414849 415691 415934 416434 418481 420091 429575 431019 441758 441820 446620 446791 447542 448337 448349 451961 454939 454974 456071 456641 463636 463867 464474 464617 475859 476328 481652 487010 487346 489410 490070 493031 497057 497635 498875 501750 501786 503892 503994 506147 510033 510041 510045 518483 518767 520417 523645 523971 526824 526834 530537 538343 538365 538675 551316 551337 551358 551402 551409 554777 560102 561669 564462 566671 572018 575118 575135 592545 611356 626152 628342 651930 653261 653308 654065 661768 662711 663957 676976 677158 682654 685754 694468 694610 697489 699542 705689 711576 714471 716318 722098 722855 743129 744601 747366 748674 749284 797909 804671 814793 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (11.40%) |
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 592545 653308 694468 404286 448349 456071 390304 454939 503892 501786 493031 391064 415934 501750 538343 523971 575118 714471 487346 431019 406203 476328 663957 7157 389518 390292 401489 408017 441758 454974 456641 538365 694610 404737 464474 429575 411132 538675 518767 487010 566671 653261 685754 682654 611356 526834 814793 654065 662711 705689 661768 677158 551316 628342 626152 804671 749284 743129 747366 748674 697489 699542 716318 722855 399352 475859 797909 490070 551358 651930 416434 711576 384864 320786 406435 415691 481652 463636 446620 464617 497635 510041 510045 503994 530537 506147 551402 551337 551409 744601 418481 387652 420091 441820 447542 446791 448337 498875 510033 520417 523645 564462 561669 572018 489410 518483 414849 497057 463867 185143 405505 560102 575135 676976 722098 526824 407549 386178 451961 554777 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.81%) |
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 7157 185143 320786 384864 386178 387652 389518 390292 390304 391064 399352 401489 404286 404737 405505 406203 406435 407549 408017 411132 414849 415691 415934 416434 418481 420091 429575 431019 441758 441820 446620 446791 447542 448337 448349 451961 454939 454974 456071 456641 463636 463867 464474 464617 475859 476328 481652 487010 487346 489410 490070 493031 497057 497635 498875 501750 501786 503892 503994 506147 510033 510041 510045 518483 518767 520417 523645 523971 526824 526834 530537 538343 538365 538675 551316 551337 551358 551402 551409 554777 560102 561669 564462 566671 572018 575118 575135 592545 611356 626152 628342 651930 653261 653308 654065 661768 662711 663957 676976 677158 682654 685754 694468 694610 697489 699542 705689 711576 714471 716318 722098 722855 743129 744601 747366 748674 749284 797909 804671 814793 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big dick"
]
|
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.