Query Metrics
7
Database Queries
7
Different statements
405.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.65 ms (53.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister красивая"
]
|
||||||||||||||||||||||||||||||
|
154.25 ms (38.03%) |
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 384938 396273 397528 413434 416298 417930 417975 418277 419292 420512 421189 421338 421655 423444 424231 426494 427379 429847 430324 432470 432524 433420 433590 433675 438031 438324 441692 442605 445502 446005 447815 448227 449164 449657 450164 452592 453739 455329 455652 456063 457479 457914 458457 460423 461166 461391 461895 463618 463710 464245 469212 471762 473557 475610 483224 484007 489613 490079 490243 492614 494815 495212 498984 499750 502988 502998 503216 504741 505081 507914 510016 512051 513994 515450 516124 520318 521998 522001 523458 524115 524163 524935 526247 527788 528023 530886 549555 560547 560868 561984 562716 577318 584666 597087 599640 601947 604726 607611 612489 614938 650197 652199 661990 682625 696888 713998 717708 740399 756703 757130 761467 761986 762165 766407 777455 790812 810719 810747 813071 ] |
||||||||||||||||||||||||||||||
|
24.54 ms (6.05%) |
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 420512 452592 442605 502998 510016 527788 495212 502988 523458 490079 505081 498984 503216 513994 515450 521998 601947 494815 560547 384938 417975 426494 432524 441692 413434 417930 421655 445502 457914 463710 461166 453739 471762 528023 530886 460423 464245 490243 577318 549555 562716 584666 570835 652199 682625 696888 650197 661990 713998 561984 607611 597087 599640 612489 614938 604726 790812 810747 810719 757130 740399 761986 762165 766407 756703 761467 717708 777455 813071 396273 419292 432470 438324 447815 449164 397528 433590 433675 450164 455652 456063 457479 461391 469212 418277 421189 424231 427379 438031 448227 416298 421338 423444 449657 463618 433420 446005 461895 473557 475610 516124 520318 484007 489613 492614 512051 483224 499750 504741 522001 524115 524935 526247 507914 524163 430324 455329 560868 429847 458457 ] |
||||||||||||||||||||||||||||||
|
3.93 ms (0.97%) |
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 384938 396273 397528 413434 416298 417930 417975 418277 419292 420512 421189 421338 421655 423444 424231 426494 427379 429847 430324 432470 432524 433420 433590 433675 438031 438324 441692 442605 445502 446005 447815 448227 449164 449657 450164 452592 453739 455329 455652 456063 457479 457914 458457 460423 461166 461391 461895 463618 463710 464245 469212 471762 473557 475610 483224 484007 489613 490079 490243 492614 494815 495212 498984 499750 502988 502998 503216 504741 505081 507914 510016 512051 513994 515450 516124 520318 521998 522001 523458 524115 524163 524935 526247 527788 528023 530886 549555 560547 560868 561984 562716 577318 584666 597087 599640 601947 604726 607611 612489 614938 650197 652199 661990 682625 696888 713998 717708 740399 756703 757130 761467 761986 762165 766407 777455 790812 810719 810747 813071 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister красивая"
]
|
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.