Query Metrics
7
Database Queries
7
Different statements
176.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.87 ms (84.12%) |
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 154171 154240 315244 384108 386156 386798 388545 391992 399028 408885 410702 413389 416522 416616 416639 416670 416696 416722 424765 441021 447151 450323 452794 452800 455080 459170 459198 471764 473426 477760 483583 486773 493688 493700 505336 506149 515488 518905 529713 529714 530368 530688 534537 536224 536226 540945 541274 544829 544831 545379 545392 547474 547847 548834 554100 561034 561040 564255 564289 569302 573188 576951 579457 586999 587292 590370 590831 594267 595339 595847 601208 604781 605219 627446 629243 642013 643080 656879 656888 658816 666898 669038 669073 669079 669376 669386 671044 680797 692943 695868 695870 711611 713503 720448 729327 742360 744266 745092 749207 749215 749259 749603 752630 752636 752669 752706 756843 760513 761116 770270 770386 782547 782548 787510 792092 792706 792726 803135 805046 811690 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (9.65%) |
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 742360 792706 782548 424765 452800 455080 386156 547847 666898 642013 530688 564255 711611 713503 656879 656888 720448 590831 749207 729327 749603 760513 792092 399028 518905 534537 548834 579457 692943 669073 594267 601208 782547 744266 761116 629243 447151 545392 669079 669376 669386 595339 604781 450323 154171 388545 410702 493688 536226 505336 536224 787510 386798 154240 529713 529714 530368 540945 658816 564289 590370 586999 745092 792726 752669 752630 770386 554100 803135 749259 770270 452794 749215 408885 416522 416639 416670 473426 486773 471764 573188 811690 416616 441021 506149 315244 416696 483583 515488 384108 413389 391992 459198 576951 805046 477760 544829 680797 756843 643080 541274 561034 695868 752636 459170 587292 569302 595847 545379 544831 547474 669038 671044 695870 561040 605219 752706 627446 416722 493700 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.95%) |
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 154171 154240 315244 384108 386156 386798 388545 391992 399028 408885 410702 413389 416522 416616 416639 416670 416696 416722 424765 441021 447151 450323 452794 452800 455080 459170 459198 471764 473426 477760 483583 486773 493688 493700 505336 506149 515488 518905 529713 529714 530368 530688 534537 536224 536226 540945 541274 544829 544831 545379 545392 547474 547847 548834 554100 561034 561040 564255 564289 569302 573188 576951 579457 586999 587292 590370 590831 594267 595339 595847 601208 604781 605219 627446 629243 642013 643080 656879 656888 658816 666898 669038 669073 669079 669376 669386 671044 680797 692943 695868 695870 711611 713503 720448 729327 742360 744266 745092 749207 749215 749259 749603 752630 752636 752669 752706 756843 760513 761116 770270 770386 782547 782548 787510 792092 792706 792726 803135 805046 811690 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fuck dildo"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс дилд"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.