Query Metrics
7
Database Queries
7
Different statements
138.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.37 ms (84.71%) |
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 37730 65281 281927 367863 387143 388937 390233 393406 393980 396887 441241 457155 461127 476562 496632 503881 526012 548327 561414 562997 588271 612395 612578 627125 630637 641366 647331 653136 663478 692824 710784 710934 714611 716805 717509 718938 720349 722841 723487 726365 726861 728340 729127 733136 733913 734508 737135 739177 740296 741802 742152 742973 748983 752072 755246 756747 757629 765301 766698 767928 768829 771994 772799 772882 773615 773967 775100 776279 778482 778978 779638 783571 785191 785735 786424 786636 786804 786875 787167 787658 792832 793576 795435 795766 797337 799953 800120 800252 801358 801803 805385 805624 805748 811759 813323 813524 814943 815308 815807 816020 816773 817324 817547 818182 818269 818422 819407 821030 822991 824249 824444 824472 824740 824849 825210 825247 825423 826070 826652 827377 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (8.15%) |
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 281927 627125 756747 388937 797337 816773 815807 692824 733913 773967 783571 795766 393406 792832 785735 786424 786804 799953 805748 65281 766698 785191 720349 815308 822991 817547 526012 503881 496632 548327 718938 641366 786636 811759 726365 765301 752072 612578 778978 778482 393980 387143 821030 825210 824444 714611 647331 663478 716805 775100 801358 801803 795435 813524 733136 773615 786875 771994 793576 396887 827377 826652 723487 722841 800120 800252 805385 726861 390233 710934 776279 37730 561414 826070 767928 816020 476562 461127 612395 772882 740296 441241 457155 630637 787658 367863 818422 768829 717509 818269 825423 814943 818182 819407 824249 824849 817324 824472 824740 825247 562997 653136 710784 588271 787167 779638 805624 813323 734508 737135 742973 742152 728340 739177 757629 729127 741802 748983 755246 772799 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.93%) |
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 37730 65281 281927 367863 387143 388937 390233 393406 393980 396887 441241 457155 461127 476562 496632 503881 526012 548327 561414 562997 588271 612395 612578 627125 630637 641366 647331 653136 663478 692824 710784 710934 714611 716805 717509 718938 720349 722841 723487 726365 726861 728340 729127 733136 733913 734508 737135 739177 740296 741802 742152 742973 748983 752072 755246 756747 757629 765301 766698 767928 768829 771994 772799 772882 773615 773967 775100 776279 778482 778978 779638 783571 785191 785735 786424 786636 786804 786875 787167 787658 792832 793576 795435 795766 797337 799953 800120 800252 801358 801803 805385 805624 805748 811759 813323 813524 814943 815308 815807 816020 816773 817324 817547 818182 818269 818422 819407 821030 822991 824249 824444 824472 824740 824849 825210 825247 825423 826070 826652 827377 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.08%) |
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.