Query Metrics
7
Database Queries
7
Different statements
189.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.65 ms (85.82%) |
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 233102 386719 404209 422233 425003 426818 432404 447357 451748 456179 476397 481166 482079 484355 489958 490184 498867 500120 506629 513540 516039 517663 518091 519848 521915 525208 548601 551553 552232 554764 561356 561667 561686 574328 575797 575823 576285 578843 599451 600403 605961 612574 613850 614729 618943 623834 652855 652901 653238 653260 653561 654151 654390 655418 660959 669858 672511 672534 675359 676491 676499 676517 676538 676953 677039 679706 695051 699571 701487 706668 709372 709769 710998 716033 718967 720822 722799 722889 722901 726398 728171 728681 735410 736260 738432 738889 738910 740587 741596 743079 744507 745682 746207 750922 755587 758033 760919 760942 763953 764137 764158 765261 766115 768163 770438 772991 773187 781583 782524 789240 789450 789753 799726 799727 800587 808761 809802 813880 824806 825715 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (8.14%) |
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 612574 768163 726398 764137 741596 740587 554764 613850 525208 660959 675359 718967 755587 386719 552232 701487 677039 422233 519848 600403 425003 716033 578843 655418 561667 799726 781583 728681 782524 451748 506629 484355 736260 654390 498867 676499 706668 709769 808761 738432 517663 521915 561356 575797 722889 482079 750922 679706 809802 561686 513540 653260 669858 789450 789240 764158 770438 490184 676953 605961 789753 722901 722799 432404 618943 672534 735410 744507 825715 654151 699571 760919 447357 476397 233102 404209 824806 813880 710998 773187 728171 746207 758033 765261 709372 548601 426818 575823 766115 599451 456179 516039 574328 672511 653561 738889 763953 743079 800587 695051 653238 623834 500120 614729 720822 799727 745682 551553 576285 518091 676517 652855 489958 652901 676491 676538 738910 760942 481166 772991 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage sex russian"
]
|
||||||||||||||||||||||||||||||
|
3.11 ms (1.64%) |
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 233102 386719 404209 422233 425003 426818 432404 447357 451748 456179 476397 481166 482079 484355 489958 490184 498867 500120 506629 513540 516039 517663 518091 519848 521915 525208 548601 551553 552232 554764 561356 561667 561686 574328 575797 575823 576285 578843 599451 600403 605961 612574 613850 614729 618943 623834 652855 652901 653238 653260 653561 654151 654390 655418 660959 669858 672511 672534 675359 676491 676499 676517 676538 676953 677039 679706 695051 699571 701487 706668 709372 709769 710998 716033 718967 720822 722799 722889 722901 726398 728171 728681 735410 736260 738432 738889 738910 740587 741596 743079 744507 745682 746207 750922 755587 758033 760919 760942 763953 764137 764158 765261 766115 768163 770438 772991 773187 781583 782524 789240 789450 789753 799726 799727 800587 808761 809802 813880 824806 825715 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.