Query Metrics
7
Database Queries
7
Different statements
193.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.28 ms (83.41%) |
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 382236 393711 397424 398138 398733 406340 408532 469503 486044 487872 505591 529841 530092 530308 530651 532402 533700 533712 534862 535371 536082 542722 547070 547120 547445 547763 552861 559434 561511 564860 574656 579523 593661 595029 599705 612985 623710 625597 626351 626831 632086 634369 643668 647200 648572 661329 661383 666476 676756 683766 689868 690410 691847 694704 695652 696009 696061 697079 697917 701604 707812 708297 719889 721064 724318 731399 732099 734377 734394 735118 736507 736924 740148 741582 743872 751242 751408 752145 754644 755737 757557 758155 759817 761483 764879 768591 771990 777156 778140 778925 780210 780742 782745 783750 783781 789033 790433 792990 793019 793940 798812 799822 800448 804881 809742 809972 811857 812231 813612 813734 820475 824239 828050 828125 828138 828149 828414 828425 ] |
||||||||||||||||||||||||||||||
|
19.86 ms (10.27%) |
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 701604 707812 547120 535371 828050 827995 397424 408532 813612 820475 469503 486044 552861 579523 547763 547070 574656 695652 696009 696061 666476 694704 697917 708297 623710 625597 778925 789033 792990 804881 780742 736924 755737 783750 741582 751408 758155 764879 724318 752145 736507 754644 761483 697079 721064 793940 809972 564860 529841 533712 536082 530651 533700 647200 799822 780210 790433 757557 393711 643668 595029 690410 505591 534862 487872 626351 530092 626831 793019 740148 828425 828138 561511 542722 689868 734377 771990 632086 811857 661383 719889 768591 824239 828125 828149 828414 828624 530308 382236 398733 813734 532402 547445 559434 676756 648572 691847 661329 612985 593661 599705 778140 783781 800448 809742 812231 731399 732099 734394 743872 735118 759817 777156 798812 398138 406340 683766 634369 782745 751242 ] |
||||||||||||||||||||||||||||||
|
4.67 ms (2.41%) |
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 382236 393711 397424 398138 398733 406340 408532 469503 486044 487872 505591 529841 530092 530308 530651 532402 533700 533712 534862 535371 536082 542722 547070 547120 547445 547763 552861 559434 561511 564860 574656 579523 593661 595029 599705 612985 623710 625597 626351 626831 632086 634369 643668 647200 648572 661329 661383 666476 676756 683766 689868 690410 691847 694704 695652 696009 696061 697079 697917 701604 707812 708297 719889 721064 724318 731399 732099 734377 734394 735118 736507 736924 740148 741582 743872 751242 751408 752145 754644 755737 757557 758155 759817 761483 764879 768591 771990 777156 778140 778925 780210 780742 782745 783750 783781 789033 790433 792990 793019 793940 798812 799822 800448 804881 809742 809972 811857 812231 813612 813734 820475 824239 828050 828125 828138 828149 828414 828425 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public boobs"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на boobs улиц"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на boobs улиц"
]
|
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.