Query Metrics
7
Database Queries
7
Different statements
183.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.75 ms (85.76%) |
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 174896 386900 387192 387293 391954 397199 401035 403347 403901 411469 414009 419640 421257 421303 426722 434277 443422 445064 445098 445365 450793 453028 454909 459883 462605 465001 469350 479738 487013 491431 493470 499921 501702 505343 511670 513794 515546 516619 516676 519374 523759 524795 534772 536582 537311 539599 540252 541103 541106 547631 548547 552989 556789 563267 580850 582794 587120 587206 592164 593245 596675 597031 600564 601024 601772 602821 607403 607599 610626 612265 617009 618565 622366 623934 624426 626866 628343 631750 643263 660412 668701 682320 691598 693185 695869 715462 724289 724527 730074 730722 735906 739125 745309 752633 752644 752676 759132 762671 770800 773670 774699 775107 776209 776273 776400 781780 781826 782059 782560 784681 787966 790696 790853 792843 804234 811125 825523 826278 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (9.01%) |
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 547631 552989 563267 592164 612265 626866 643263 587206 623934 624426 628343 587120 593245 601024 724527 762671 607403 617009 622366 419640 524795 403901 782560 387293 421303 445098 445365 826278 487013 450793 511670 537311 501702 539599 513794 519374 459883 493470 548547 580850 556789 541106 691598 715462 693185 668701 682320 695869 582794 618565 601772 610626 631750 597031 776400 781780 804234 774699 776209 781826 787966 730074 752676 770800 784681 811125 724289 730722 735906 752633 752644 607599 790853 391954 426722 462605 401035 411469 434277 443422 421257 523759 596675 776273 759132 782059 826524 491431 174896 825523 536582 505343 397199 600564 792843 386900 479738 499921 516619 540252 515546 516676 534772 541103 564310 660412 790696 739125 745309 773670 469350 602821 387192 403347 775107 414009 445064 453028 465001 454909 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.49%) |
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 174896 386900 387192 387293 391954 397199 401035 403347 403901 411469 414009 419640 421257 421303 426722 434277 443422 445064 445098 445365 450793 453028 454909 459883 462605 465001 469350 479738 487013 491431 493470 499921 501702 505343 511670 513794 515546 516619 516676 519374 523759 524795 534772 536582 537311 539599 540252 541103 541106 547631 548547 552989 556789 563267 580850 582794 587120 587206 592164 593245 596675 597031 600564 601024 601772 602821 607403 607599 610626 612265 617009 618565 622366 623934 624426 626866 628343 631750 643263 660412 668701 682320 691598 693185 695869 715462 724289 724527 730074 730722 735906 739125 745309 752633 752644 752676 759132 762671 770800 773670 774699 775107 776209 776273 776400 781780 781826 782059 782560 784681 787966 790696 790853 792843 804234 811125 825523 826278 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge boobs"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные boobs"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные boobs"
]
|
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.