Query Metrics
7
Database Queries
7
Different statements
163.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.96 ms (83.63%) |
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 6999 34049 226412 384550 388022 402021 411917 415515 437835 442473 446753 451691 453228 456725 460237 465474 473260 484522 496279 517419 529956 530929 531315 532439 533291 536313 536731 537748 548919 559348 564663 566044 573160 576614 599064 621695 625435 627580 636552 642924 645836 645844 645849 645948 651094 654148 664573 671891 681674 686610 692095 695180 696273 697250 698495 698976 704638 705120 709804 713646 715378 715973 719094 722714 726022 732140 734790 735231 735430 736447 737129 739471 741378 743722 745562 745956 750065 755403 757155 757713 758903 759422 760133 763748 772855 773259 774994 776763 781760 781896 784946 789625 790025 790093 793000 796572 797836 799103 799568 800166 800225 800292 800298 800302 800341 804184 804489 807203 810027 810670 812247 814052 814711 817950 818559 818773 821677 824535 827573 828178 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (8.55%) |
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 797836 810670 735430 745562 726022 735231 763748 697250 781896 451691 529956 226412 814052 828178 517419 532439 645836 681674 642924 773259 812247 599064 536731 573160 692095 34049 437835 821677 456725 484522 559348 645849 654148 713646 651094 784946 757713 760133 755403 800292 800298 800302 807203 625435 402021 415515 824535 531315 536313 715378 695180 705120 636552 804489 800166 776763 781760 800225 774994 566044 627580 818773 460237 698495 790025 790093 793000 789625 804184 772855 741378 743722 800341 388022 473260 645844 698976 796572 799568 384550 6999 465474 537748 530929 564663 671891 704638 709804 732140 757155 759422 750065 442473 453228 533291 411917 817950 818559 827573 814711 446753 496279 548919 686610 719094 722714 696273 645948 664573 715973 576614 621695 799103 739471 810027 734790 736447 737129 745956 758903 ] |
||||||||||||||||||||||||||||||
|
4.76 ms (2.91%) |
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 6999 34049 226412 384550 388022 402021 411917 415515 437835 442473 446753 451691 453228 456725 460237 465474 473260 484522 496279 517419 529956 530929 531315 532439 533291 536313 536731 537748 548919 559348 564663 566044 573160 576614 599064 621695 625435 627580 636552 642924 645836 645844 645849 645948 651094 654148 664573 671891 681674 686610 692095 695180 696273 697250 698495 698976 704638 705120 709804 713646 715378 715973 719094 722714 726022 732140 734790 735231 735430 736447 737129 739471 741378 743722 745562 745956 750065 755403 757155 757713 758903 759422 760133 763748 772855 773259 774994 776763 781760 781896 784946 789625 790025 790093 793000 796572 797836 799103 799568 800166 800225 800292 800298 800302 800341 804184 804489 807203 810027 810670 812247 814052 814711 817950 818559 818773 821677 824535 827573 828178 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn большие boobs"
]
|
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.