Query Metrics
7
Database Queries
7
Different statements
177.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.52 ms (87.27%) |
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 188263 383584 384540 388421 389281 389290 389788 395291 401146 401465 403397 411169 414667 414708 419170 422734 423620 425155 432306 435177 439187 440414 441567 443369 443496 443988 444156 445930 447522 453831 454105 455083 457857 457904 461011 463743 463837 464234 464348 464878 465865 467912 468345 472269 474743 476981 478091 479856 493488 493673 495228 501541 505441 508962 510180 516332 517314 521868 523843 524241 524497 525067 526009 531757 537476 544426 552697 554083 558490 564162 564555 567311 570722 571726 572960 577520 582805 596204 600642 604939 623195 627772 634546 641413 656597 668710 671658 674815 675276 679656 697634 713206 715773 717244 720076 720122 726665 726847 727732 734336 734623 742304 742547 745959 750307 751670 761066 761163 770260 786512 792171 792173 795403 799351 800425 800631 805254 809906 811906 818924 ] |
||||||||||||||||||||||||||||||
|
13.95 ms (7.88%) |
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 558490 411169 474743 188263 478091 501541 384540 383584 401146 403397 818924 468345 531757 537476 675276 627772 800631 422734 510180 567311 679656 641413 476981 423620 388421 463743 570722 761163 479856 571726 634546 552697 425155 439187 493488 457904 455083 526009 795403 799351 786512 726847 770260 742547 761066 792171 809906 443988 447522 623195 414667 440414 441567 419170 443496 464878 493673 472269 505441 464234 465865 467912 544426 554083 582805 671658 674815 720122 717244 720076 596204 792173 800425 805254 811906 727732 726665 751670 734336 742304 713206 453831 443369 461011 389281 435177 457857 444156 454105 517314 523843 524241 521868 525067 734623 389788 572960 656597 745959 750307 715773 564555 668710 604939 414708 445930 697634 389290 464348 524497 508962 577520 600642 432306 401465 495228 395291 516332 463837 564162 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.26%) |
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 188263 383584 384540 388421 389281 389290 389788 395291 401146 401465 403397 411169 414667 414708 419170 422734 423620 425155 432306 435177 439187 440414 441567 443369 443496 443988 444156 445930 447522 453831 454105 455083 457857 457904 461011 463743 463837 464234 464348 464878 465865 467912 468345 472269 474743 476981 478091 479856 493488 493673 495228 501541 505441 508962 510180 516332 517314 521868 523843 524241 524497 525067 526009 531757 537476 544426 552697 554083 558490 564162 564555 567311 570722 571726 572960 577520 582805 596204 600642 604939 623195 627772 634546 641413 656597 668710 671658 674815 675276 679656 697634 713206 715773 717244 720076 720122 726665 726847 727732 734336 734623 742304 742547 745959 750307 751670 761066 761163 770260 786512 792171 792173 795403 799351 800425 800631 805254 809906 811906 818924 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal ass"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал жоп"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
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.