Query Metrics
7
Database Queries
7
Different statements
153.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.02 ms (84.80%) |
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 187704 191312 206145 233532 310706 384315 390760 398402 411834 424146 424757 462964 464803 475280 486365 510165 522422 522625 527739 531554 531928 537650 540512 544706 550189 563015 563114 566265 566879 575553 589329 597106 603005 605510 616778 624465 631134 632982 641346 646889 652532 655295 668978 670946 671681 698983 699370 714644 714707 716612 718162 718767 720626 721632 721734 725216 727653 728517 730743 733443 734103 734190 738508 740552 745341 755120 758630 759914 763524 763938 764716 766265 769897 772552 773993 774384 774785 779177 782918 788282 789532 791332 793585 794019 794186 794485 795885 796451 796937 797342 798706 801048 801304 801756 804414 805106 805385 808200 809246 811555 811819 813539 813782 815569 815874 816089 816160 816459 817371 817473 818766 818865 820061 824156 824160 824641 824988 825303 827121 828175 ] |
||||||||||||||||||||||||||||||
|
13.38 ms (8.73%) |
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 788282 766265 774384 818766 824641 824988 825303 827121 522625 537650 531928 566879 631134 794485 804414 725216 730743 733443 734190 794186 734103 763938 632982 795885 540512 206145 809246 718767 616778 310706 462964 510165 522422 563015 655295 714707 575553 603005 769897 740552 728517 721632 233532 411834 820061 550189 789532 813539 191312 475280 714644 774785 699370 384315 816089 815569 816459 824160 531554 464803 668978 670946 718162 721734 597106 624465 589329 782918 796937 797342 801756 805106 811819 764716 801304 758630 763524 720626 641346 828175 773993 390760 424757 424146 817371 486365 563114 671681 698983 605510 794019 727653 759914 738508 772552 745341 187704 527739 398402 813782 816160 544706 716612 779177 793585 811555 818865 817473 815874 824156 652532 646889 566265 808200 791332 798706 755120 796451 801048 805385 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.86%) |
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 187704 191312 206145 233532 310706 384315 390760 398402 411834 424146 424757 462964 464803 475280 486365 510165 522422 522625 527739 531554 531928 537650 540512 544706 550189 563015 563114 566265 566879 575553 589329 597106 603005 605510 616778 624465 631134 632982 641346 646889 652532 655295 668978 670946 671681 698983 699370 714644 714707 716612 718162 718767 720626 721632 721734 725216 727653 728517 730743 733443 734103 734190 738508 740552 745341 755120 758630 759914 763524 763938 764716 766265 769897 772552 773993 774384 774785 779177 782918 788282 789532 791332 793585 794019 794186 794485 795885 796451 796937 797342 798706 801048 801304 801756 804414 805106 805385 808200 809246 811555 811819 813539 813782 815569 815874 816089 816160 816459 817371 817473 818766 818865 820061 824156 824160 824641 824988 825303 827121 828175 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot milf sex"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot milf секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot milf секс"
]
|
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.