Query Metrics
7
Database Queries
7
Different statements
156.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.91 ms (86.59%) |
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 140007 391656 401648 403258 408611 415774 417370 422003 424061 441490 441749 447032 458130 468272 473721 486209 488243 489276 495032 533528 536824 546294 547402 557203 557712 588419 590415 591923 599363 606072 610366 616183 617496 623403 626121 629547 631490 631551 636655 638720 641038 645728 650526 655192 663720 664410 675789 687126 690165 693495 697592 698809 703328 703764 704355 707741 714012 718139 719347 720089 724250 724820 724889 725483 726932 727008 727046 730036 731350 733284 737300 740261 740757 740911 746374 747260 747435 750407 753565 756785 757459 757521 758753 762827 763087 764889 765434 773430 774590 777731 777998 778207 778438 779124 779150 779254 782379 783019 783129 787263 787769 788363 791530 791627 792437 792469 792635 792803 793068 793104 794067 794935 794938 797473 801282 801502 803274 812558 ] |
||||||||||||||||||||||||||||||
|
10.04 ms (6.40%) |
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 557712 546294 707741 718139 650526 675789 697592 655192 693495 703764 606072 626121 610366 623403 629547 631490 631551 638720 792803 725483 740911 758753 767421 793068 794067 794935 794938 803274 724250 747435 753565 773430 747260 756785 733284 762827 765434 641038 778438 783129 787769 403258 401648 441749 408611 441490 489276 533528 536824 663720 792635 777998 801282 730036 750407 757521 763087 740757 757459 415774 417370 488243 557203 591923 422003 447032 468272 495032 590415 791627 391656 424061 458130 140007 473721 486209 547402 714012 645728 704355 720089 664410 687126 690165 703328 719347 588419 616183 636655 617496 599363 774590 779124 779150 779254 791530 792437 792469 793104 782379 783019 801502 812558 724889 746374 787263 797473 726932 764889 727008 737300 766525 740261 724820 727046 731350 698809 777731 778207 788363 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.84%) |
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 140007 391656 401648 403258 408611 415774 417370 422003 424061 441490 441749 447032 458130 468272 473721 486209 488243 489276 495032 533528 536824 546294 547402 557203 557712 588419 590415 591923 599363 606072 610366 616183 617496 623403 626121 629547 631490 631551 636655 638720 641038 645728 650526 655192 663720 664410 675789 687126 690165 693495 697592 698809 703328 703764 704355 707741 714012 718139 719347 720089 724250 724820 724889 725483 726932 727008 727046 730036 731350 733284 737300 740261 740757 740911 746374 747260 747435 750407 753565 756785 757459 757521 758753 762827 763087 764889 765434 773430 774590 777731 777998 778207 778438 779124 779150 779254 782379 783019 783129 787263 787769 788363 791530 791627 792437 792469 792635 792803 793068 793104 794067 794935 794938 797473 801282 801502 803274 812558 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тугие задницы"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туг жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
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.