Query Metrics
7
Database Queries
7
Different statements
143.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.08 ms (83.23%) |
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 99157 121824 202970 311520 339770 381873 387520 390397 393856 397802 413995 458208 463285 480538 496713 514795 516479 527787 531666 533255 533259 533701 536488 537539 537698 537710 537786 537874 563548 563904 569213 569746 598556 610308 611893 622917 623325 624419 629846 630178 630281 644357 645881 646865 650431 660026 673793 674770 686620 691821 692405 696165 697461 699638 701763 702176 702689 707309 714384 715143 715524 716191 716215 717961 726814 727758 731811 734522 741472 742719 743752 744779 748167 752195 755555 760841 761038 765376 770555 770966 775341 776775 784211 785894 789500 789720 789995 790005 793643 794169 797186 798047 798733 804606 805724 806966 807179 808181 811315 811986 812769 813475 813486 813797 815180 816063 816886 817088 818513 819612 820119 821187 822278 822473 823109 825339 826129 828089 828873 ] |
||||||||||||||||||||||||||||||
|
13.70 ms (9.58%) |
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 496713 514795 533701 537698 537874 531666 537539 569213 569746 645881 646865 650431 714384 717961 673793 692405 696165 697461 702176 716191 611893 622917 598556 629846 630281 610308 623325 630178 644357 775341 776775 789995 798733 808181 811315 811986 784211 789500 789720 793643 798047 813475 813486 741472 752195 755555 804606 805724 726814 744779 727758 743752 748167 699638 702689 715143 790005 807179 812769 99157 339770 397802 691821 686620 563904 202970 458208 390397 823109 770966 806966 381873 533255 516479 624419 794169 797186 413995 393856 742719 563548 387520 828873 480538 701763 660026 770555 765376 761038 815180 822278 816063 816886 821187 707309 715524 674770 716215 760841 734522 731811 785894 463285 121824 311520 813797 820119 822473 826129 817088 825339 822348 818513 819612 828089 533259 536488 537710 537786 527787 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.98%) |
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 99157 121824 202970 311520 339770 381873 387520 390397 393856 397802 413995 458208 463285 480538 496713 514795 516479 527787 531666 533255 533259 533701 536488 537539 537698 537710 537786 537874 563548 563904 569213 569746 598556 610308 611893 622917 623325 624419 629846 630178 630281 644357 645881 646865 650431 660026 673793 674770 686620 691821 692405 696165 697461 699638 701763 702176 702689 707309 714384 715143 715524 716191 716215 717961 726814 727758 731811 734522 741472 742719 743752 744779 748167 752195 755555 760841 761038 765376 770555 770966 775341 776775 784211 785894 789500 789720 789995 790005 793643 794169 797186 798047 798733 804606 805724 806966 807179 808181 811315 811986 812769 813475 813486 813797 815180 816063 816886 817088 818513 819612 820119 821187 822278 822473 823109 825339 826129 828089 828873 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass mother"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.14%) |
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.