Query Metrics
7
Database Queries
7
Different statements
608.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.58 ms (34.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал butt"
]
|
||||||||||||||||||||||||||||||
|
205.08 ms (33.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
171.48 ms (28.18%) |
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 402746 424129 428052 447530 454625 466196 524502 539559 541303 541686 543577 549782 550236 552091 552131 552514 554215 558247 560038 560478 560645 561621 561653 561668 561844 561880 565327 565614 567735 568897 570135 570199 570310 570469 570494 571904 572816 573078 573083 574540 574848 574910 575475 575566 575770 575798 578361 579024 581617 584706 588878 591747 592418 595418 595512 596594 597017 597059 597073 597951 597969 597987 598084 598508 598554 598584 600128 604350 608015 609645 614935 616046 620785 622765 623175 623406 635902 641737 643602 644670 652179 652612 652898 652923 652939 652978 653215 653229 655346 659324 665642 665771 677338 677339 677343 677356 677367 679051 714431 718638 721366 721394 722222 722535 722542 722621 725390 727669 729176 736101 747447 747454 753155 753435 753456 755178 758984 769765 800562 820410 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (2.22%) |
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 565614 565327 560038 561668 567735 592418 447530 570135 554215 653229 659324 596594 747447 609645 561880 595418 549782 597073 597951 597059 597969 568897 677339 718638 655346 727669 641737 570469 573083 574848 573078 652939 722621 652612 652898 653215 714431 570310 597987 623175 591747 729176 753435 753456 643602 571904 541686 561653 616046 800562 769765 466196 550236 574910 575798 561844 578361 584706 588878 598554 597017 424129 402746 454625 524502 581617 558247 677338 721394 722222 579024 747454 722535 552131 570494 575566 552091 543577 552514 575475 665642 665771 652179 652923 570199 572816 595512 614935 644670 604350 622765 598584 608015 623406 725390 736101 428052 820410 677367 679051 721366 722542 677343 598508 758984 755178 753155 620785 635902 539559 541303 652978 600128 598084 560645 561621 574540 575770 677356 560478 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (0.42%) |
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 402746 424129 428052 447530 454625 466196 524502 539559 541303 541686 543577 549782 550236 552091 552131 552514 554215 558247 560038 560478 560645 561621 561653 561668 561844 561880 565327 565614 567735 568897 570135 570199 570310 570469 570494 571904 572816 573078 573083 574540 574848 574910 575475 575566 575770 575798 578361 579024 581617 584706 588878 591747 592418 595418 595512 596594 597017 597059 597073 597951 597969 597987 598084 598508 598554 598584 600128 604350 608015 609645 614935 616046 620785 622765 623175 623406 635902 641737 643602 644670 652179 652612 652898 652923 652939 652978 653215 653229 655346 659324 665642 665771 677338 677339 677343 677356 677367 679051 714431 718638 721366 721394 722222 722535 722542 722621 725390 727669 729176 736101 747447 747454 753155 753435 753456 755178 758984 769765 800562 820410 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал butt"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal butt"
]
|
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.