Query Metrics
7
Database Queries
7
Different statements
158.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.23 ms (80.51%) |
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 530149 540053 540056 541707 542178 542182 542183 542429 542434 542437 542439 542440 542446 542864 545233 545319 545321 546793 547407 547410 547442 547446 547448 549640 550936 552602 553675 554688 554700 554706 554712 554721 555392 555447 557406 560342 561029 561031 561797 562051 562440 565263 568293 571094 576753 581551 581554 582998 583102 584800 584904 588202 588613 589362 593855 605290 606644 614256 615602 616395 617862 618308 627946 628367 628632 631136 631703 633715 634133 634561 636607 637026 637047 637245 641298 642269 644345 644973 645016 646941 647938 647975 661035 661265 661645 661664 664600 665624 665633 666360 666422 670265 670813 671675 671678 671779 671780 671991 673935 676089 678495 680499 686154 691558 711695 725669 729224 729434 740374 744938 745263 746568 749097 754172 758218 758238 810085 811844 826074 826187 ] |
||||||||||||||||||||||||||||||
|
19.82 ms (12.54%) |
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 552602 541707 562051 628367 581551 744938 540053 680499 671779 565263 634561 642269 665633 670813 740374 749097 754172 542439 647938 671780 628632 561031 584800 670265 547410 634133 637026 542178 671991 542864 711695 637047 547407 666422 568293 686154 562440 554706 673935 641298 555447 561029 555392 631136 725669 547442 666360 546793 545319 589362 557406 745263 542434 647975 560342 571094 627946 584904 554700 553675 582998 614256 758238 758218 549640 542182 576753 588613 644973 561797 661645 617862 746568 542429 550936 646941 691558 645016 671678 615602 665624 542440 554688 583102 633715 636607 826074 547446 729434 729224 542183 542437 661664 631703 593855 606644 542446 671675 588202 530149 540056 661265 664600 545233 618308 678495 581554 547448 661035 554712 616395 605290 810085 811844 545321 637245 676089 826187 554721 644345 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк писсинг"
]
|
||||||||||||||||||||||||||||||
|
2.34 ms (1.48%) |
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 530149 540053 540056 541707 542178 542182 542183 542429 542434 542437 542439 542440 542446 542864 545233 545319 545321 546793 547407 547410 547442 547446 547448 549640 550936 552602 553675 554688 554700 554706 554712 554721 555392 555447 557406 560342 561029 561031 561797 562051 562440 565263 568293 571094 576753 581551 581554 582998 583102 584800 584904 588202 588613 589362 593855 605290 606644 614256 615602 616395 617862 618308 627946 628367 628632 631136 631703 633715 634133 634561 636607 637026 637047 637245 641298 642269 644345 644973 645016 646941 647938 647975 661035 661265 661645 661664 664600 665624 665633 666360 666422 670265 670813 671675 671678 671779 671780 671991 673935 676089 678495 680499 686154 691558 711695 725669 729224 729434 740374 744938 745263 746568 749097 754172 758218 758238 810085 811844 826074 826187 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl piss"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.