Query Metrics
7
Database Queries
7
Different statements
164.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.80 ms (86.17%) |
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 287436 386771 388662 390746 397288 398204 401764 417952 446877 447444 456469 461738 464598 536245 536396 552748 558821 592300 597834 600146 601102 624209 628116 631106 635339 639552 641628 642359 646211 652605 652927 654401 656085 656615 657230 658728 660349 662181 666871 672266 672629 674110 683092 685005 691662 692117 694132 695156 697458 710909 711957 715396 715657 716633 719344 720102 720418 724129 726176 728404 728518 728735 728762 729293 734990 736228 737643 737853 738021 741529 744090 744689 747443 748434 752545 754584 760481 761682 764876 765096 766602 766785 766885 769075 771352 772960 773421 777000 778850 778962 779706 779730 781331 782432 782544 782573 782991 783618 784280 785772 788912 790531 790548 791200 792679 795858 796920 797203 800554 800576 814502 816679 817215 818570 821136 824048 825221 825414 827381 827982 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (8.20%) |
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 635339 697458 796920 652605 778962 769075 401764 386771 536396 597834 628116 446877 447444 666871 737853 417952 797203 558821 726176 728762 711957 716633 782544 827982 824048 728404 641628 744689 695156 720102 748434 715396 766602 792679 791200 781331 825221 784280 825414 827381 536245 747443 800576 764876 654401 720418 660349 785772 601102 600146 639552 724129 741529 778850 691662 692117 729293 761682 782991 766885 685005 821136 736228 631106 795858 816679 744090 782573 782432 398204 397288 814502 772960 710909 790548 800554 658728 683092 779706 662181 817215 652927 788912 790531 754584 766785 656615 390746 674110 694132 592300 456469 464598 657230 715657 646211 552748 624209 779730 737643 765096 728518 773421 734990 738021 760481 783618 728735 642359 287436 461738 388662 818570 656085 672629 672266 719344 777000 752545 771352 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.43%) |
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 287436 386771 388662 390746 397288 398204 401764 417952 446877 447444 456469 461738 464598 536245 536396 552748 558821 592300 597834 600146 601102 624209 628116 631106 635339 639552 641628 642359 646211 652605 652927 654401 656085 656615 657230 658728 660349 662181 666871 672266 672629 674110 683092 685005 691662 692117 694132 695156 697458 710909 711957 715396 715657 716633 719344 720102 720418 724129 726176 728404 728518 728735 728762 729293 734990 736228 737643 737853 738021 741529 744090 744689 747443 748434 752545 754584 760481 761682 764876 765096 766602 766785 766885 769075 771352 772960 773421 777000 778850 778962 779706 779730 781331 782432 782544 782573 782991 783618 784280 785772 788912 790531 790548 791200 792679 795858 796920 797203 800554 800576 814502 816679 817215 818570 821136 824048 825221 825414 827381 827982 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen hard анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen hard анал"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen hard anal"
]
|
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.