Query Metrics
7
Database Queries
7
Different statements
146.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.55 ms (82.13%) |
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 14477 143572 187840 187953 311235 379595 382971 385606 386142 393056 393431 395137 401130 407802 411717 413302 451719 452008 452157 453148 453269 454204 454430 454437 456614 460186 460925 463841 464420 466278 469321 470966 472657 473249 474861 476252 477717 479056 479109 482541 484437 484629 484651 485731 489938 493835 497391 499883 505673 516469 517012 527750 534285 534303 536451 554515 556916 558898 559851 562985 565724 590331 591133 598112 598988 605008 607385 610087 620256 645937 660865 663375 663957 665110 665890 667207 674681 702158 705640 710587 714142 714153 714156 716077 720627 721570 721693 726588 726955 728119 728240 728443 729178 731686 735863 738070 739709 740882 741653 741904 744386 744475 746890 757641 759761 768049 770120 770866 777250 788742 788981 794629 796032 797220 808866 817536 817650 818949 823909 825455 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (10.99%) |
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 665890 710587 702158 714142 714156 716077 605008 598988 620256 777250 740882 744475 746890 726588 728240 731686 735863 741904 726955 741653 759761 728443 714153 187840 311235 456614 499883 479109 484629 484651 453269 497391 818949 817536 817650 823909 825455 660865 721570 721693 667207 591133 598112 797220 788742 794629 808866 728119 770866 768049 770120 757641 788981 796032 379595 14477 453148 663375 663957 729178 739709 744386 738070 143572 393431 385606 413302 451719 472657 559851 554515 556916 590331 705640 386142 382971 187953 393056 395137 401130 407802 411717 482541 452157 454437 469321 476252 454204 460186 463841 464420 466278 470966 484437 485731 452008 454430 474861 489938 536451 505673 516469 517012 534285 527750 534303 460925 477717 479056 493835 562985 565724 645937 665110 720627 674681 558898 610087 607385 473249 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.72%) |
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 14477 143572 187840 187953 311235 379595 382971 385606 386142 393056 393431 395137 401130 407802 411717 413302 451719 452008 452157 453148 453269 454204 454430 454437 456614 460186 460925 463841 464420 466278 469321 470966 472657 473249 474861 476252 477717 479056 479109 482541 484437 484629 484651 485731 489938 493835 497391 499883 505673 516469 517012 527750 534285 534303 536451 554515 556916 558898 559851 562985 565724 590331 591133 598112 598988 605008 607385 610087 620256 645937 660865 663375 663957 665110 665890 667207 674681 702158 705640 710587 714142 714153 714156 716077 720627 721570 721693 726588 726955 728119 728240 728443 729178 731686 735863 738070 739709 740882 741653 741904 744386 744475 746890 757641 759761 768049 770120 770866 777250 788742 788981 794629 796032 797220 808866 817536 817650 818949 823909 825455 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член mature"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick mature"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член mature"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.