Query Metrics
7
Database Queries
7
Different statements
183.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.17 ms (84.62%) |
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 392054 395739 397880 401616 409312 413908 421847 421859 421918 421954 422141 422196 427536 433347 433605 437310 439648 439652 439678 439698 439707 439763 440916 440979 443727 443832 446204 449897 453702 457686 458714 459893 462489 463691 465236 469473 479038 485460 488118 493166 493174 493179 493183 495223 495225 495227 500796 502813 506055 511016 513362 513495 514122 516226 517003 517282 518046 518159 519426 519436 519735 519934 520811 521129 521137 521220 521759 521796 521997 522168 523018 523323 523827 523848 523902 524339 524486 524778 524781 525878 526527 526937 527181 529157 529170 529376 531998 533425 537126 538001 538002 538005 538010 538970 543773 548489 549821 549822 549842 549848 550221 557541 561510 563155 565982 566013 571708 575704 579848 580038 588422 603678 607075 619717 659986 720258 725407 748210 748236 810970 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (8.95%) |
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 518046 519934 521129 521137 521796 526937 493179 513362 517003 521997 523018 523902 524339 524778 488118 520811 521220 526527 518159 401616 433605 409312 437310 453702 458714 479038 446204 457686 459893 469473 465236 531998 537126 511016 517282 519436 533425 561510 565982 543773 550221 563155 575704 659986 720258 549842 579848 603678 748210 748236 619717 439652 443727 443832 462489 433347 439648 439698 439707 440979 392054 397880 413908 421847 421918 422141 422196 427536 439763 440916 449897 506055 529157 538005 538970 493183 514122 519426 519735 524781 525878 529170 538002 485460 493166 493174 495223 500796 502813 513495 523323 523848 529376 495225 495227 522168 523827 524486 527181 538010 395739 463691 571708 566013 557541 548489 588422 607075 810970 725407 521759 549848 580038 439678 421954 421859 538001 516226 549821 549822 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (2.48%) |
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 392054 395739 397880 401616 409312 413908 421847 421859 421918 421954 422141 422196 427536 433347 433605 437310 439648 439652 439678 439698 439707 439763 440916 440979 443727 443832 446204 449897 453702 457686 458714 459893 462489 463691 465236 469473 479038 485460 488118 493166 493174 493179 493183 495223 495225 495227 500796 502813 506055 511016 513362 513495 514122 516226 517003 517282 518046 518159 519426 519436 519735 519934 520811 521129 521137 521220 521759 521796 521997 522168 523018 523323 523827 523848 523902 524339 524486 524778 524781 525878 526527 526937 527181 529157 529170 529376 531998 533425 537126 538001 538002 538005 538010 538970 543773 548489 549821 549822 549842 549848 550221 557541 561510 563155 565982 566013 571708 575704 579848 580038 588422 603678 607075 619717 659986 720258 725407 748210 748236 810970 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son ass"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son жоп"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son жоп"
]
|
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.