Query Metrics
7
Database Queries
7
Different statements
238.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.63 ms (87.14%) |
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 392607 392754 395661 404644 421043 426940 428271 430313 432695 435747 442991 443832 444703 449723 449893 451493 457463 460197 461038 467121 467700 474776 481161 486345 486349 486834 488365 488378 490414 490419 490424 490430 492136 497517 498491 498492 499121 508450 513776 515018 516226 517023 518807 519013 523351 523832 524245 524257 527663 527982 531073 535450 538001 538002 538005 538008 538009 538010 546687 546950 546958 549822 549825 549831 549836 549839 549840 549844 549848 549849 550219 552290 556047 556806 559067 559071 559687 560400 561386 561447 563552 563643 564565 569232 569415 570160 579848 584498 591144 591356 599726 600007 603743 604243 609825 612917 644189 647901 663265 675006 699596 702621 715050 715786 718496 728452 730104 730352 742547 764151 770127 779584 784304 784760 788249 789691 796184 799951 800604 806084 ] |
||||||||||||||||||||||||||||||
|
20.51 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 764151 715050 392607 549836 432695 784760 474776 770127 603743 546687 546950 799951 435747 395661 570160 742547 442991 467121 561447 579848 789691 457463 564565 644189 591144 449893 404644 559071 663265 498492 699596 497517 800604 730104 599726 552290 806084 538005 488365 559687 523832 538010 718496 517023 569415 486834 715786 591356 426940 702621 796184 609825 490419 428271 556047 563643 549849 518807 584498 784304 519013 527663 561386 779584 612917 538002 486345 486349 549844 546958 604243 549831 549848 492136 499121 788249 498491 481161 560400 549822 730352 538009 549825 600007 460197 550219 538008 443832 516226 449723 675006 569232 563552 538001 527982 461038 647901 728452 392754 444703 421043 490414 490424 524245 531073 549839 523351 556806 513776 508450 559067 430313 515018 549840 467700 490430 535450 451493 488378 524257 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step-mom anal sex"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (1.00%) |
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 392607 392754 395661 404644 421043 426940 428271 430313 432695 435747 442991 443832 444703 449723 449893 451493 457463 460197 461038 467121 467700 474776 481161 486345 486349 486834 488365 488378 490414 490419 490424 490430 492136 497517 498491 498492 499121 508450 513776 515018 516226 517023 518807 519013 523351 523832 524245 524257 527663 527982 531073 535450 538001 538002 538005 538008 538009 538010 546687 546950 546958 549822 549825 549831 549836 549839 549840 549844 549848 549849 550219 552290 556047 556806 559067 559071 559687 560400 561386 561447 563552 563643 564565 569232 569415 570160 579848 584498 591144 591356 599726 600007 603743 604243 609825 612917 644189 647901 663265 675006 699596 702621 715050 715786 718496 728452 730104 730352 742547 764151 770127 779584 784304 784760 788249 789691 796184 799951 800604 806084 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step mom анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step mom анал секс"
]
|
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.