Query Metrics
7
Database Queries
7
Different statements
369.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.53 ms (57.58%) |
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 398842 420900 458590 470627 511164 511203 523583 524065 547233 547388 551585 551608 558152 559727 572230 582534 588616 591156 597202 610489 613373 614440 616658 617038 631339 632796 649086 649768 666665 667999 669313 677128 682620 689964 691688 693882 694137 699787 700359 703211 703506 703644 703730 706700 709393 710997 713683 713816 718530 719153 720745 725403 725789 728799 728811 732967 734064 734391 735814 735965 736576 741167 741681 742045 743632 743895 750080 752314 753469 755814 757880 759543 761437 762261 762475 763145 763223 766093 767330 771110 773290 774361 774559 775211 777956 777977 778094 778916 779628 780273 780378 780632 781289 782326 782514 783065 784725 785240 785858 789095 791397 791828 792335 793375 795614 797388 797578 798983 799015 799451 799994 803277 804485 804517 804578 811473 818484 ] |
||||||||||||||||||||||||||||||
|
135.65 ms (36.75%) |
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 398842 420900 458590 470627 511164 511203 523583 524065 547233 547388 551585 551608 558152 559727 572230 582534 588616 591156 597202 610489 613373 614440 616658 617038 631339 632796 649086 649768 666665 667999 669313 677128 682620 689964 691688 693882 694137 699787 700359 703211 703506 703644 703730 706700 709393 710997 713683 713816 718530 719153 720745 725403 725789 728799 728811 732967 734064 734391 735814 735965 736576 741167 741681 742045 743632 743895 750080 752314 753469 755814 757880 759543 761437 762261 762475 763145 763223 766093 767330 771110 773290 774361 774559 775211 777956 777977 778094 778916 779628 780273 780378 780632 781289 782326 782514 783065 784725 785240 785858 789095 791397 791828 792335 793375 795614 797388 797578 798983 799015 799451 799994 803277 804485 804517 804578 811473 818484 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (3.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 582534 689964 694137 703730 710997 719153 720745 649086 682620 666665 713683 551585 610489 613373 616658 588616 614440 777956 778916 780378 781289 785858 804517 804578 804485 725403 725789 732967 734391 755814 757880 766093 782326 783065 789095 791397 799994 811473 736576 762013 762261 762475 741681 774361 735965 763223 734064 742045 743895 761437 771110 617038 700359 718530 774559 778094 780632 787390 791828 470627 693882 631339 753469 772018 735814 511164 524065 558152 703211 572230 795614 797388 763145 784725 741167 743632 728799 775211 420900 547233 818484 759543 398842 458590 523583 511203 551608 547388 706700 649768 699787 703506 667999 669313 677128 691688 709393 713816 559727 597202 632796 591156 779628 777977 785240 793375 798983 799451 752314 797578 803277 773290 728811 750080 767330 703644 780273 782514 792335 799015 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"suck девушк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"suck girls"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"suck девушк"
]
|
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.