Query Metrics
7
Database Queries
7
Different statements
147.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.55 ms (83.06%) |
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 84837 88505 384046 386569 388773 389719 392959 412616 418464 419201 419354 420320 443481 452482 455017 459248 462000 468232 477463 479477 489115 506306 511127 512751 514661 517372 520032 520994 523590 529866 533572 540127 543678 546617 553155 554698 554708 555301 563977 565834 571828 574025 580666 585229 588494 592118 600668 602221 602993 603121 610552 614578 617471 635183 635328 662790 668733 686410 687778 691535 692944 693264 696287 697204 697682 708320 713423 716148 722368 724040 725649 730528 732178 732685 734709 735472 737998 740326 746016 748959 751386 753619 759222 760479 761445 764731 766929 768343 768649 768702 769434 776544 780543 787261 787266 787392 793895 794011 794102 795108 795109 798409 798727 799915 801049 803874 810029 813856 814464 816666 817880 818750 818813 818877 819940 824479 825698 825904 825925 827989 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (9.88%) |
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 546617 574025 543678 668733 697682 799915 737998 766929 768343 746016 751386 84837 814464 565834 686410 602221 602993 392959 88505 388773 389719 419354 506306 512751 412616 825698 825925 825904 816666 818813 818877 819940 813856 817880 824479 818750 827989 529866 540127 533572 554698 553155 554708 563977 693264 662790 687778 691535 716148 692944 696287 708320 713423 555301 600668 592118 614578 635183 617471 780543 787392 793895 810029 795108 801049 725649 734709 740326 760479 761445 768702 769434 787266 795109 798727 803874 732685 735472 753619 724040 768649 730528 732178 748959 759222 764731 635328 697204 722368 787261 794011 794102 798409 420320 459248 468232 479477 455017 520032 520994 514661 523590 462000 477463 571828 580666 585229 588494 610552 603121 776544 452482 443481 517372 511127 384046 419201 489115 418464 386569 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.88%) |
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 84837 88505 384046 386569 388773 389719 392959 412616 418464 419201 419354 420320 443481 452482 455017 459248 462000 468232 477463 479477 489115 506306 511127 512751 514661 517372 520032 520994 523590 529866 533572 540127 543678 546617 553155 554698 554708 555301 563977 565834 571828 574025 580666 585229 588494 592118 600668 602221 602993 603121 610552 614578 617471 635183 635328 662790 668733 686410 687778 691535 692944 693264 696287 697204 697682 708320 713423 716148 722368 724040 725649 730528 732178 732685 734709 735472 737998 740326 746016 748959 751386 753619 759222 760479 761445 764731 766929 768343 768649 768702 769434 776544 780543 787261 787266 787392 793895 794011 794102 795108 795109 798409 798727 799915 801049 803874 810029 813856 814464 816666 817880 818750 818813 818877 819940 824479 825698 825904 825925 827989 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam shower"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер shower"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер shower"
]
|
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.