Query Metrics
7
Database Queries
7
Different statements
382.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
357.16 ms (93.30%) |
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 330102 365901 382385 385308 409895 411697 425475 460440 486401 493561 526681 534710 548499 549723 551024 554348 555562 565228 569187 576718 588942 612273 624462 625451 649634 665076 669860 679708 693295 693683 693991 698920 701733 717037 718328 718606 722113 722151 724662 724770 726110 726660 726845 726926 726989 728810 729121 738178 740976 741142 747515 748427 748477 758913 759796 760851 761579 764456 765308 767095 768730 770054 771424 771773 773380 773469 774511 779220 779793 780559 780968 781690 785901 787101 787419 789474 791412 791414 793371 795680 796001 796597 797143 798271 800112 800416 800509 800968 801309 801932 803176 803699 806139 808316 809931 811482 813832 817873 819413 819852 820149 823149 823546 823748 824509 824825 824910 825453 825847 825924 826792 826860 827490 828088 828106 828493 828535 828805 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (3.94%) |
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 569187 774511 791414 797143 798271 726660 728810 717037 747515 486401 701733 796001 726926 764456 759796 740976 612273 809931 828106 828493 748477 760851 823748 824509 827490 679708 800509 795680 780968 409895 826792 385308 493561 555562 625451 785901 800968 793371 758913 808316 771773 722151 549723 649634 823149 548499 811482 365901 382385 820149 828805 565228 741142 773469 773380 693295 762279 803176 576718 824825 825453 779793 801309 796597 188293 824910 823546 738178 819413 779220 722113 825924 819852 693683 698920 588942 789474 787101 787419 765308 748427 791412 411697 800112 526681 460440 803699 761579 767095 770054 726110 726989 806139 425475 817873 828088 551024 718606 624462 724770 729121 330102 813832 825847 826860 828535 534710 554348 665076 669860 693991 718328 780559 800416 801932 771424 781690 724662 768730 726845 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (0.78%) |
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 330102 365901 382385 385308 409895 411697 425475 460440 486401 493561 526681 534710 548499 549723 551024 554348 555562 565228 569187 576718 588942 612273 624462 625451 649634 665076 669860 679708 693295 693683 693991 698920 701733 717037 718328 718606 722113 722151 724662 724770 726110 726660 726845 726926 726989 728810 729121 738178 740976 741142 747515 748427 748477 758913 759796 760851 761579 764456 765308 767095 768730 770054 771424 771773 773380 773469 774511 779220 779793 780559 780968 781690 785901 787101 787419 789474 791412 791414 793371 795680 796001 796597 797143 798271 800112 800416 800509 800968 801309 801932 803176 803699 806139 808316 809931 811482 813832 817873 819413 819852 820149 823149 823546 823748 824509 824825 824910 825453 825847 825924 826792 826860 827490 828088 828106 828493 828535 828805 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf hot секс"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf hot sex"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf hot секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.45%) |
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.