Query Metrics
7
Database Queries
7
Different statements
234.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.71 ms (89.99%) |
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 542912 545833 575300 585161 651322 655561 684681 710689 715098 715484 717459 718007 718017 718029 720808 723124 723242 724700 729802 730408 732634 732789 732956 732965 733452 734011 738503 739298 739587 740380 740747 742841 745149 745601 746900 749426 750511 750522 750535 752354 754891 758337 758382 760417 761715 762130 762700 763389 763390 763393 763771 764858 765404 766077 766241 769610 769650 769985 771773 772435 772510 773299 773749 775241 776530 776544 776546 777598 778102 778673 778696 780732 782374 782378 782386 783973 784006 784013 784300 787230 790144 790152 791145 791966 792322 794282 797015 797043 798610 798876 799280 799913 799924 804239 804262 805036 805072 805116 806613 807053 807879 807972 808306 811893 812247 812484 812493 812816 814177 819644 824683 824941 825368 826237 826405 826407 826611 826615 827677 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (5.76%) |
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 825368 782374 782386 797043 792322 797015 799924 805116 758382 763393 790144 798876 805036 732789 762700 769610 733452 772510 750535 758337 766077 715484 776530 777598 778673 780732 790152 804239 807879 807972 812247 812484 684681 776544 542912 575300 798610 738503 775241 710689 717459 791145 804262 732965 769985 545833 585161 814177 819644 826611 824941 826405 826615 824683 826109 826407 827677 655561 718029 651322 718007 715098 720808 778102 784006 782378 812816 729802 739587 740380 742841 745149 746900 760417 783973 784013 784300 799280 805072 806613 811893 732634 732956 739298 750522 762130 764858 773299 724700 745601 750511 752354 765404 772435 730408 754891 763389 763390 766241 769650 771773 740747 749426 761715 763771 773749 718017 723124 723242 776546 778696 787230 794282 799913 807053 826237 734011 791966 808306 812493 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.31%) |
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 542912 545833 575300 585161 651322 655561 684681 710689 715098 715484 717459 718007 718017 718029 720808 723124 723242 724700 729802 730408 732634 732789 732956 732965 733452 734011 738503 739298 739587 740380 740747 742841 745149 745601 746900 749426 750511 750522 750535 752354 754891 758337 758382 760417 761715 762130 762700 763389 763390 763393 763771 764858 765404 766077 766241 769610 769650 769985 771773 772435 772510 773299 773749 775241 776530 776544 776546 777598 778102 778673 778696 780732 782374 782378 782386 783973 784006 784013 784300 787230 790144 790152 791145 791966 792322 794282 797015 797043 798610 798876 799280 799913 799924 804239 804262 805036 805072 805116 806613 807053 807879 807972 808306 811893 812247 812484 812493 812816 814177 819644 824683 824941 825368 826237 826405 826407 826611 826615 827677 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tik tok tits"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.