Query Metrics
7
Database Queries
7
Different statements
159.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.88 ms (84.77%) |
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 70745 82217 168687 354774 382874 387304 398043 398105 406578 415036 415917 419951 429546 460952 460956 473060 478425 491448 492411 499485 512213 512215 512955 515884 519956 521230 522193 534207 550721 550752 550763 550764 550985 551028 551105 551941 551949 551972 551995 552030 552897 552917 554305 554415 556389 556409 558391 558423 558427 558431 559856 559863 559866 559873 559896 559897 559917 559918 559920 565475 565483 572725 572730 572732 572737 574642 576536 578685 584794 586623 588390 590958 590960 590972 591849 593023 595792 598515 603191 603458 610669 613857 619411 619427 619438 619449 619455 619459 622201 622336 622615 622618 622626 623528 623619 634866 643028 664267 673041 694193 702445 710206 712166 713474 721756 722426 724460 724480 736172 737132 737136 742126 742486 742925 761271 763322 780631 792763 805919 810051 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (9.30%) |
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 521230 574642 551972 551949 552897 792763 713474 473060 556409 558431 559873 598515 534207 406578 554305 590972 499485 551028 415036 415917 70745 622626 761271 558391 722426 710206 522193 558423 619427 763322 613857 519956 576536 742126 572732 551105 590960 559897 590958 387304 354774 512955 591849 603191 491448 565483 559896 559917 559920 694193 673041 622336 736172 478425 512213 572737 556389 643028 586623 554415 565475 559856 559866 623528 619455 622618 382874 603458 619438 742925 742486 552917 558427 550721 593023 398043 572725 780631 559863 398105 168687 429546 619449 460956 610669 492411 572730 702445 712166 588390 634866 622615 724480 724460 721756 551995 550763 551941 512215 805919 552030 584794 550764 550752 559918 595792 82217 460952 623619 737136 550985 578685 619411 664267 419951 622201 515884 810051 619459 737132 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.64%) |
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 70745 82217 168687 354774 382874 387304 398043 398105 406578 415036 415917 419951 429546 460952 460956 473060 478425 491448 492411 499485 512213 512215 512955 515884 519956 521230 522193 534207 550721 550752 550763 550764 550985 551028 551105 551941 551949 551972 551995 552030 552897 552917 554305 554415 556389 556409 558391 558423 558427 558431 559856 559863 559866 559873 559896 559897 559917 559918 559920 565475 565483 572725 572730 572732 572737 574642 576536 578685 584794 586623 588390 590958 590960 590972 591849 593023 595792 598515 603191 603458 610669 613857 619411 619427 619438 619449 619455 619459 622201 622336 622615 622618 622626 623528 623619 634866 643028 664267 673041 694193 702445 710206 712166 713474 721756 722426 724460 724480 736172 737132 737136 742126 742486 742925 761271 763322 780631 792763 805919 810051 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck japanese"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
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.