Query Metrics
7
Database Queries
7
Different statements
201.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.92 ms (85.79%) |
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 388219 390831 396358 406350 409921 414651 416166 418538 419862 420120 425356 429764 429943 435108 439301 439723 440632 443651 446167 448817 451983 452228 453583 457163 461765 464188 465614 468637 473010 473722 474621 476120 478033 485149 486788 490071 491446 495014 501487 514798 516291 517725 518476 521089 521850 522130 522147 522284 522883 527106 530019 530483 531189 531405 532737 532804 533063 533372 533773 534150 534166 534381 536562 537901 537908 540400 542583 542590 551916 553255 558074 565102 573238 576395 580368 582376 583714 596643 597028 598042 598498 599932 599955 600293 604507 604528 604902 605449 606541 610060 618378 631192 632692 633798 633806 637145 637741 642658 643112 646771 647954 648867 649587 650476 666589 680206 706658 712775 716882 720115 720245 720938 731665 737171 745384 767601 788562 797105 811040 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (8.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 712775 478033 517725 439723 518476 598042 530483 534166 534381 396358 406350 513476 522284 583714 521089 716882 646771 642658 390831 435108 464188 531405 551916 542590 632692 461765 495014 490071 429764 522130 540400 576395 647954 599932 604507 637741 643112 476120 582376 533063 485149 419862 745384 558074 666589 637145 388219 414651 420120 465614 649587 706658 788562 501487 491446 448817 604528 580368 598498 486788 536562 537908 553255 731665 409921 468637 531189 532804 534150 514798 530019 537901 648867 720115 720245 573238 600293 596643 631192 811040 720938 453583 416166 446167 521850 606541 797105 425356 429943 452228 473722 532737 542583 680206 565102 610060 439301 473010 522883 737171 451983 516291 533372 533773 599955 604902 418538 457163 650476 633798 767601 633806 474621 443651 522147 618378 605449 527106 440632 597028 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.51%) |
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 388219 390831 396358 406350 409921 414651 416166 418538 419862 420120 425356 429764 429943 435108 439301 439723 440632 443651 446167 448817 451983 452228 453583 457163 461765 464188 465614 468637 473010 473722 474621 476120 478033 485149 486788 490071 491446 495014 501487 514798 516291 517725 518476 521089 521850 522130 522147 522284 522883 527106 530019 530483 531189 531405 532737 532804 533063 533372 533773 534150 534166 534381 536562 537901 537908 540400 542583 542590 551916 553255 558074 565102 573238 576395 580368 582376 583714 596643 597028 598042 598498 599932 599955 600293 604507 604528 604902 605449 606541 610060 618378 631192 632692 633798 633806 637145 637741 642658 643112 646771 647954 648867 649587 650476 666589 680206 706658 712775 716882 720115 720245 720938 731665 737171 745384 767601 788562 797105 811040 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black большие анал"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black большие анал"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black big anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
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.