Query Metrics
7
Database Queries
7
Different statements
151.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.71 ms (82.58%) |
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 146341 146721 150608 153402 187903 192551 366017 381850 382943 383384 384787 385632 386816 391560 391761 402877 417234 418152 418250 420349 420503 422293 423852 426084 426627 427117 427798 432387 432425 432444 432461 433061 433404 433447 433487 433749 434178 435366 436373 437434 438551 438903 441213 442257 443227 443443 443918 445394 446816 447853 450127 452727 454029 456000 457535 458378 459624 459913 463479 465029 465409 465839 467541 468962 472669 475084 475238 478346 479456 484648 487748 489785 490607 492991 494798 495951 502046 503483 505277 507174 508606 519919 521099 524699 526258 526867 527349 527997 528513 530210 533699 536635 555750 560376 567185 567434 570084 574596 574618 580022 588405 591080 596438 598157 618910 699642 725502 731137 733824 746116 755384 777232 782486 787974 789085 795127 802093 806263 807624 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (10.29%) |
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 447853 555750 591080 433447 432444 434178 456000 454029 420503 789085 777232 806263 733824 782486 192551 385632 467541 384787 524699 530210 443227 478346 366017 459624 463479 479456 527997 150608 475084 446816 567434 433749 382943 787974 418250 422293 146341 427117 458378 574596 475238 507174 490607 746116 386816 436373 420349 153402 441213 443918 445394 450127 468962 465839 519919 494798 526258 802093 764586 457535 437434 526867 505277 536635 528513 484648 426084 442257 459913 432387 492991 433404 755384 443443 495951 508606 527349 432461 433487 418152 574618 402877 391761 533699 596438 598157 435366 426627 472669 502046 433061 383384 432425 699642 521099 452727 560376 570084 580022 567185 588405 503483 618910 807624 795127 187903 465029 489785 381850 427798 725502 731137 438903 146721 423852 391560 438551 417234 465409 487748 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.33%) |
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 146341 146721 150608 153402 187903 192551 366017 381850 382943 383384 384787 385632 386816 391560 391761 402877 417234 418152 418250 420349 420503 422293 423852 426084 426627 427117 427798 432387 432425 432444 432461 433061 433404 433447 433487 433749 434178 435366 436373 437434 438551 438903 441213 442257 443227 443443 443918 445394 446816 447853 450127 452727 454029 456000 457535 458378 459624 459913 463479 465029 465409 465839 467541 468962 472669 475084 475238 478346 479456 484648 487748 489785 490607 492991 494798 495951 502046 503483 505277 507174 508606 519919 521099 524699 526258 526867 527349 527997 528513 530210 533699 536635 555750 560376 567185 567434 570084 574596 574618 580022 588405 591080 596438 598157 618910 699642 725502 731137 733824 746116 755384 777232 782486 787974 789085 795127 802093 806263 807624 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob boy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член парен"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.97%) |
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.