Query Metrics
7
Database Queries
7
Different statements
194.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.74 ms (85.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 410682 413381 413398 413406 413432 414116 415877 416600 418144 421052 428280 430066 432268 435689 438464 439427 443086 443234 443236 443239 443244 446547 447318 449208 450357 452430 456705 458099 462942 465054 466443 466739 469124 469198 470633 471155 471357 471455 475406 479544 479726 480209 482280 482291 486776 487535 497401 501958 511893 514115 514867 517710 518183 518185 518210 518915 520763 522161 530387 532739 537250 538669 540348 542904 543864 545117 545390 548538 548550 560405 560408 560425 560427 570721 574685 579337 582377 590349 591217 593470 594113 596693 602614 604229 606817 616315 624942 625177 628094 631330 644276 709917 716394 716496 728370 734840 738471 738496 739165 744939 750121 752636 752664 755079 765668 766825 803557 806580 806688 808327 ] |
||||||||||||||||||||||||||||||
|
17.11 ms (8.82%) |
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 738471 766825 728370 738496 739165 752636 752664 765668 475406 466443 471155 446547 518185 518915 518183 487535 522161 438464 413406 443236 428280 439427 415877 458099 469124 482280 462942 514867 540348 511893 479544 479726 560427 579337 543864 570721 542904 560405 582377 709917 545117 625177 628094 590349 604229 594113 606817 803557 755079 806688 734840 744939 750121 631330 413398 421052 443234 416600 480209 470633 430066 497401 443239 413381 435689 456705 466739 447318 452430 486776 517710 518210 574685 716496 616315 591217 624942 807580 808327 432268 443086 449208 413432 410682 482291 465054 530387 537250 548550 596693 644276 593470 716394 471455 414116 418144 450357 532739 501958 560425 545390 602614 806580 443244 514115 560408 548538 471357 469198 520763 538669 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.76%) |
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 410682 413381 413398 413406 413432 414116 415877 416600 418144 421052 428280 430066 432268 435689 438464 439427 443086 443234 443236 443239 443244 446547 447318 449208 450357 452430 456705 458099 462942 465054 466443 466739 469124 469198 470633 471155 471357 471455 475406 479544 479726 480209 482280 482291 486776 487535 497401 501958 511893 514115 514867 517710 518183 518185 518210 518915 520763 522161 530387 532739 537250 538669 540348 542904 543864 545117 545390 548538 548550 560405 560408 560425 560427 570721 574685 579337 582377 590349 591217 593470 594113 596693 602614 604229 606817 616315 624942 625177 628094 631330 644276 709917 716394 716496 728370 734840 738471 738496 739165 744939 750121 752636 752664 755079 765668 766825 803557 806580 806688 808327 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сексмашин teens"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex machine teens"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин teens"
]
|
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.