Query Metrics
7
Database Queries
7
Different statements
175.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.11 ms (86.88%) |
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 188293 401865 440770 486059 495813 527232 534632 534636 542206 551891 553146 553439 557174 564279 564812 565142 582531 586570 588562 590261 602355 603425 607435 608432 610118 612995 614214 625907 629768 632989 637801 638485 641683 645933 664498 694153 694568 695398 699011 700385 700868 710339 710416 713614 714133 714324 716160 719896 721751 721808 723029 724685 724688 727465 729003 729330 731136 731292 733334 734501 738236 738432 741077 742747 747251 748618 749592 754153 755420 759623 759730 761021 763859 766600 769230 771358 771380 777197 779793 780158 782636 787495 788374 793616 794057 795144 796010 796172 796597 798209 799626 800056 800348 800840 801309 801327 803289 804536 805357 805957 807417 808608 813693 814114 817315 817353 818429 818434 819332 819719 820131 820339 821773 821916 823860 825070 826017 826211 827316 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (7.40%) |
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 486059 564812 694153 695398 700868 714133 590261 614214 608432 629768 779793 780158 787495 799626 801309 805357 807417 734501 788374 796010 796172 801327 804536 738236 759623 729003 769230 771358 738432 763859 755420 761021 632989 710339 719896 782636 796597 188293 401865 534632 527232 641683 495813 534636 645933 664498 714324 565142 766600 820339 793616 741077 586570 727465 742747 602355 440770 582531 814114 817353 818429 818434 826017 826023 826211 820131 827316 813693 821773 817315 819332 819719 821916 823860 825070 557174 553439 542206 700385 713614 694568 716160 721751 723029 551891 553146 564279 588562 603425 607435 612995 637801 625907 638485 777197 800348 808608 800840 805957 731292 733334 749592 754153 794057 798209 800056 724688 724685 747251 748618 729330 759730 771380 731136 610118 699011 710416 721808 795144 803289 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.59%) |
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 188293 401865 440770 486059 495813 527232 534632 534636 542206 551891 553146 553439 557174 564279 564812 565142 582531 586570 588562 590261 602355 603425 607435 608432 610118 612995 614214 625907 629768 632989 637801 638485 641683 645933 664498 694153 694568 695398 699011 700385 700868 710339 710416 713614 714133 714324 716160 719896 721751 721808 723029 724685 724688 727465 729003 729330 731136 731292 733334 734501 738236 738432 741077 742747 747251 748618 749592 754153 755420 759623 759730 761021 763859 766600 769230 771358 771380 777197 779793 780158 782636 787495 788374 793616 794057 795144 796010 796172 796597 798209 799626 800056 800348 800840 801309 801327 803289 804536 805357 805957 807417 808608 813693 814114 817315 817353 818429 818434 819332 819719 820131 820339 821773 821916 823860 825070 826017 826211 827316 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс milf"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"but fuck milf"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс milf"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
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.