Query Metrics
7
Database Queries
7
Different statements
189.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.58 ms (85.38%) |
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 87974 89135 89346 150785 151179 154491 382158 382205 382404 382813 383034 383500 384108 384336 386193 387325 387337 389703 389794 390615 391992 392848 395252 396071 397882 401768 402278 408880 410962 413341 413389 414050 414253 416704 416712 444535 448851 454590 456117 457476 459198 468943 471148 473437 476658 480255 480258 483736 497471 505137 511278 511857 511862 514085 514233 515546 518550 526902 531827 531852 531929 532882 536182 537155 537766 541274 545551 547502 547556 552069 567172 568498 569258 573257 574377 581645 583472 587292 589185 592046 594619 598540 600144 602329 604105 607706 609804 624399 624682 628105 634108 642022 642076 648716 650246 660415 663215 663317 666855 669016 669062 672932 720101 738476 741684 749259 750426 752639 770270 788908 792697 792713 795404 796071 799683 800537 806938 807590 809122 814151 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (9.04%) |
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 738476 386193 395252 642022 154491 401768 408880 480255 457476 454590 583472 589185 624682 600144 806938 788908 456117 89135 473437 532882 537155 531827 531929 531852 663317 609804 792713 604105 792697 471148 569258 384108 413389 648716 391992 459198 518550 151179 89346 514085 505137 568498 547502 389794 416704 382158 397882 552069 592046 634108 587292 392848 414253 480258 511862 536182 574377 669062 660415 594619 628105 624399 795404 750426 87974 414050 814151 476658 526902 573257 669016 602329 796071 809122 741684 752639 382205 383500 390615 389703 384336 497471 545551 666855 672932 720101 642076 800537 799683 396071 547556 607706 410962 511857 663215 402278 387337 581645 444535 387325 413341 483736 807590 749259 770270 468943 511278 416712 514233 598540 448851 650246 150785 382813 383034 382404 537766 515546 541274 567172 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.68%) |
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 87974 89135 89346 150785 151179 154491 382158 382205 382404 382813 383034 383500 384108 384336 386193 387325 387337 389703 389794 390615 391992 392848 395252 396071 397882 401768 402278 408880 410962 413341 413389 414050 414253 416704 416712 444535 448851 454590 456117 457476 459198 468943 471148 473437 476658 480255 480258 483736 497471 505137 511278 511857 511862 514085 514233 515546 518550 526902 531827 531852 531929 532882 536182 537155 537766 541274 545551 547502 547556 552069 567172 568498 569258 573257 574377 581645 583472 587292 589185 592046 594619 598540 600144 602329 604105 607706 609804 624399 624682 628105 634108 642022 642076 648716 650246 660415 663215 663317 666855 669016 669062 672932 720101 738476 741684 749259 750426 752639 770270 788908 792697 792713 795404 796071 799683 800537 806938 807590 809122 814151 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo and fuck"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
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.