Query Metrics
7
Database Queries
7
Different statements
199.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.73 ms (85.44%) |
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 87974 88591 154133 154512 154535 154972 290366 340635 375135 382207 384117 384397 387026 389541 391992 392848 395252 398078 401353 401367 402631 412149 412814 416036 416230 416659 416699 416708 419167 427132 437926 442548 453221 467112 467636 469737 471132 476656 478489 483684 485661 487414 490128 491642 498720 499872 505356 506105 511278 513794 516640 524678 526179 530428 530698 531579 531822 531850 531856 535959 540680 547475 552704 561019 562503 567561 569258 574377 575844 576533 580130 580782 580832 581645 585680 586994 587306 589185 609887 609890 616454 656856 660369 660380 666854 670210 670356 671008 671038 672944 672952 705119 707571 712268 718701 718772 734214 748287 752627 752679 752713 782057 788027 788118 788863 788908 791039 792370 792712 796640 796647 796703 798599 799695 803534 806834 807112 807569 810761 811700 ] |
||||||||||||||||||||||||||||||
|
18.49 ms (9.25%) |
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 792712 806834 290366 416036 442548 796640 478489 437926 154512 712268 586994 581645 792370 416659 487414 453221 524678 788118 416708 491642 531579 552704 587306 609890 506105 791039 389541 398078 412149 656856 788027 810761 384117 401353 531822 531856 530428 531850 576533 705119 670210 707571 609887 799695 807569 811700 752713 748287 752627 807112 375135 154535 395252 498720 535959 562503 511278 569258 469737 505356 387026 391992 427132 734214 384397 154133 154972 382207 88591 467112 540680 516640 526179 513794 483684 567561 340635 575844 392848 402631 401367 476656 485661 530698 467636 547475 574377 561019 580782 580832 660380 672944 718772 660369 670356 671008 672952 666854 671038 718701 580130 585680 589185 616454 782057 796703 798599 796647 803534 752679 788863 788908 87974 499872 412814 416230 416699 419167 490128 471132 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.72%) |
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 87974 88591 154133 154512 154535 154972 290366 340635 375135 382207 384117 384397 387026 389541 391992 392848 395252 398078 401353 401367 402631 412149 412814 416036 416230 416659 416699 416708 419167 427132 437926 442548 453221 467112 467636 469737 471132 476656 478489 483684 485661 487414 490128 491642 498720 499872 505356 506105 511278 513794 516640 524678 526179 530428 530698 531579 531822 531850 531856 535959 540680 547475 552704 561019 562503 567561 569258 574377 575844 576533 580130 580782 580832 581645 585680 586994 587306 589185 609887 609890 616454 656856 660369 660380 666854 670210 670356 671008 671038 672944 672952 705119 707571 712268 718701 718772 734214 748287 752627 752679 752713 782057 788027 788118 788863 788908 791039 792370 792712 796640 796647 796703 798599 799695 803534 806834 807112 807569 810761 811700 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls dildo"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.