Query Metrics
7
Database Queries
7
Different statements
169.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.72 ms (83.39%) |
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 405683 410682 413381 413432 414116 414350 418126 418144 420116 421366 425940 429600 430353 432268 432289 432296 432936 433001 434337 434364 434374 443234 443236 443239 443244 443246 444924 448063 450357 453996 454000 454009 455078 455901 456705 458770 460208 462942 464959 466443 466739 467872 469124 469131 469198 471124 471455 475414 476055 476671 480475 482280 482291 486761 486763 486779 486831 494006 494481 499789 499922 500340 501958 509800 511376 513221 513223 514404 517710 520763 526167 527911 530387 532739 534381 535084 541839 542549 542904 545117 545390 545648 549514 549538 560902 560943 568479 576219 591217 595165 599852 602614 606549 616315 617418 625660 628094 640948 642219 652223 666859 700685 709917 716394 716496 744939 752453 755079 783486 785267 803557 806580 806688 808327 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (10.67%) |
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 467872 430353 527911 752453 642219 405683 425940 443236 429600 434337 469124 482280 462942 476671 480475 464959 666859 709917 545117 560943 628094 803557 755079 806688 744939 443234 455078 418126 482291 530387 443239 433001 466739 458770 471124 549514 560902 454000 455901 460208 486831 700685 606549 783486 640948 421366 568479 410682 454009 595165 599852 418144 486761 413381 432289 448063 534381 469131 476055 716496 616315 807580 808327 432268 434374 434364 453996 486763 511376 413432 414350 486779 514404 500340 545648 443246 471455 414116 501958 494006 602614 443244 432296 541839 652223 617418 716394 785267 432936 475414 450357 494481 535084 509800 499922 549538 420116 532739 545390 576219 806580 542549 513221 526167 444924 517710 513223 625660 466443 520763 499789 542904 469198 456705 591217 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.47%) |
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 405683 410682 413381 413432 414116 414350 418126 418144 420116 421366 425940 429600 430353 432268 432289 432296 432936 433001 434337 434364 434374 443234 443236 443239 443244 443246 444924 448063 450357 453996 454000 454009 455078 455901 456705 458770 460208 462942 464959 466443 466739 467872 469124 469131 469198 471124 471455 475414 476055 476671 480475 482280 482291 486761 486763 486779 486831 494006 494481 499789 499922 500340 501958 509800 511376 513221 513223 514404 517710 520763 526167 527911 530387 532739 534381 535084 541839 542549 542904 545117 545390 545648 549514 549538 560902 560943 568479 576219 591217 595165 599852 602614 606549 616315 617418 625660 628094 640948 642219 652223 666859 700685 709917 716394 716496 744939 752453 755079 783486 785267 803557 806580 806688 808327 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine anal"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
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.