Query Metrics
7
Database Queries
7
Different statements
464.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.05 ms (47.55%) |
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 33602 78786 96690 150507 188507 338731 338807 342450 384420 384803 386198 388519 389406 389476 392956 394751 395144 395145 397781 399688 399697 403577 404451 405507 405535 405553 407277 407654 409641 411805 416165 418865 424895 426249 428922 430701 432813 445935 448368 449868 453194 453305 453373 464430 464453 468845 469599 472263 472688 481907 482780 483573 483579 486449 497899 515643 518587 519184 524856 528443 532174 534274 534316 535014 539112 540530 541206 543867 544203 545624 548568 555147 557072 578204 581231 584693 595731 598194 602955 603398 604480 604905 606473 607459 614305 627341 629279 630711 632668 643767 656117 667842 681609 695621 719961 719968 720003 725451 726258 727744 729890 735942 743066 743822 744349 750246 755222 763396 786454 788260 788920 792804 792805 804681 805115 806268 814991 815304 815847 825039 ] |
||||||||||||||||||||||||||||||
|
218.07 ms (46.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white mature межрасов"
]
|
||||||||||||||||||||||||||||||
|
16.41 ms (3.53%) |
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 338807 719968 399697 392956 681609 150507 464430 540530 555147 726258 744349 395145 595731 407277 342450 338731 33602 630711 792805 805115 627341 719961 629279 792804 472688 695621 606473 188507 394751 581231 428922 388519 483573 763396 755222 804681 472263 814991 386198 407654 643767 743066 750246 604480 825039 486449 482780 468845 399688 464453 432813 389406 404451 409641 578204 397781 453194 607459 729890 743822 534316 449868 469599 448368 524856 557072 430701 405535 78786 389476 405553 453373 548568 584693 656117 667842 604905 614305 806268 735942 384803 411805 405507 445935 788260 497899 528443 519184 535014 384420 426249 424895 815304 815847 518587 539112 532174 483579 544203 545624 543867 720003 598194 602955 603398 725451 786454 788920 727744 632668 403577 418865 515643 416165 541206 395144 481907 534274 96690 453305 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (0.75%) |
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 33602 78786 96690 150507 188507 338731 338807 342450 384420 384803 386198 388519 389406 389476 392956 394751 395144 395145 397781 399688 399697 403577 404451 405507 405535 405553 407277 407654 409641 411805 416165 418865 424895 426249 428922 430701 432813 445935 448368 449868 453194 453305 453373 464430 464453 468845 469599 472263 472688 481907 482780 483573 483579 486449 497899 515643 518587 519184 524856 528443 532174 534274 534316 535014 539112 540530 541206 543867 544203 545624 548568 555147 557072 578204 581231 584693 595731 598194 602955 603398 604480 604905 606473 607459 614305 627341 629279 630711 632668 643767 656117 667842 681609 695621 719961 719968 720003 725451 726258 727744 729890 735942 743066 743822 744349 750246 755222 763396 786454 788260 788920 792804 792805 804681 805115 806268 814991 815304 815847 825039 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white mature межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white mature interracial"
]
|
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.