Query Metrics
7
Database Queries
7
Different statements
187.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.18 ms (86.71%) |
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 181184 370332 390643 391717 393475 396075 396245 397856 401108 401976 402438 462207 467948 470965 478310 484827 507092 508542 513157 516511 520388 520788 525030 531647 544200 560961 564348 566764 567232 567311 576134 583383 584915 592402 592686 602409 604322 604338 609267 615698 616885 617698 623130 625461 636956 641192 654338 671890 680395 680780 684122 685513 686113 694132 713670 713911 714964 716992 717221 717725 721971 724118 726641 728379 730457 731234 733246 734432 734959 734990 735961 737051 738589 739913 740726 742846 743069 748980 754207 756789 760955 762271 762809 763009 764843 765103 765364 765366 765540 765708 766711 766712 766786 767055 767972 768703 769786 771344 771429 777631 777646 781412 782445 783275 783778 786372 786400 790394 790770 791426 791599 792953 793179 794142 796364 804708 804995 806046 810533 813903 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (7.58%) |
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 786400 791599 793179 804708 806046 734432 740726 743069 754207 781412 782445 786372 790770 792953 794142 731234 742846 763009 764843 766711 766712 768703 730457 739913 762271 765103 765366 767972 724118 728379 762809 765364 765540 765708 726641 734959 734990 735961 737051 738589 756789 767055 771429 609267 623130 713670 714964 716992 717221 717725 721971 783275 783778 791426 393475 397856 402438 181184 771344 508542 513157 520388 520788 516511 525030 478310 567311 584915 654338 602409 592402 604338 462207 396075 484827 507092 583383 544200 564348 567232 576134 713911 685513 684122 560961 615698 592686 636956 604322 616885 617698 777646 777631 796364 760955 766786 733246 641192 391717 370332 396245 401976 401108 671890 694132 804995 810533 790394 769786 748980 390643 470965 467948 531647 680780 686113 680395 566764 625461 813903 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (1.90%) |
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 181184 370332 390643 391717 393475 396075 396245 397856 401108 401976 402438 462207 467948 470965 478310 484827 507092 508542 513157 516511 520388 520788 525030 531647 544200 560961 564348 566764 567232 567311 576134 583383 584915 592402 592686 602409 604322 604338 609267 615698 616885 617698 623130 625461 636956 641192 654338 671890 680395 680780 684122 685513 686113 694132 713670 713911 714964 716992 717221 717725 721971 724118 726641 728379 730457 731234 733246 734432 734959 734990 735961 737051 738589 739913 740726 742846 743069 748980 754207 756789 760955 762271 762809 763009 764843 765103 765364 765366 765540 765708 766711 766712 766786 767055 767972 768703 769786 771344 771429 777631 777646 781412 782445 783275 783778 786372 786400 790394 790770 791426 791599 792953 793179 794142 796364 804708 804995 806046 810533 813903 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ Ðüð┐ðÁÐÇð╝ð░ ð▓ ð░ð¢ð░ð╗ÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые сперм анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.