Query Metrics
7
Database Queries
7
Different statements
226.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.39 ms (87.88%) |
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 382585 384289 396801 398983 401630 417813 419050 419931 423259 429169 456917 541867 543836 548676 551422 551993 552151 556841 559503 559874 561862 562241 564172 566038 566526 567096 568852 569368 569659 569887 570015 570335 570593 571647 571652 572092 572129 572511 572803 573098 573633 573702 573774 574481 574571 574611 574873 574877 575078 575448 575468 575476 575523 575724 575741 576285 578129 580183 584509 590573 590601 591367 596991 597026 597254 597599 598801 599138 599418 599469 604140 604142 606540 613471 614144 618672 620626 622210 624510 632279 636026 636270 647836 654574 656042 659140 661249 664466 665453 669435 670033 675373 677343 679044 679060 680198 688049 696228 715860 716635 720848 722738 722764 723346 728336 729950 730718 731857 736373 742181 742215 746978 747498 748192 753364 758976 804569 805485 818390 827610 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (7.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 722738 742215 730718 675373 696228 574481 618672 559874 566526 636270 548676 624510 670033 604140 758976 747498 574571 575523 574611 654574 559503 575468 574877 543836 573098 578129 598801 456917 572129 632279 417813 716635 664466 384289 584509 729950 679044 720848 679060 805485 742181 680198 564172 606540 753364 552151 571652 551422 669435 665453 722764 723346 736373 396801 827610 580183 596991 551993 620626 661249 804569 604142 562241 575448 575476 728336 573774 575078 575741 569368 590601 419931 569659 597599 677343 590573 382585 818390 656042 659140 746978 561862 613471 591367 571647 429169 398983 572511 576285 570593 688049 597026 748192 715860 568852 419050 572803 570335 573633 569887 572092 566038 573702 731857 622210 401630 614144 570015 556841 567096 597254 636026 423259 599138 541867 575724 647836 574873 599418 599469 ] |
||||||||||||||||||||||||||||||
|
4.25 ms (1.87%) |
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 382585 384289 396801 398983 401630 417813 419050 419931 423259 429169 456917 541867 543836 548676 551422 551993 552151 556841 559503 559874 561862 562241 564172 566038 566526 567096 568852 569368 569659 569887 570015 570335 570593 571647 571652 572092 572129 572511 572803 573098 573633 573702 573774 574481 574571 574611 574873 574877 575078 575448 575468 575476 575523 575724 575741 576285 578129 580183 584509 590573 590601 591367 596991 597026 597254 597599 598801 599138 599418 599469 604140 604142 606540 613471 614144 618672 620626 622210 624510 632279 636026 636270 647836 654574 656042 659140 661249 664466 665453 669435 670033 675373 677343 679044 679060 680198 688049 696228 715860 716635 720848 722738 722764 723346 728336 729950 730718 731857 736373 742181 742215 746978 747498 748192 753364 758976 804569 805485 818390 827610 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small girl blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.54%) |
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.