Query Metrics
7
Database Queries
7
Different statements
254.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.18 ms (89.97%) |
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 7172 12708 14187 66907 187252 373995 385460 385630 386578 391439 393220 393980 394195 395349 396994 397872 397977 403317 403592 411347 411470 413576 419293 419619 424427 429862 432390 432398 432418 432436 432505 433033 433271 433453 433541 433702 433751 433829 433954 435806 439571 445530 445791 448931 450044 458141 458208 459795 461248 465915 466060 466233 499241 503444 515705 518173 518813 527979 528145 533431 539926 540716 551812 554436 555705 560063 564381 567833 569631 580027 580121 591420 592663 608550 615392 616851 617782 619900 627154 627213 664276 680242 693890 695701 695715 695747 703944 706044 718058 723689 724888 725466 725484 735876 739960 741902 744343 750550 751002 751159 753500 755142 755149 755150 757107 758500 758687 758700 767634 770194 777761 791914 792127 794732 795728 796535 796552 807340 812446 819893 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (6.03%) |
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 794732 755142 796552 755150 758700 744343 751002 718058 187252 791914 432436 393220 540716 680242 555705 419619 448931 619900 767634 753500 807340 432390 12708 515705 580027 385460 7172 391439 373995 439571 664276 432505 554436 608550 66907 539926 567833 564381 615392 751159 724888 432418 450044 386578 403317 433702 433954 466060 458141 459795 411347 411470 419293 433033 433453 518173 518813 527979 433829 424427 395349 792127 433271 433541 528145 503444 499241 569631 435806 429862 616851 393980 432398 819893 533431 693890 617782 723689 757107 795728 796535 750550 770194 758500 735876 741902 755149 385630 394195 397977 458208 739960 777761 433751 580121 14187 627213 725466 758687 592663 403592 413576 551812 461248 445530 466233 695701 703944 591420 725484 627154 465915 560063 812446 445791 396994 695715 706044 695747 397872 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.13%) |
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 7172 12708 14187 66907 187252 373995 385460 385630 386578 391439 393220 393980 394195 395349 396994 397872 397977 403317 403592 411347 411470 413576 419293 419619 424427 429862 432390 432398 432418 432436 432505 433033 433271 433453 433541 433702 433751 433829 433954 435806 439571 445530 445791 448931 450044 458141 458208 459795 461248 465915 466060 466233 499241 503444 515705 518173 518813 527979 528145 533431 539926 540716 551812 554436 555705 560063 564381 567833 569631 580027 580121 591420 592663 608550 615392 616851 617782 619900 627154 627213 664276 680242 693890 695701 695715 695747 703944 706044 718058 723689 724888 725466 725484 735876 739960 741902 744343 750550 751002 751159 753500 755142 755149 755150 757107 758500 758687 758700 767634 770194 777761 791914 792127 794732 795728 796535 796552 807340 812446 819893 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп колготк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп колготк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass tights"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.