Query Metrics
7
Database Queries
7
Different statements
144.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.32 ms (82.38%) |
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 385190 389593 392848 401801 416616 417975 421612 423711 423933 425645 429037 430261 434544 435658 436523 442979 443481 445329 447797 453984 454759 454901 455167 462986 463435 468465 468574 468925 470086 472799 473666 474337 474814 477851 478556 485111 486138 486965 487916 500686 502705 503914 503928 509144 510068 510221 512550 512881 515017 520526 521301 522584 524334 524765 526588 527068 534011 535495 538714 542381 542400 543549 551088 553974 554168 558618 564055 564678 566525 567295 567766 568082 576024 580284 583108 586833 587731 587912 588376 589971 590979 593927 601791 602722 603441 604056 604265 606668 607283 607601 618853 621163 636633 650213 655333 657651 663332 666355 668690 674758 699201 700701 712140 740737 751608 778691 782740 783332 786798 787960 790059 791900 792598 804612 807505 812033 813781 819101 819114 822681 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (11.11%) |
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 666355 674758 568082 576024 587912 416616 430261 442979 474337 455167 468574 462986 522584 486965 510068 510221 521301 503928 786798 819114 782740 603441 385190 454759 472799 535495 554168 567295 655333 712140 601791 790059 751608 791900 804612 807505 515017 445329 487916 524334 524765 564055 566525 567766 564678 588376 443481 526588 500686 503914 586833 778691 822681 819101 700701 657651 812033 740737 813781 792598 580284 392848 417975 436523 434544 435658 421612 423711 423933 453984 454901 468925 477851 485111 470086 502705 512881 520526 534011 538714 509144 512550 527068 473666 474814 486138 542400 551088 558618 543549 542381 553974 583108 663332 650213 699201 668690 602722 618853 636633 590979 604265 606668 607283 587731 589971 593927 604056 621163 783332 787960 607601 401801 425645 463435 468465 429037 447797 478556 389593 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.77%) |
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 385190 389593 392848 401801 416616 417975 421612 423711 423933 425645 429037 430261 434544 435658 436523 442979 443481 445329 447797 453984 454759 454901 455167 462986 463435 468465 468574 468925 470086 472799 473666 474337 474814 477851 478556 485111 486138 486965 487916 500686 502705 503914 503928 509144 510068 510221 512550 512881 515017 520526 521301 522584 524334 524765 526588 527068 534011 535495 538714 542381 542400 543549 551088 553974 554168 558618 564055 564678 566525 567295 567766 568082 576024 580284 583108 586833 587731 587912 588376 589971 590979 593927 601791 602722 603441 604056 604265 606668 607283 607601 618853 621163 636633 650213 655333 657651 663332 666355 668690 674758 699201 700701 712140 740737 751608 778691 782740 783332 786798 787960 790059 791900 792598 804612 807505 812033 813781 819101 819114 822681 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long girls"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
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.