Query Metrics
7
Database Queries
7
Different statements
184.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.59 ms (85.96%) |
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 6858 17037 28242 232978 233737 236472 381888 387651 389779 390875 396065 396082 397436 397847 401116 403353 406074 412656 420513 434829 441467 441596 443010 444912 446169 446584 446612 447101 447555 452260 455585 455787 456239 456381 461460 463321 465971 466454 466974 470012 475956 480857 487460 488837 491138 496082 496742 501039 509426 513456 525395 526901 533782 536264 543717 543745 552677 552977 554475 555955 558846 561657 561743 562492 566766 574924 575156 575206 575492 576145 595359 596630 596649 597035 597063 597960 598470 598597 601643 613518 634532 661933 692440 719555 723271 738124 739913 744662 745363 750228 752708 752731 756656 760935 762277 762969 764260 764821 765091 775575 781565 782032 786372 788356 789205 790397 791426 792953 797942 799905 800003 800563 804893 805532 810038 812468 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (7.57%) |
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 765091 781565 786372 792953 804893 805532 810038 756656 739913 750228 764260 752731 760935 738124 744662 613518 723271 775575 782032 791426 797942 812468 6858 447101 790397 465971 470012 543745 232978 390875 233737 543717 562492 692440 661933 576145 598597 791945 791973 799905 752708 762277 762969 764821 397436 28242 406074 446584 552977 554475 597063 455787 480857 452260 466454 446612 456239 447555 475956 487460 496742 525395 488837 491138 513456 634532 455585 536264 574924 575492 552677 561743 566766 575156 558846 561657 575206 597960 598470 601643 800563 387651 444912 401116 403353 420513 496082 526901 396065 434829 412656 441467 441596 463321 396082 17037 236472 397847 381888 461460 456381 443010 466974 389779 509426 789205 555955 596649 596630 595359 446169 533782 501039 719555 597035 788356 790440 791935 745363 800003 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.28%) |
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 6858 17037 28242 232978 233737 236472 381888 387651 389779 390875 396065 396082 397436 397847 401116 403353 406074 412656 420513 434829 441467 441596 443010 444912 446169 446584 446612 447101 447555 452260 455585 455787 456239 456381 461460 463321 465971 466454 466974 470012 475956 480857 487460 488837 491138 496082 496742 501039 509426 513456 525395 526901 533782 536264 543717 543745 552677 552977 554475 555955 558846 561657 561743 562492 566766 574924 575156 575206 575492 576145 595359 596630 596649 597035 597063 597960 598470 598597 601643 613518 634532 661933 692440 719555 723271 738124 739913 744662 745363 750228 752708 752731 756656 760935 762277 762969 764260 764821 765091 775575 781565 782032 786372 788356 789205 790397 791426 792953 797942 799905 800003 800563 804893 805532 810038 812468 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus teen doggy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen рак"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen рак"
]
|
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.