Query Metrics
7
Database Queries
7
Different statements
148.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.57 ms (81.04%) |
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 387522 400474 411731 413134 416880 423697 425979 426481 433584 434763 435550 438052 439467 442750 447094 447604 449450 451133 456466 456487 457026 457226 458744 458882 459191 462572 463966 464721 465385 466397 466491 467642 469011 474964 477881 479955 479962 484879 485258 485589 485619 485996 490945 492986 500576 500976 501415 502729 503498 504132 504320 505078 506233 507630 507641 513007 514904 517143 517927 519476 520098 520898 521017 522513 524239 525186 526865 528663 528751 536871 538194 548297 549729 552380 555000 560814 563722 565687 565695 565773 571048 575557 576081 579396 582920 584465 585156 588052 588953 591219 591694 597432 602944 603067 603783 605498 605963 609235 610011 610832 612068 614715 623211 623499 625369 626405 637172 641414 670056 691137 693284 696430 721895 722277 726718 733319 742279 757094 767025 785507 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (12.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 466397 479955 456466 474964 463966 479962 484879 504320 526865 485589 485619 507630 522513 485258 490945 492986 502729 519476 521017 411731 605963 785507 757094 458744 506233 538194 626405 447094 467642 462572 528751 520098 525186 500976 505078 507641 536871 693284 576081 610832 625369 387522 485996 552380 416880 413134 423697 425979 439467 426481 434763 449450 458882 459191 465385 456487 517927 528663 524239 500576 514904 520898 501415 503498 504132 513007 517143 548297 549729 571048 579396 560814 563722 565773 575557 584465 555000 670056 691137 696430 721895 722277 565687 565695 582920 588052 603067 610011 585156 591694 623499 588953 591219 614715 623211 597432 602944 603783 605498 609235 637172 641414 726718 733319 767025 742279 612068 464721 433584 442750 447604 451133 457026 457226 466491 469011 477881 400474 435550 438052 ] |
||||||||||||||||||||||||||||||
|
2.45 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 387522 400474 411731 413134 416880 423697 425979 426481 433584 434763 435550 438052 439467 442750 447094 447604 449450 451133 456466 456487 457026 457226 458744 458882 459191 462572 463966 464721 465385 466397 466491 467642 469011 474964 477881 479955 479962 484879 485258 485589 485619 485996 490945 492986 500576 500976 501415 502729 503498 504132 504320 505078 506233 507630 507641 513007 514904 517143 517927 519476 520098 520898 521017 522513 524239 525186 526865 528663 528751 536871 538194 548297 549729 552380 555000 560814 563722 565687 565695 565773 571048 575557 576081 579396 582920 584465 585156 588052 588953 591219 591694 597432 602944 603067 603783 605498 605963 609235 610011 610832 612068 614715 623211 623499 625369 626405 637172 641414 670056 691137 693284 696430 721895 722277 726718 733319 742279 757094 767025 785507 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife porn"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен porn"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен porn"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.06%) |
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.