Query Metrics
7
Database Queries
7
Different statements
221.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.87 ms (88.31%) |
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 213 27593 382097 397548 397714 398870 400235 413948 418359 419912 419914 420006 420235 422348 424007 424398 427517 428891 436478 441439 447780 448393 450858 453037 453068 454913 455020 455798 456869 457019 457041 457043 457603 457713 457718 457720 457739 457778 457783 457788 457791 457800 465706 470664 472805 472811 472930 473289 473773 476588 483756 484866 487215 488214 488532 490201 495871 499565 504909 506789 513544 514980 519815 523047 523561 526277 526540 526559 527546 527561 527564 528692 534370 535008 540059 543597 547675 549521 556082 558111 561613 562262 562364 562369 562370 563109 568193 568709 577409 598921 601828 603704 606574 613463 617984 619508 621342 680962 710034 728068 738440 755030 779618 784804 788262 793024 793175 816816 816862 817788 817798 818742 819066 819428 822974 828008 828092 828246 828314 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (7.24%) |
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 457783 528692 428891 457041 447780 473289 398870 424007 453037 473773 454913 606574 617984 621342 793175 784804 755030 779618 527564 562364 483756 213 382097 523047 526277 568193 738440 418359 526559 613463 453068 619508 523561 448393 728068 490201 457778 543597 601828 419912 506789 457791 397548 455020 504909 472930 527561 549521 457713 457603 562369 495871 558111 598921 788262 450858 488214 526540 577409 424398 457019 457739 441439 476588 680962 828092 568709 514980 27593 793024 457718 534370 400235 547675 427517 816816 816862 457043 540059 710034 420235 819066 817788 513544 419914 456869 499565 488532 422348 413948 562370 420006 519815 472805 436478 457720 828246 819428 465706 527546 535008 556082 457788 472811 457800 563109 817798 828314 828093 484866 818742 822974 562262 561613 397714 470664 603704 828008 455798 487215 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.21%) |
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 213 27593 382097 397548 397714 398870 400235 413948 418359 419912 419914 420006 420235 422348 424007 424398 427517 428891 436478 441439 447780 448393 450858 453037 453068 454913 455020 455798 456869 457019 457041 457043 457603 457713 457718 457720 457739 457778 457783 457788 457791 457800 465706 470664 472805 472811 472930 473289 473773 476588 483756 484866 487215 488214 488532 490201 495871 499565 504909 506789 513544 514980 519815 523047 523561 526277 526540 526559 527546 527561 527564 528692 534370 535008 540059 543597 547675 549521 556082 558111 561613 562262 562364 562369 562370 563109 568193 568709 577409 598921 601828 603704 606574 613463 617984 619508 621342 680962 710034 728068 738440 755030 779618 784804 788262 793024 793175 816816 816862 817788 817798 818742 819066 819428 822974 828008 828092 828246 828314 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits beach"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.71%) |
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.