Query Metrics
7
Database Queries
7
Different statements
147.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.02 ms (83.18%) |
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 4290 58313 70601 111786 147369 250422 381850 383436 384457 385243 391216 419309 419316 423483 424672 425654 429815 430661 431528 433198 433574 433696 434933 441314 455974 458784 463479 463561 467590 467668 479952 481567 483359 485507 486480 488426 489785 499694 500018 501005 503741 504000 509772 512390 513620 514011 518795 524984 530167 530176 537178 540694 544064 549218 550472 552149 552732 553025 553616 557311 558696 559365 568722 574470 578847 585531 590465 591232 600499 601384 620023 626636 626645 654222 654282 661064 664564 674272 691535 716235 716268 719967 730654 736437 737995 744791 746854 755918 758064 763918 764429 766064 767892 768447 768452 768459 768809 769178 769186 769203 779694 786474 787152 787994 791255 792301 792968 792976 793292 795765 796322 797361 799713 800250 800741 808082 811820 813636 821793 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (9.92%) |
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 500018 768452 568722 766064 768459 434933 795765 558696 488426 793292 791255 540694 385243 499694 768809 524984 787994 797361 250422 600499 796322 467668 463561 504000 147369 744791 716268 746854 767890 737995 552732 792968 384457 383436 425654 821793 800741 767892 719967 530167 574470 716235 58313 458784 479952 501005 514011 691535 590465 769203 763918 764429 800250 786474 381850 391216 559365 509772 518795 503741 485507 111786 537178 730654 779694 419316 419309 4290 626645 481567 486480 585531 792301 467590 544064 553616 424672 513620 429815 736437 455974 483359 489785 620023 811820 755918 813636 530176 552149 557311 654222 654282 661064 664564 674272 549218 591232 626636 792976 758064 769186 799713 808082 769178 768447 431528 70601 423483 430661 512390 441314 550472 578847 601384 433198 433696 433574 463479 787152 553025 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.13%) |
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 4290 58313 70601 111786 147369 250422 381850 383436 384457 385243 391216 419309 419316 423483 424672 425654 429815 430661 431528 433198 433574 433696 434933 441314 455974 458784 463479 463561 467590 467668 479952 481567 483359 485507 486480 488426 489785 499694 500018 501005 503741 504000 509772 512390 513620 514011 518795 524984 530167 530176 537178 540694 544064 549218 550472 552149 552732 553025 553616 557311 558696 559365 568722 574470 578847 585531 590465 591232 600499 601384 620023 626636 626645 654222 654282 661064 664564 674272 691535 716235 716268 719967 730654 736437 737995 744791 746854 755918 758064 763918 764429 766064 767892 768447 768452 768459 768809 769178 769186 769203 779694 786474 787152 787994 791255 792301 792968 792976 793292 795765 796322 797361 799713 800250 800741 808082 811820 813636 821793 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена дрочит с подружк%…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен дрочк подружк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен дрочк подружк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.