Query Metrics
7
Database Queries
7
Different statements
275.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
243.20 ms (88.36%) |
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 16930 70082 330046 401859 414301 416742 417363 420358 422512 426294 428103 428315 429909 433295 433319 444111 446275 447318 448797 448810 448812 448817 448820 448821 452384 452833 452963 453161 456372 457007 464366 465354 468675 469187 470202 470774 471691 473831 480293 486685 487774 492364 501227 502249 502253 503866 504209 505215 513965 518599 518756 519246 521001 521426 525393 529994 533478 535084 537657 537821 539351 541587 541740 541774 541887 542190 542199 545791 545836 550131 554166 558788 568399 568982 569128 576690 576710 579373 581035 581850 590879 591789 603933 604517 606608 616328 616338 616411 628094 632059 632694 632701 645241 651601 652316 656281 660148 696352 697459 699554 743564 763398 765552 784152 788115 788260 788264 788268 792554 792558 801886 805139 808527 811220 813221 814849 816007 824164 824265 824362 ] |
||||||||||||||||||||||||||||||
|
21.64 ms (7.86%) |
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 808527 456372 537821 824265 581850 503866 446275 535084 420358 473831 521426 579373 699554 603933 525393 471691 448812 416742 814849 480293 541887 550131 581035 696352 660148 697459 656281 591789 616338 606608 628094 590879 788115 811220 763398 452963 422512 558788 651601 513965 444111 447318 529994 645241 788268 16930 518756 576690 604517 448817 448821 414301 632059 417363 448797 452384 465354 470202 824362 70082 429909 505215 813221 541587 518599 487774 492364 568399 401859 824164 428315 545791 464366 426294 743564 330046 448820 452833 554166 533478 765552 576710 521001 433319 469187 542199 632701 541774 428103 816007 468675 502253 537657 542190 569128 568982 652316 545836 616328 792554 801886 788260 792558 805139 501227 788264 784152 632694 457007 448810 486685 470774 616411 539351 541740 433295 453161 502249 519246 504209 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.29%) |
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 16930 70082 330046 401859 414301 416742 417363 420358 422512 426294 428103 428315 429909 433295 433319 444111 446275 447318 448797 448810 448812 448817 448820 448821 452384 452833 452963 453161 456372 457007 464366 465354 468675 469187 470202 470774 471691 473831 480293 486685 487774 492364 501227 502249 502253 503866 504209 505215 513965 518599 518756 519246 521001 521426 525393 529994 533478 535084 537657 537821 539351 541587 541740 541774 541887 542190 542199 545791 545836 550131 554166 558788 568399 568982 569128 576690 576710 579373 581035 581850 590879 591789 603933 604517 606608 616328 616338 616411 628094 632059 632694 632701 645241 651601 652316 656281 660148 696352 697459 699554 743564 763398 765552 784152 788115 788260 788264 788268 792554 792558 801886 805139 808527 811220 813221 814849 816007 824164 824265 824362 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal compilation stockings"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал подборк чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 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.