Query Metrics
7
Database Queries
7
Different statements
163.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.56 ms (86.05%) |
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 7133 393323 514851 515284 515287 529925 531744 531952 534083 536093 541911 543329 546172 546258 546547 546988 547691 548113 548457 548974 549117 550815 553644 556287 557617 559970 561763 566827 571091 571123 579266 583580 583695 588711 597153 601432 609691 610164 614460 620369 620920 624379 624603 626028 628101 634307 639113 641300 650246 651327 660036 666142 669898 671842 672279 673008 675347 679543 679582 683669 692664 692697 693086 695001 701405 702616 705414 707581 707714 712659 715142 716309 716530 721956 722059 722406 729907 729932 733899 746194 752548 755566 761515 779861 784458 786077 790146 792102 794300 796077 796405 800547 802888 803393 804133 805325 805495 808611 816704 816733 817646 819278 819406 819909 820198 824559 824675 824778 824798 824835 825838 826055 826139 826809 826848 826867 827064 827093 827531 ] |
||||||||||||||||||||||||||||||
|
12.87 ms (7.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 393323 7133 824778 824835 826139 826055 816733 817646 819406 819909 820198 824559 824675 826867 826848 827064 827093 827531 816704 824798 825838 819278 826809 515284 515287 529925 531952 534083 514851 531744 536093 546258 548113 548457 548974 549117 556287 566827 571091 579266 583580 583695 543329 541911 547691 550815 557617 561763 571123 651327 669898 679543 679582 707714 712659 715142 716309 722059 660036 672279 683669 692697 693086 695001 702616 707581 721956 650246 666142 671842 673008 675347 692664 701405 705414 716530 722406 546172 546547 546988 553644 559970 610164 639113 620920 624379 634307 588711 624603 597153 601432 609691 614460 620369 626028 628101 641300 780402 792102 794300 796405 803393 804133 805325 808611 779861 784458 786077 790146 796077 800547 802888 805495 729907 729932 733899 746194 752548 755566 761515 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.65%) |
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 7133 393323 514851 515284 515287 529925 531744 531952 534083 536093 541911 543329 546172 546258 546547 546988 547691 548113 548457 548974 549117 550815 553644 556287 557617 559970 561763 566827 571091 571123 579266 583580 583695 588711 597153 601432 609691 610164 614460 620369 620920 624379 624603 626028 628101 634307 639113 641300 650246 651327 660036 666142 669898 671842 672279 673008 675347 679543 679582 683669 692664 692697 693086 695001 701405 702616 705414 707581 707714 712659 715142 716309 716530 721956 722059 722406 729907 729932 733899 746194 752548 755566 761515 779861 784458 786077 790146 792102 794300 796077 796405 800547 802888 803393 804133 805325 805495 808611 816704 816733 817646 819278 819406 819909 820198 824559 824675 824778 824798 824835 825838 826055 826139 826809 826848 826867 827064 827093 827531 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife toys"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен toys"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен toys"
]
|
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.