Query Metrics
7
Database Queries
7
Different statements
145.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.73 ms (84.28%) |
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 417941 418279 419361 425588 431731 449468 458275 460066 462061 477193 478979 480251 490437 493431 496793 507915 513558 516226 521647 525041 539655 540612 543592 547608 547681 552385 553309 553701 556757 557607 560678 561214 561232 562020 562528 563382 569699 577396 578937 583105 583447 584161 584722 585024 585737 614693 645006 648017 648042 649818 650464 651338 653809 657118 660098 666402 673457 674101 687140 688761 692118 695693 697763 698855 699064 703327 709691 710164 710919 715601 716604 718594 719211 719740 721256 722165 795090 795908 797380 799056 802067 802618 803253 807237 810216 813313 813910 814204 814205 814325 816109 816156 816681 817359 817736 817953 819111 819292 819312 819800 819918 820130 820192 820379 823375 824160 824284 824293 824542 824816 825008 825472 825485 825607 825676 826319 827332 828771 828835 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (9.05%) |
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 795090 795908 797380 799056 802618 803253 807237 810216 813313 584722 419361 425588 645006 460066 449468 493431 507915 516226 540612 543592 577396 585737 614693 802067 431731 417941 477193 521647 513558 496793 698855 478979 687140 418279 813910 814205 816109 817359 817953 819918 820130 824542 825485 585024 816681 817736 820192 824816 825008 825607 827332 816149 819111 820379 824293 825472 826319 814204 814325 816156 819292 819312 819800 823375 824160 824284 825676 828771 828835 480251 458275 490437 525041 539655 462061 547608 552385 553309 553701 560678 563382 584161 547681 556757 557607 561214 561232 562020 562528 569699 578937 583105 583447 650464 651338 653809 660098 674101 697763 699064 703327 719740 721256 722165 648042 649818 666402 673457 692118 695693 710164 710919 715601 716604 718594 719211 648017 657118 688761 709691 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.90%) |
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 417941 418279 419361 425588 431731 449468 458275 460066 462061 477193 478979 480251 490437 493431 496793 507915 513558 516226 521647 525041 539655 540612 543592 547608 547681 552385 553309 553701 556757 557607 560678 561214 561232 562020 562528 563382 569699 577396 578937 583105 583447 584161 584722 585024 585737 614693 645006 648017 648042 649818 650464 651338 653809 657118 660098 666402 673457 674101 687140 688761 692118 695693 697763 698855 699064 703327 709691 710164 710919 715601 716604 718594 719211 719740 721256 722165 795090 795908 797380 799056 802067 802618 803253 807237 810216 813313 813910 814204 814205 814325 816109 816156 816681 817359 817736 817953 819111 819292 819312 819800 819918 820130 820192 820379 823375 824160 824284 824293 824542 824816 825008 825472 825485 825607 825676 826319 827332 828771 828835 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair long cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair длинные cum"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair длинные cum"
]
|
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.