Query Metrics
7
Database Queries
7
Different statements
243.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
219.35 ms (90.00%) |
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 383464 396881 403769 416155 417562 418636 418646 418795 420808 421609 421806 422348 422386 425299 425302 425306 434887 436830 436850 439480 449499 450119 451655 452429 452680 453833 454036 456738 457545 459087 459607 460685 460833 461151 461166 461309 461323 462259 464562 466471 472850 474982 480334 480697 499034 505782 507674 509329 515010 520437 522209 527261 527596 533246 546292 546568 548992 549080 552638 556493 567297 567872 574732 584949 593795 602932 605281 609422 610275 616098 623037 628618 629868 630351 630893 643573 647916 661616 690154 693103 716693 734334 759417 760679 765092 765102 766263 766354 766668 770623 771177 771657 773746 775264 776161 778543 783992 784981 788839 789058 791688 792767 793555 793663 793871 795632 798045 799095 800523 800554 802823 803309 803806 805075 807419 819857 823659 824434 827825 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (6.27%) |
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 456738 459607 474982 383464 792767 549080 799095 436830 824434 567297 567872 628618 609422 610275 781177 798045 803806 805075 789058 759417 773746 760679 425306 418646 629868 461323 421806 434887 793663 533246 734334 461151 425302 693103 778543 766354 766668 418636 460685 690154 436850 462259 459087 439480 417562 630351 454036 418795 795632 771177 461166 453833 784981 466471 480697 509329 548992 556493 552638 584949 800523 396881 460833 522209 819857 461309 403769 499034 416155 450119 472850 574732 593795 425299 480334 507674 457545 420808 452680 421609 449499 823659 827825 643573 775264 776161 791688 802823 766263 770623 765092 771657 793871 422348 520437 527596 616098 630893 452429 464562 527261 422386 515010 765102 793555 451655 800554 546292 546568 716693 783992 505782 605281 602932 647916 661616 623037 788839 807419 803309 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.21%) |
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 383464 396881 403769 416155 417562 418636 418646 418795 420808 421609 421806 422348 422386 425299 425302 425306 434887 436830 436850 439480 449499 450119 451655 452429 452680 453833 454036 456738 457545 459087 459607 460685 460833 461151 461166 461309 461323 462259 464562 466471 472850 474982 480334 480697 499034 505782 507674 509329 515010 520437 522209 527261 527596 533246 546292 546568 548992 549080 552638 556493 567297 567872 574732 584949 593795 602932 605281 609422 610275 616098 623037 628618 629868 630351 630893 643573 647916 661616 690154 693103 716693 734334 759417 760679 765092 765102 766263 766354 766668 770623 771177 771657 773746 775264 776161 778543 783992 784981 788839 789058 791688 792767 793555 793663 793871 795632 798045 799095 800523 800554 802823 803309 803806 805075 807419 819857 823659 824434 827825 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov creampie blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов creampie минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов creampie минет оральн секс"
]
|
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.