Query Metrics
7
Database Queries
7
Different statements
237.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.87 ms (89.58%) |
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 89 398387 400004 410062 432704 441453 441518 441562 485995 487973 510303 512458 516044 539276 547434 549020 560982 564559 584260 585993 600696 604311 604320 604371 608121 609289 618363 623825 625745 629744 654922 655132 655279 656483 656567 656579 661673 661950 661987 680250 683121 684404 689154 693490 710018 710736 713877 714070 715888 715907 719725 720008 720085 721910 724050 724346 725032 726957 727731 727737 727792 734960 734973 736780 740883 742362 745069 748362 749009 750331 756331 756670 761104 762917 763510 763797 765398 765406 765449 767086 767090 767269 768388 769043 771353 773678 775484 775712 776216 781355 787512 788846 788857 791418 791782 792706 793232 794368 795303 795900 795916 796153 796196 797174 797444 798799 800638 800975 803255 804335 817235 817280 817311 820177 824263 824454 824862 826153 827508 827588 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (6.31%) |
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 765406 773678 487973 817311 826153 824263 827588 549020 680250 720085 796196 797174 803255 775712 781355 791418 795303 745069 740883 749009 609289 715888 791782 798799 748362 756331 742362 618363 656579 661673 655279 655132 684404 714070 600696 604320 623825 804335 768388 727792 800975 721910 604371 725032 817235 824862 827508 720008 756670 762917 693490 656483 727731 727737 710736 824454 715907 775484 776216 787512 736780 761104 719725 441453 441518 560982 750331 792706 432704 516044 564559 654922 765398 796153 441562 656567 400004 539276 584260 661950 713877 547434 625745 788846 788857 793232 800638 724346 763510 726957 734960 734973 765449 769043 767086 767269 767090 604311 710018 398387 510303 410062 661987 512458 608121 689154 585993 629744 724050 683121 817280 795900 797444 820177 771353 763797 795916 89 485995 794368 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.06%) |
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 89 398387 400004 410062 432704 441453 441518 441562 485995 487973 510303 512458 516044 539276 547434 549020 560982 564559 584260 585993 600696 604311 604320 604371 608121 609289 618363 623825 625745 629744 654922 655132 655279 656483 656567 656579 661673 661950 661987 680250 683121 684404 689154 693490 710018 710736 713877 714070 715888 715907 719725 720008 720085 721910 724050 724346 725032 726957 727731 727737 727792 734960 734973 736780 740883 742362 745069 748362 749009 750331 756331 756670 761104 762917 763510 763797 765398 765406 765449 767086 767090 767269 768388 769043 771353 773678 775484 775712 776216 781355 787512 788846 788857 791418 791782 792706 793232 794368 795303 795900 795916 796153 796196 797174 797444 798799 800638 800975 803255 804335 817235 817280 817311 820177 824263 824454 824862 826153 827508 827588 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade creampie anal"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск creampie анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск creampie анал"
]
|
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.