Query Metrics
7
Database Queries
7
Different statements
143.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.46 ms (83.78%) |
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 397664 400497 417783 418519 420565 423783 424002 426238 426465 428229 435027 438127 438454 439274 439322 439526 443085 444180 446054 452373 454412 456170 462236 462840 470585 473515 478969 479472 479746 485980 490070 493300 493961 495319 507217 507638 509168 509566 509664 509970 510425 513502 516718 517261 518552 518611 519354 520649 523762 523884 524859 525785 525884 526173 526293 528143 528452 528727 531599 532729 534604 537051 537377 537777 542090 549554 550817 554210 554234 556009 556015 556481 557226 559777 561273 561909 562878 563363 565986 567548 571277 581021 581225 581478 584200 586385 586861 587576 591275 594549 598136 601862 605858 606576 612171 613499 615674 625127 643933 662405 666133 672229 697000 701904 711341 711354 716915 716921 727692 733446 760443 775271 784593 796804 796881 797078 797241 798763 810103 812564 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.86%) |
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 537051 525785 531599 534604 537777 542090 563363 565986 571277 581021 581478 549554 561909 662405 584200 586861 601862 612171 587576 598136 605858 810103 797078 812564 760443 733446 727692 613499 784593 420565 438454 438127 439274 444180 473515 509168 485980 520649 523884 456170 495319 561273 567548 526173 493961 507638 525884 697000 426465 439322 452373 454412 532729 550817 556481 562878 554234 666133 581225 606576 625127 796881 796804 424002 462236 417783 439526 470585 428229 528143 493300 509566 518552 519354 523762 507217 537377 557226 418519 509664 509970 516718 672229 443085 490070 526293 517261 556015 559777 594549 615674 586385 797241 479472 400497 426238 435027 510425 513502 397664 711354 716915 798763 479746 556009 423783 518611 446054 554210 591275 643933 462840 478969 524859 528727 716921 701904 775271 711341 528452 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.98%) |
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 397664 400497 417783 418519 420565 423783 424002 426238 426465 428229 435027 438127 438454 439274 439322 439526 443085 444180 446054 452373 454412 456170 462236 462840 470585 473515 478969 479472 479746 485980 490070 493300 493961 495319 507217 507638 509168 509566 509664 509970 510425 513502 516718 517261 518552 518611 519354 520649 523762 523884 524859 525785 525884 526173 526293 528143 528452 528727 531599 532729 534604 537051 537377 537777 542090 549554 550817 554210 554234 556009 556015 556481 557226 559777 561273 561909 562878 563363 565986 567548 571277 581021 581225 581478 584200 586385 586861 587576 591275 594549 598136 601862 605858 606576 612171 613499 615674 625127 643933 662405 666133 672229 697000 701904 711341 711354 716915 716921 727692 733446 760443 775271 784593 796804 796881 797078 797241 798763 810103 812564 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation home"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац home"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац home"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
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.