Query Metrics
7
Database Queries
7
Different statements
606.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.22 ms (37.78%) |
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 736131 740504 763546 622841 625539 631059 631280 632930 703291 710355 716992 717122 722052 585735 474806 502849 463239 487205 540403 495130 514444 509054 523486 762199 701935 405048 486000 484024 673187 658869 694565 681961 715800 609107 596944 620938 642996 730641 768227 714855 493168 687248 404314 443371 486643 483353 414129 453381 469170 475653 459073 461867 527406 535626 506533 483132 715156 490157 517835 553443 682976 673880 748725 758668 708533 435701 538070 541011 712374 661991 635578 793075 737632 747563 108018 646999 652278 692817 738245 470616 456405 508648 512488 499735 822645 490976 487987 494848 523007 525867 535865 515381 768790 471662 481238 470810 526393 816568 446703 514608 520848 528848 515337 475542 541139 745078 457146 461526 520799 511187 523302 501293 816052 822300 700452 695307 723123 654256 690052 560182 ] |
||||||||||||||||||||||||||||||
|
215.66 ms (35.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большой большие член"
]
|
||||||||||||||||||||||||||||||
|
154.58 ms (25.48%) |
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 108018 404314 405048 414129 435701 443371 446703 453381 456405 457146 459073 461526 461867 463239 469170 470616 470810 471662 474806 475542 475653 481238 483132 483353 484024 486000 486643 487205 487987 490157 490976 493168 494848 495130 499735 501293 502849 506533 508648 509054 511187 512488 514444 514608 515337 515381 517835 520799 520848 523007 523302 523486 525867 526393 527406 528848 535626 535865 538070 540403 541011 541139 553443 560182 585735 596944 609107 620938 622841 625539 631059 631280 632930 635578 642996 646999 652278 654256 658869 661991 673187 673880 681961 682976 687248 690052 692817 694565 695307 700452 701935 703291 708533 710355 712374 714855 715156 715800 716992 717122 722052 723123 730641 736131 737632 738245 740504 745078 747563 748725 758668 762199 763546 768227 768790 793075 816052 816568 822300 822645 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.38%) |
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 108018 404314 405048 414129 435701 443371 446703 453381 456405 457146 459073 461526 461867 463239 469170 470616 470810 471662 474806 475542 475653 481238 483132 483353 484024 486000 486643 487205 487987 490157 490976 493168 494848 495130 499735 501293 502849 506533 508648 509054 511187 512488 514444 514608 515337 515381 517835 520799 520848 523007 523302 523486 525867 526393 527406 528848 535626 535865 538070 540403 541011 541139 553443 560182 585735 596944 609107 620938 622841 625539 631059 631280 632930 635578 642996 646999 652278 654256 658869 661991 673187 673880 681961 682976 687248 690052 692817 694565 695307 700452 701935 703291 708533 710355 712374 714855 715156 715800 716992 717122 722052 723123 730641 736131 737632 738245 740504 745078 747563 748725 758668 762199 763546 768227 768790 793075 816052 816568 822300 822645 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big dick"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большой большие член"
]
|
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.