Query Metrics
7
Database Queries
7
Different statements
370.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.67 ms (57.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf соло домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
122.97 ms (33.19%) |
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 415745 435590 469147 475419 511355 516057 516640 528405 531299 531918 532032 535003 543329 547541 548457 548895 549151 550815 550927 552558 553226 553766 553810 554698 554869 558157 558170 559414 559422 567114 568179 568241 568242 571350 574077 580240 598347 613109 613750 615154 615453 619902 634709 646044 659249 661025 662815 708226 712120 714322 714336 714346 714357 714707 722059 724508 725435 731220 731458 733073 733366 733441 735292 735956 739964 740895 744751 745215 747047 748289 750347 751002 751046 751797 753738 754531 754666 755500 755566 756773 757064 757463 759143 760383 760566 761937 761938 761952 769434 770020 770038 770173 772902 776849 778182 779837 779861 781268 782492 787634 788447 788508 791424 792740 795648 797044 801667 802320 803036 803749 804399 804419 804836 806389 806762 807236 810328 812201 812330 825767 ] |
||||||||||||||||||||||||||||||
|
22.74 ms (6.14%) |
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 531299 535003 548457 550927 553766 554698 558170 567114 568179 568241 543329 574077 548895 549151 550815 552558 558157 568242 722059 659249 646044 712120 547541 553226 553810 554869 559414 559422 598347 779837 795648 812201 776849 779861 782492 787634 806389 812330 733366 740895 744751 748289 755500 755566 757463 769434 781268 802320 807236 735292 751046 757064 760383 761937 761952 770020 745215 747047 751002 754531 759143 761938 770038 772902 750347 751797 753738 754666 725435 731220 760566 778182 788447 797044 803749 804419 810328 613750 615154 516057 801667 804399 825767 531918 532032 662815 708226 714707 615453 613109 619902 806762 804836 756773 735956 770173 731458 733441 739964 634709 788508 415745 516640 571350 475419 511355 580240 733073 435590 661025 714336 714346 714357 714322 803036 724508 528405 791424 792740 469147 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (0.98%) |
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 415745 435590 469147 475419 511355 516057 516640 528405 531299 531918 532032 535003 543329 547541 548457 548895 549151 550815 550927 552558 553226 553766 553810 554698 554869 558157 558170 559414 559422 567114 568179 568241 568242 571350 574077 580240 598347 613109 613750 615154 615453 619902 634709 646044 659249 661025 662815 708226 712120 714322 714336 714346 714357 714707 722059 724508 725435 731220 731458 733073 733366 733441 735292 735956 739964 740895 744751 745215 747047 748289 750347 751002 751046 751797 753738 754531 754666 755500 755566 756773 757064 757463 759143 760383 760566 761937 761938 761952 769434 770020 770038 770173 772902 776849 778182 779837 779861 781268 782492 787634 788447 788508 791424 792740 795648 797044 801667 802320 803036 803749 804399 804419 804836 806389 806762 807236 810328 812201 812330 825767 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf solo homemade"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf соло домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.