Query Metrics
7
Database Queries
7
Different statements
153.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.88 ms (84.17%) |
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 29610 30841 46656 145603 210619 385783 386938 395949 397249 403872 403890 408678 408887 413116 417610 430988 434926 438848 438957 440642 442651 452995 454789 454899 457863 460237 466468 466925 468290 468291 468785 469956 479871 483743 491187 493827 514217 519352 519361 524658 527564 533121 533128 534635 535140 541504 548026 550030 553592 553604 556744 557446 558893 561168 565801 566564 566589 570890 570942 574076 579259 580490 580998 584363 591029 591522 595590 599343 599407 604793 608296 609721 610748 617775 620178 627790 632885 650937 652357 666419 671189 672229 672301 672310 677428 690726 709844 713190 713372 719647 732918 740261 740262 743160 751203 751376 751553 757188 763815 768607 768832 775657 782780 786812 786977 790128 790436 790616 795021 796927 800745 804350 804407 804408 805864 807877 812221 812243 812528 819186 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (9.66%) |
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 800745 804350 804408 751376 757188 768832 782780 790128 790616 812221 812243 740262 768607 732918 740261 743160 751203 751553 763815 608296 775657 786812 786977 790436 795021 796927 804407 805864 807877 812528 468785 46656 434926 442651 29610 210619 397249 527564 574076 430988 386938 438957 469956 519361 385783 145603 395949 30841 403872 403890 408887 417610 408678 413116 438848 440642 819186 452995 454899 457863 466468 466925 491187 479871 454789 493827 519352 534635 533121 535140 514217 524658 533128 460237 468290 468291 483743 557446 580490 566589 570890 584363 541504 548026 566564 570942 579259 652357 671189 672301 672310 713372 650937 666419 690726 709844 713190 672229 677428 719647 550030 553592 553604 556744 558893 561168 565801 580998 599407 610748 632885 609721 591029 599343 604793 627790 591522 595590 617775 620178 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.66%) |
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 29610 30841 46656 145603 210619 385783 386938 395949 397249 403872 403890 408678 408887 413116 417610 430988 434926 438848 438957 440642 442651 452995 454789 454899 457863 460237 466468 466925 468290 468291 468785 469956 479871 483743 491187 493827 514217 519352 519361 524658 527564 533121 533128 534635 535140 541504 548026 550030 553592 553604 556744 557446 558893 561168 565801 566564 566589 570890 570942 574076 579259 580490 580998 584363 591029 591522 595590 599343 599407 604793 608296 609721 610748 617775 620178 627790 632885 650937 652357 666419 671189 672229 672301 672310 677428 690726 709844 713190 713372 719647 732918 740261 740262 743160 751203 751376 751553 757188 763815 768607 768832 775657 782780 786812 786977 790128 790436 790616 795021 796927 800745 804350 804407 804408 805864 807877 812221 812243 812528 819186 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло голых"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло голые"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.97%) |
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.