Query Metrics
7
Database Queries
7
Different statements
180.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.69 ms (86.93%) |
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 7456 181422 187542 392971 428062 440469 440911 468351 484243 498629 507779 508807 511572 513663 516226 537667 544748 555170 564391 574656 591333 592161 593604 599572 606767 620247 623380 624209 625686 636955 642407 643373 646289 660414 669195 672041 674770 680259 680346 689359 692423 695380 702621 703542 705449 707309 715904 719245 720788 720812 724021 726776 726888 726934 726978 727503 728261 731349 731389 731898 734386 734436 743806 746454 749330 750127 750246 752611 757180 758077 759806 760932 761719 765819 769726 772717 773912 777028 777737 783778 785092 786199 787614 789107 790978 794359 794366 796148 796193 797163 798801 800336 800636 801249 801294 801300 801306 805651 805979 806195 809659 809898 810301 811332 813005 813590 815704 815951 818167 818169 818959 819020 820197 821434 823922 824679 825420 826242 827514 828539 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (7.26%) |
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 468351 760932 801300 749330 797163 680259 695380 707309 672041 674770 692423 703542 720788 624209 636955 599572 777737 789107 796193 798801 800636 801294 806195 811332 801306 805979 724021 726888 727503 800336 809659 726776 750127 726978 728261 734436 765819 761719 773912 752611 759806 783778 794359 805651 810301 646289 440469 516226 702621 825420 813590 823922 815951 818167 484243 507779 513663 544748 555170 574656 669195 705449 620247 643373 787614 801249 809898 734386 758077 796148 726934 731389 746454 769726 731898 743806 772717 750246 785092 818169 181422 187542 392971 7456 815704 826242 819020 818959 820197 824679 828539 794366 606767 719245 790978 508807 591333 593604 625686 440911 642407 715904 827514 731349 680346 720812 777028 592161 813005 786199 757180 623380 428062 821434 537667 498629 511572 564391 660414 689359 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.10%) |
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 7456 181422 187542 392971 428062 440469 440911 468351 484243 498629 507779 508807 511572 513663 516226 537667 544748 555170 564391 574656 591333 592161 593604 599572 606767 620247 623380 624209 625686 636955 642407 643373 646289 660414 669195 672041 674770 680259 680346 689359 692423 695380 702621 703542 705449 707309 715904 719245 720788 720812 724021 726776 726888 726934 726978 727503 728261 731349 731389 731898 734386 734436 743806 746454 749330 750127 750246 752611 757180 758077 759806 760932 761719 765819 769726 772717 773912 777028 777737 783778 785092 786199 787614 789107 790978 794359 794366 796148 796193 797163 798801 800336 800636 801249 801294 801300 801306 805651 805979 806195 809659 809898 810301 811332 813005 813590 815704 815951 818167 818169 818959 819020 820197 821434 823922 824679 825420 826242 827514 828539 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair 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.