Query Metrics
7
Database Queries
7
Different statements
1122.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
985.73 ms (87.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс slut жен"
]
|
||||||||||||||||||||||||||||||
|
116.28 ms (10.35%) |
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 207918 391394 395655 398552 400950 456067 457027 477038 478524 482144 485986 489158 499361 507985 508196 508258 513935 520658 529597 530599 531275 533679 538527 546660 549193 553655 554101 554795 554834 554860 555670 557807 558777 560337 579696 580561 581305 587948 591523 600335 602806 604263 613651 614748 615358 632490 639080 640236 641564 641567 646061 650602 652999 653120 653175 658180 661593 662084 680435 686158 691050 700047 706381 706479 713924 720419 726248 726957 726966 726976 726983 730323 738327 740539 745391 747135 750789 760730 760953 761306 763444 765114 765361 765371 765456 769016 773482 773972 776968 777868 778932 779142 780410 780876 782453 782470 783428 783879 784138 785540 787513 791080 794368 795968 796048 796166 796726 798867 802554 803722 804937 810625 811773 812391 813288 818106 818186 823760 824265 826232 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (1.18%) |
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 802554 738327 763444 740539 531275 557807 653175 530599 652999 773972 780876 794368 207918 824265 513935 508196 529597 579696 650602 686158 706479 646061 658180 661593 691050 720419 641567 777868 782470 813288 778932 791080 784138 787513 796166 804937 726976 726983 760953 750789 765361 765371 769016 700047 783428 489158 553655 538527 482144 558777 680435 726966 632490 581305 641564 726248 546660 499361 520658 803722 795968 395655 391394 818106 818186 457027 508258 554860 560337 554795 555670 653120 706381 662084 554101 615358 640236 591523 604263 600335 587948 613651 639080 782453 812391 783879 796726 765114 810625 765456 726957 760730 602806 614748 713924 785540 485986 507985 400950 826232 456067 773482 398552 796048 798867 533679 478524 747135 745391 779142 776968 780410 823760 554834 580561 811773 761306 477038 730323 549193 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.22%) |
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 207918 391394 395655 398552 400950 456067 457027 477038 478524 482144 485986 489158 499361 507985 508196 508258 513935 520658 529597 530599 531275 533679 538527 546660 549193 553655 554101 554795 554834 554860 555670 557807 558777 560337 579696 580561 581305 587948 591523 600335 602806 604263 613651 614748 615358 632490 639080 640236 641564 641567 646061 650602 652999 653120 653175 658180 661593 662084 680435 686158 691050 700047 706381 706479 713924 720419 726248 726957 726966 726976 726983 730323 738327 740539 745391 747135 750789 760730 760953 761306 763444 765114 765361 765371 765456 769016 773482 773972 776968 777868 778932 779142 780410 780876 782453 782470 783428 783879 784138 785540 787513 791080 794368 795968 796048 796166 796726 798867 802554 803722 804937 810625 811773 812391 813288 818106 818186 823760 824265 826232 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс slut жен"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex slut wife"
]
|
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.