Query Metrics
7
Database Queries
7
Different statements
180.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.12 ms (83.04%) |
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 411169 414979 418353 420440 423982 427437 427752 428133 432363 446894 446904 447079 447523 447844 448325 453362 455830 455873 458142 458912 460697 461454 463815 463929 465191 465875 468087 469641 471772 472791 473784 476776 479190 480920 482221 484845 484849 488698 489315 491040 491709 491723 491725 492358 493325 493849 498795 499836 508873 510170 513305 517549 517554 518286 519719 521353 521999 522567 522779 522792 523289 523409 526864 527625 529151 534561 536402 536494 545988 549763 551164 551275 556051 557081 559006 561829 565414 566637 569427 573461 575123 576082 576128 576393 579475 581168 590788 592573 595520 595867 595891 598540 598601 599446 601877 602802 603911 605698 608771 613936 614058 618177 620124 621122 626497 677038 720922 732899 733879 765268 768961 785871 788806 788911 791362 801280 809909 810138 814175 ] |
||||||||||||||||||||||||||||||
|
19.67 ms (10.88%) |
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 602802 595867 601877 788911 765268 791362 809909 732899 768961 810138 472791 476776 427752 455873 465875 473784 420440 471772 508873 519719 521999 493849 513305 484849 488698 491709 491723 499836 518286 523289 446894 569427 592573 432363 447844 458142 446904 482221 534561 484845 536494 549763 551164 561829 677038 559006 565414 621122 590788 598540 785871 788806 801280 720922 411169 427437 418353 428133 455830 460697 521353 522779 522792 491040 492358 498795 527625 523409 480920 453362 463929 479190 423982 517554 581168 545988 556051 576128 605698 468087 458912 469641 447523 448325 461454 447079 522567 529151 491725 493325 595891 510170 465191 595520 526864 599446 463815 489315 814175 551275 576082 566637 557081 576393 573461 575123 733879 579475 614058 613936 414979 536402 598601 603911 618177 608771 620124 517549 626497 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.87%) |
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 411169 414979 418353 420440 423982 427437 427752 428133 432363 446894 446904 447079 447523 447844 448325 453362 455830 455873 458142 458912 460697 461454 463815 463929 465191 465875 468087 469641 471772 472791 473784 476776 479190 480920 482221 484845 484849 488698 489315 491040 491709 491723 491725 492358 493325 493849 498795 499836 508873 510170 513305 517549 517554 518286 519719 521353 521999 522567 522779 522792 523289 523409 526864 527625 529151 534561 536402 536494 545988 549763 551164 551275 556051 557081 559006 561829 565414 566637 569427 573461 575123 576082 576128 576393 579475 581168 590788 592573 595520 595867 595891 598540 598601 599446 601877 602802 603911 605698 608771 613936 614058 618177 620124 621122 626497 677038 720922 732899 733879 765268 768961 785871 788806 788911 791362 801280 809909 810138 814175 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teen shower"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen shower"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen shower"
]
|
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.