Query Metrics
7
Database Queries
7
Different statements
195.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.11 ms (88.14%) |
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 118008 118227 387720 401204 401768 412779 412830 413687 414050 416597 417246 421740 424370 426816 429609 429938 432255 439038 441864 442511 443568 443865 445533 448559 452643 452815 459201 459778 460070 461612 465454 465497 468348 470404 470405 471669 471693 474580 475319 475947 477055 477760 489014 489311 493237 493618 493679 500787 502462 505109 514849 521241 529597 534554 541277 547422 548260 580069 613518 623130 623171 630039 630096 691511 696871 699415 715877 717664 720067 720224 724118 724240 728518 731234 731327 731482 734346 736356 737852 742916 745112 747633 748068 754207 759796 760888 765334 765555 773912 775543 777013 777029 780665 783180 783275 783428 783718 784298 788193 788786 790637 792671 793138 794765 794859 795425 795704 795706 796532 799917 800566 803243 805651 806046 815266 817194 817218 818959 819749 826154 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (6.68%) |
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 775543 783718 790637 792671 795706 796532 799917 803243 806046 731482 734346 754207 760888 783180 784298 794765 800566 731234 737852 765555 724118 728518 736356 742916 745112 759796 773912 724240 731327 747633 613518 623130 630039 699415 777029 780665 783275 788786 793138 795425 805651 717664 720067 630096 777013 794859 765334 696871 529597 715877 783428 521241 118008 401768 432255 441864 443865 417246 429609 477760 493618 445533 459778 460070 470404 474580 493679 459201 465454 500787 477055 489014 541277 580069 623171 414050 475947 412779 412830 471669 475319 452815 461612 471693 421740 470405 514849 505109 493237 489311 502462 118227 817194 817218 826154 818959 819749 815266 534554 547422 548260 691511 720224 788193 795704 748068 387720 401204 439038 443568 413687 424370 429938 416597 426816 442511 452643 465497 468348 448559 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.50%) |
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 118008 118227 387720 401204 401768 412779 412830 413687 414050 416597 417246 421740 424370 426816 429609 429938 432255 439038 441864 442511 443568 443865 445533 448559 452643 452815 459201 459778 460070 461612 465454 465497 468348 470404 470405 471669 471693 474580 475319 475947 477055 477760 489014 489311 493237 493618 493679 500787 502462 505109 514849 521241 529597 534554 541277 547422 548260 580069 613518 623130 623171 630039 630096 691511 696871 699415 715877 717664 720067 720224 724118 724240 728518 731234 731327 731482 734346 736356 737852 742916 745112 747633 748068 754207 759796 760888 765334 765555 773912 775543 777013 777029 780665 783180 783275 783428 783718 784298 788193 788786 790637 792671 793138 794765 794859 795425 795704 795706 796532 799917 800566 803243 805651 806046 815266 817194 817218 818959 819749 826154 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал дыры"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дырк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.