Query Metrics
7
Database Queries
7
Different statements
178.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.06 ms (87.59%) |
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 491579 517811 529848 538474 539432 544876 545149 547642 547684 577175 582026 587268 589668 601791 606840 610993 611493 628631 629544 629609 643836 644086 649601 650551 650649 650688 660032 666116 670396 703291 703296 708251 716968 717438 718369 720168 720182 720201 720205 725366 729732 730786 732980 733030 734708 734759 734779 734783 734786 734800 734814 735396 736205 736208 736250 736513 736688 736695 736921 737260 737268 737770 738934 739071 739097 740661 740673 740726 740727 740757 740773 740775 742101 742113 742278 743005 743959 745859 746668 748028 750470 750507 750510 750638 753238 753733 756316 757516 757575 760758 761365 762764 762809 767226 771163 771325 772108 778602 782314 788550 788551 794740 794752 795855 796936 800090 800768 801773 801813 801836 808097 810912 812050 812062 813677 813700 818722 819302 825333 826883 ] |
||||||||||||||||||||||||||||||
|
11.87 ms (6.66%) |
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 735396 734786 736921 753238 740727 739097 547642 740661 740673 788551 801836 736695 750507 801773 813700 666116 720205 650551 720201 643836 644086 795855 725366 730786 703296 717438 813677 801813 782314 740726 800090 733030 750638 737268 740773 762809 756316 812062 649601 740775 743959 734814 750510 491579 748028 750470 819302 544876 734779 736513 589668 800768 734759 742278 760758 810912 732980 736205 736688 738934 746668 703291 716968 818722 606840 629609 737260 736208 737770 742113 761365 762764 729732 743005 757575 545149 577175 771163 539432 582026 788550 808097 742101 753733 734800 547684 708251 720182 650688 587268 611493 794740 736250 767226 734783 745859 772108 796936 517811 718369 670396 629544 601791 794752 739071 771325 740757 812050 757516 734708 778602 529848 628631 825333 826883 538474 650649 660032 720168 610993 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.86%) |
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 491579 517811 529848 538474 539432 544876 545149 547642 547684 577175 582026 587268 589668 601791 606840 610993 611493 628631 629544 629609 643836 644086 649601 650551 650649 650688 660032 666116 670396 703291 703296 708251 716968 717438 718369 720168 720182 720201 720205 725366 729732 730786 732980 733030 734708 734759 734779 734783 734786 734800 734814 735396 736205 736208 736250 736513 736688 736695 736921 737260 737268 737770 738934 739071 739097 740661 740673 740726 740727 740757 740773 740775 742101 742113 742278 743005 743959 745859 746668 748028 750470 750507 750510 750638 753238 753733 756316 757516 757575 760758 761365 762764 762809 767226 771163 771325 772108 778602 782314 788550 788551 794740 794752 795855 796936 800090 800768 801773 801813 801836 808097 810912 812050 812062 813677 813700 818722 819302 825333 826883 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl desi"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк desi"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк desi"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
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.