Query Metrics
7
Database Queries
7
Different statements
142.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.09 ms (83.61%) |
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 539873 541182 542366 542826 542839 542848 543017 543025 543061 543081 543153 543160 543165 543222 543241 543267 543273 543479 543508 543510 543788 543803 544377 544677 544682 544702 544787 549151 549998 550059 550247 550690 554359 556957 557424 557455 557464 561452 562355 566566 569837 574969 575021 575024 575027 575046 575409 577115 580240 581747 586497 590182 605559 613444 622926 626794 629375 630594 632307 634927 635181 635183 640483 643975 650676 650705 664463 670220 682099 687522 687525 687560 687564 687608 688267 705121 706602 710356 711658 712336 713258 714427 718168 748055 748084 748094 750273 751192 752167 752455 773840 775110 789501 789644 789965 791789 810368 813738 818933 824878 825218 825338 825342 825370 825408 825446 825727 825835 825942 825970 826011 826062 826174 826438 826892 827885 828107 828329 828398 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (9.07%) |
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 542839 557424 664463 752455 825727 825338 828329 543017 688267 575027 789644 810368 549151 557464 670220 751192 773840 825942 543025 575021 713258 718168 632307 825408 825446 818933 825342 549998 575046 682099 590182 789501 543061 566566 562355 561452 586497 828398 550059 825386 541182 543153 577115 711658 575024 630594 748084 581747 543222 635181 825835 825970 826174 813738 824878 828107 543081 550690 543267 554359 557455 650705 650676 714427 544787 550247 556957 622926 626794 634927 635183 643975 789965 752167 748094 629375 791789 605559 539873 543160 574969 542366 543803 544377 687560 712336 750273 775110 543508 687522 575409 825370 827885 543273 706602 710356 640483 748055 542826 543479 569837 825218 826062 826892 826438 826011 542848 543241 543788 544677 544682 580240 543165 543510 544702 705121 687608 687525 687564 613444 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (2.07%) |
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 539873 541182 542366 542826 542839 542848 543017 543025 543061 543081 543153 543160 543165 543222 543241 543267 543273 543479 543508 543510 543788 543803 544377 544677 544682 544702 544787 549151 549998 550059 550247 550690 554359 556957 557424 557455 557464 561452 562355 566566 569837 574969 575021 575024 575027 575046 575409 577115 580240 581747 586497 590182 605559 613444 622926 626794 629375 630594 632307 634927 635181 635183 640483 643975 650676 650705 664463 670220 682099 687522 687525 687560 687564 687608 688267 705121 706602 710356 711658 712336 713258 714427 718168 748055 748084 748094 750273 751192 752167 752455 773840 775110 789501 789644 789965 791789 810368 813738 818933 824878 825218 825338 825342 825370 825408 825446 825727 825835 825942 825970 826011 826062 826174 826438 826892 827885 828107 828329 828398 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб девушк"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab girl"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.15%) |
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.