Query Metrics
7
Database Queries
7
Different statements
366.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
235.48 ms (64.18%) |
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 419949 445830 485613 525543 528582 386304 443510 459759 516336 405940 418873 425668 443215 421288 451875 476975 532020 503855 515796 675107 407277 468809 471926 416263 427794 518263 507627 405507 478995 521151 521525 523629 560902 667826 411930 500798 494731 428458 510448 383354 448006 445838 723914 438830 506304 424505 478900 540238 508221 518188 461651 675725 382330 416165 475483 590280 488536 421548 498990 544824 542601 404779 404451 420462 454468 520788 675110 447173 419298 499098 518076 521850 464453 441466 445935 476783 510839 788260 514149 519752 411884 538732 396527 520662 559949 519942 540609 434702 470903 583960 445087 463829 542627 499585 814072 430712 828851 584740 602606 701817 699191 185159 542584 712891 521852 780247 675126 509001 513195 688108 515896 542676 465349 482668 493535 599299 428521 468715 815906 530588 ] |
||||||||||||||||||||||||||||||
|
122.01 ms (33.25%) |
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 185159 382330 383354 386304 396527 404451 404779 405507 405940 407277 411884 411930 416165 416263 418873 419298 419949 420462 421288 421548 424505 425668 427794 428458 428521 430712 434702 438830 441466 443215 443510 445087 445830 445838 445935 447173 448006 451875 454468 459759 461651 463829 464453 465349 468715 468809 470903 471926 475483 476783 476975 478900 478995 482668 485613 488536 493535 494731 498990 499098 499585 500798 503855 506304 507627 508221 509001 510448 510839 513195 514149 515796 515896 516336 518076 518188 518263 519752 519942 520662 520788 521151 521525 521850 521852 523629 525543 528582 530588 532020 538732 540238 540609 542584 542601 542627 542676 544824 559949 560902 583960 584740 590280 599299 602606 667826 675107 675110 675126 675725 688108 699191 701817 712891 723914 780247 788260 814072 815906 828851 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (0.82%) |
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 185159 382330 383354 386304 396527 404451 404779 405507 405940 407277 411884 411930 416165 416263 418873 419298 419949 420462 421288 421548 424505 425668 427794 428458 428521 430712 434702 438830 441466 443215 443510 445087 445830 445838 445935 447173 448006 451875 454468 459759 461651 463829 464453 465349 468715 468809 470903 471926 475483 476783 476975 478900 478995 482668 485613 488536 493535 494731 498990 499098 499585 500798 503855 506304 507627 508221 509001 510448 510839 513195 514149 515796 515896 516336 518076 518188 518263 519752 519942 520662 520788 521151 521525 521850 521852 523629 525543 528582 530588 532020 538732 540238 540609 542584 542601 542627 542676 544824 559949 560902 583960 584740 590280 599299 602606 667826 675107 675110 675126 675725 688108 699191 701817 712891 723914 780247 788260 814072 815906 828851 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс white"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex white"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс white"
]
|
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.