Query Metrics
7
Database Queries
7
Different statements
182.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.31 ms (85.04%) |
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 96100 96231 97401 210072 325910 383387 387301 390362 390538 396334 397302 407290 408443 420201 420471 446359 448874 513106 516644 527627 532916 533867 540334 546022 547997 551239 551976 554745 558843 569202 576359 584007 584696 588262 591192 597269 597275 598484 598569 600366 601512 603170 609277 610847 614186 617620 624788 626310 628321 630234 630902 633493 633776 634161 641928 643725 644679 645093 645132 646228 648554 649935 650827 651062 651855 651856 652978 653728 654294 668527 670040 670965 672984 674508 677730 680121 680192 680202 681053 681235 687185 690809 692506 695125 696355 696865 698096 699694 705737 715497 716373 720050 720239 721538 723714 725407 729123 732071 742848 745404 745550 746852 769209 775862 784254 786255 788174 790679 792356 793712 798411 801942 809525 811270 811486 817451 818297 818470 823920 827201 ] |
||||||||||||||||||||||||||||||
|
16.77 ms (9.18%) |
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 554745 674508 690809 645093 653728 681053 696865 698096 603170 624788 723714 769209 390362 420201 597269 598484 775862 96100 387301 817451 551239 551976 546022 547997 584007 651855 652978 681235 677730 695125 721538 558843 634161 746852 742848 601512 446359 396334 527627 513106 383387 97401 96231 420471 448874 540334 516644 532916 569202 649935 651062 670040 672984 680192 680202 699694 650827 651856 670965 687185 668527 680121 720050 576359 600366 591192 597275 614186 633776 609277 630234 630902 801942 745404 732071 626310 633493 407290 390538 408443 325910 823920 827201 818297 818470 533867 584696 646228 715497 648554 654294 692506 696355 716373 645132 720239 598569 610847 644679 588262 643725 617620 628321 641928 784254 786255 788174 793712 809525 811270 798411 725407 729123 745550 811486 705737 790679 792356 397302 210072 ] |
||||||||||||||||||||||||||||||
|
3.36 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 96100 96231 97401 210072 325910 383387 387301 390362 390538 396334 397302 407290 408443 420201 420471 446359 448874 513106 516644 527627 532916 533867 540334 546022 547997 551239 551976 554745 558843 569202 576359 584007 584696 588262 591192 597269 597275 598484 598569 600366 601512 603170 609277 610847 614186 617620 624788 626310 628321 630234 630902 633493 633776 634161 641928 643725 644679 645093 645132 646228 648554 649935 650827 651062 651855 651856 652978 653728 654294 668527 670040 670965 672984 674508 677730 680121 680192 680202 681053 681235 687185 690809 692506 695125 696355 696865 698096 699694 705737 715497 716373 720050 720239 721538 723714 725407 729123 732071 742848 745404 745550 746852 769209 775862 784254 786255 788174 790679 792356 793712 798411 801942 809525 811270 811486 817451 818297 818470 823920 827201 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк gangbang"
]
|
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.