Query Metrics
7
Database Queries
7
Different statements
317.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
286.21 ms (90.27%) |
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 391725 397295 401757 410770 411258 412177 416143 418911 420849 420877 423766 431948 434544 435060 437829 441559 446993 447070 447937 452425 453945 454405 455897 457809 463407 469662 473754 475455 475472 476900 478145 478764 480037 483761 484160 489703 493465 496150 496428 502209 502230 506477 511246 516440 516564 520526 522084 522286 522715 522960 524487 526560 527386 531326 532212 535280 535934 538520 542154 547429 551511 552669 555463 556219 558228 560273 561330 566294 566537 570135 570396 572339 576509 580282 581033 581072 583502 584858 585417 604625 610504 616790 616795 621220 636951 639295 639924 652586 687453 696126 698880 698883 704161 710953 718877 720096 721431 733560 740879 740904 751597 752840 760214 760313 767976 769077 770303 784054 787959 790256 792137 796307 798670 804117 804562 805660 806614 808101 812993 823454 ] |
||||||||||||||||||||||||||||||
|
20.20 ms (6.37%) |
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 710953 493465 516440 489703 391725 687453 457809 416143 418911 431948 441559 823454 453945 447070 483761 475455 478764 480037 496428 496150 484160 555463 560273 581033 576509 718877 720096 547429 616795 636951 639295 790256 792137 804562 806614 740879 740904 760214 784054 787959 796307 804117 805660 808101 751597 760313 769077 733560 752840 767976 770303 604625 698880 721431 812993 412177 423766 411258 452425 535934 516564 397295 446993 455897 469662 520526 538520 522960 522715 524487 566537 572339 542154 551511 698883 652586 696126 704161 552669 558228 566294 580282 583502 616790 639924 610504 585417 798670 621220 401757 435060 506477 420849 434544 437829 410770 420877 447937 454405 478145 475472 527386 502230 502209 511246 526560 531326 532212 535280 522084 522286 463407 473754 476900 561330 584858 556219 570135 570396 581072 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (1.22%) |
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 391725 397295 401757 410770 411258 412177 416143 418911 420849 420877 423766 431948 434544 435060 437829 441559 446993 447070 447937 452425 453945 454405 455897 457809 463407 469662 473754 475455 475472 476900 478145 478764 480037 483761 484160 489703 493465 496150 496428 502209 502230 506477 511246 516440 516564 520526 522084 522286 522715 522960 524487 526560 527386 531326 532212 535280 535934 538520 542154 547429 551511 552669 555463 556219 558228 560273 561330 566294 566537 570135 570396 572339 576509 580282 581033 581072 583502 584858 585417 604625 610504 616790 616795 621220 636951 639295 639924 652586 687453 696126 698880 698883 704161 710953 718877 720096 721431 733560 740879 740904 751597 752840 760214 760313 767976 769077 770303 784054 787959 790256 792137 796307 798670 804117 804562 805660 806614 808101 812993 823454 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск first"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur first"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск first"
]
|
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.