Query Metrics
7
Database Queries
7
Different statements
169.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.36 ms (87.77%) |
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 12983 383156 383173 398870 401252 408694 435879 451863 467150 475193 569354 573343 580082 582452 585334 587310 602419 605786 605900 611009 613447 613678 615810 619970 623279 624464 626346 628627 631828 631994 632500 640231 664717 666821 678711 689883 691230 691871 693313 696966 696978 699156 699564 700611 701299 703379 705476 706727 707011 712481 712931 714823 715235 715319 715838 716824 718120 719237 720006 722679 724713 728012 728166 728920 730188 730378 730939 734986 736477 738522 739951 740503 744171 744303 751417 752446 755006 757453 757595 759148 759420 763496 764621 766241 768120 768641 770714 774186 778029 779028 780657 782054 782453 784181 785639 787893 789655 792539 795573 796225 799415 799604 801937 802619 803809 803892 805442 807330 810033 810575 811036 811530 811921 812188 813007 813452 814167 818062 821433 ] |
||||||||||||||||||||||||||||||
|
11.06 ms (6.54%) |
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 678711 689883 691230 714823 718120 720006 580082 587310 613678 628627 631828 602419 613447 619970 626346 640231 611009 605786 615810 796225 799604 811921 780657 784181 785639 802619 811530 744171 768641 770714 792539 810033 811036 813452 728012 730939 757453 757595 759148 728920 730188 736477 738522 739951 752446 764621 766241 631994 632500 699156 699564 700611 715838 716824 719237 778029 779028 787893 795573 799415 801937 803809 803892 812188 813007 398870 12983 693313 605900 789655 730378 383173 408694 451863 467150 569354 573343 701299 706727 713291 696978 712931 664717 707011 722679 807330 740503 744303 768120 623279 696966 703379 435879 383156 401252 814167 818062 821433 475193 582452 691871 712481 666821 705476 715235 585334 624464 782453 782054 805442 810575 751417 774186 724713 728166 763496 759420 734986 755006 715319 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.43%) |
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 12983 383156 383173 398870 401252 408694 435879 451863 467150 475193 569354 573343 580082 582452 585334 587310 602419 605786 605900 611009 613447 613678 615810 619970 623279 624464 626346 628627 631828 631994 632500 640231 664717 666821 678711 689883 691230 691871 693313 696966 696978 699156 699564 700611 701299 703379 705476 706727 707011 712481 712931 714823 715235 715319 715838 716824 718120 719237 720006 722679 724713 728012 728166 728920 730188 730378 730939 734986 736477 738522 739951 740503 744171 744303 751417 752446 755006 757453 757595 759148 759420 763496 764621 766241 768120 768641 770714 774186 778029 779028 780657 782054 782453 784181 785639 787893 789655 792539 795573 796225 799415 799604 801937 802619 803809 803892 805442 807330 810033 810575 811036 811530 811921 812188 813007 813452 814167 818062 821433 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucks girl"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucks девушк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucks девушк"
]
|
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.