Query Metrics
7
Database Queries
7
Different statements
215.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.20 ms (86.91%) |
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 187843 386378 391472 391559 391925 392754 392988 397392 397916 400698 400838 400844 400845 401939 411332 411370 411371 418423 419524 421565 422198 422199 422200 424421 424426 424428 424432 424458 424460 424482 428139 428837 433388 437632 439521 439616 439623 439641 439681 439696 439745 439757 443139 443334 443777 443820 446112 448221 454264 454274 454585 454638 457140 465075 465955 465963 466140 466229 466265 466872 467457 468072 470213 470290 470527 471405 471406 474627 474652 474680 474686 477097 477725 477730 478546 481134 484629 484645 484692 484705 484738 484748 484750 486346 490414 490430 490438 491906 492609 494516 496862 508839 509810 509995 510627 510756 513710 515923 515969 515986 520127 523019 523175 524706 539010 539951 544494 545717 546947 563444 564542 567337 573801 575815 598890 601475 604018 604247 653252 827919 ] |
||||||||||||||||||||||||||||||
|
18.55 ms (8.61%) |
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 424460 443334 424458 443777 468072 474680 477730 484629 496862 515986 827919 563444 544494 545717 601475 411370 454585 466140 467457 471405 424432 443820 454638 392754 397916 428139 439745 466265 433388 443139 490414 490438 508839 510627 491906 481134 439641 477097 439681 419524 391559 418423 424482 471406 474627 465963 484738 520127 439623 513710 510756 573801 575815 386378 422200 424426 437632 446112 400838 454274 470213 478546 400844 421565 439616 439757 477725 448221 515923 484645 490430 492609 454264 523175 400698 392988 604247 401939 466229 509995 400845 422198 486346 187843 391925 397392 509810 391472 411332 474686 411371 439696 484748 484750 470290 523019 484692 524706 539010 539951 564542 546947 653252 567337 598890 604018 422199 439521 424428 457140 465955 474652 424421 466872 465075 428837 470527 515969 484705 494516 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.49%) |
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 187843 386378 391472 391559 391925 392754 392988 397392 397916 400698 400838 400844 400845 401939 411332 411370 411371 418423 419524 421565 422198 422199 422200 424421 424426 424428 424432 424458 424460 424482 428139 428837 433388 437632 439521 439616 439623 439641 439681 439696 439745 439757 443139 443334 443777 443820 446112 448221 454264 454274 454585 454638 457140 465075 465955 465963 466140 466229 466265 466872 467457 468072 470213 470290 470527 471405 471406 474627 474652 474680 474686 477097 477725 477730 478546 481134 484629 484645 484692 484705 484738 484748 484750 486346 490414 490430 490438 491906 492609 494516 496862 508839 509810 509995 510627 510756 513710 515923 515969 515986 520127 523019 523175 524706 539010 539951 544494 545717 546947 563444 564542 567337 573801 575815 598890 601475 604018 604247 653252 827919 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young russian anal"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young русск анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young русск анал"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.63%) |
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.