Query Metrics
7
Database Queries
7
Different statements
151.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.58 ms (81.98%) |
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 383112 409035 410702 412814 415957 416009 416523 416539 416607 416611 416682 416708 416712 420864 421856 423787 424606 425452 427745 434346 435407 435529 439130 441050 445968 448063 448108 448351 448604 452800 452809 454004 458203 463435 464951 465454 466427 468943 469194 470479 471989 473213 475425 477761 479204 483730 483736 493688 500263 500342 502789 511413 518884 519350 525431 526167 526291 529296 529632 537138 561036 562536 575941 576590 577340 583694 586995 588514 589229 597190 601095 602109 625780 658819 660411 660412 660419 669056 669071 671018 680252 695868 709674 709786 712153 713501 716001 716241 738515 739125 739145 739156 739821 742421 751044 756776 758101 760538 763739 770262 770849 774703 774850 777642 779720 782847 783008 791538 793280 794041 796640 802071 803509 806812 806822 807166 807590 808265 808968 810776 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (10.98%) |
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 448108 511413 529296 529632 562536 576590 601095 808968 810776 751044 758101 738515 739821 774850 777642 793280 807166 712153 577340 526167 525431 415957 409035 412814 416611 424606 416607 416682 470479 448351 483736 561036 669071 695868 709674 660412 660419 669056 660411 671018 597190 796640 807590 808265 739125 739145 763739 416708 423787 434346 468943 416523 441050 518884 427745 410702 420864 493688 452809 465454 473213 475425 502789 500263 537138 464951 583694 709786 588514 586995 463435 435529 448604 458203 791538 416712 452800 483730 477761 383112 466427 716001 680252 713501 575941 589229 774703 803509 794041 760538 770262 770849 739156 756776 742421 602109 716241 779720 783008 802071 806822 806812 625780 416539 425452 448063 421856 479204 416009 500342 782847 469194 435407 454004 471989 439130 526291 519350 445968 658819 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.04%) |
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 383112 409035 410702 412814 415957 416009 416523 416539 416607 416611 416682 416708 416712 420864 421856 423787 424606 425452 427745 434346 435407 435529 439130 441050 445968 448063 448108 448351 448604 452800 452809 454004 458203 463435 464951 465454 466427 468943 469194 470479 471989 473213 475425 477761 479204 483730 483736 493688 500263 500342 502789 511413 518884 519350 525431 526167 526291 529296 529632 537138 561036 562536 575941 576590 577340 583694 586995 588514 589229 597190 601095 602109 625780 658819 660411 660412 660419 669056 669071 671018 680252 695868 709674 709786 712153 713501 716001 716241 738515 739125 739145 739156 739821 742421 751044 756776 758101 760538 763739 770262 770849 774703 774850 777642 779720 782847 783008 791538 793280 794041 796640 802071 803509 806812 806822 807166 807590 808265 808968 810776 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo oil"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд масл"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
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.