Query Metrics
7
Database Queries
7
Different statements
215.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.88 ms (86.55%) |
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 32678 46580 97688 122425 143010 396094 404384 409909 414069 420185 425027 443497 445431 449360 450822 458614 460606 463798 464651 467639 497557 497568 511378 516060 517864 523536 525091 529120 529411 529430 530017 530497 531196 532182 532500 532798 533241 533337 534804 534825 534848 535072 537113 539170 540238 541089 541854 543872 543874 543905 544409 550316 550742 554016 556030 556421 557605 564767 565101 572021 575335 575435 583996 586248 593092 593879 597142 597242 597670 601237 606538 606868 608395 609991 615627 616561 617130 619177 619199 630280 630533 630955 631572 633855 634195 635227 636290 646246 647626 650506 651577 651578 651991 654297 658124 662197 665930 675934 697369 711820 726665 732423 738854 746942 747966 760025 771827 786461 801880 804462 807692 809459 812800 815330 815784 816260 820340 820590 820767 820900 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (8.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 543874 443497 143010 820590 820900 511378 523536 529411 535072 575335 651578 658124 711820 597670 634195 615627 616561 760025 738854 771827 537113 550742 619199 420185 450822 529430 530017 556030 404384 414069 815784 445431 532798 534848 539170 533241 525091 467639 541089 665930 675934 646246 650506 697369 586248 606538 617130 807692 726665 732423 630955 32678 464651 396094 449360 543872 633855 608395 820340 636290 97688 409909 534804 544409 564767 654297 662197 635227 597242 631572 606868 593092 609991 809459 747966 801880 460606 497568 517864 497557 554016 630533 458614 122425 46580 820767 816260 530497 532500 534825 531196 533337 572021 543905 557605 583996 647626 619177 593879 601237 812800 786461 804462 651991 630280 425027 651577 746942 541854 815330 463798 529120 532182 516060 540238 556421 565101 550316 575435 597142 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (1.85%) |
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 32678 46580 97688 122425 143010 396094 404384 409909 414069 420185 425027 443497 445431 449360 450822 458614 460606 463798 464651 467639 497557 497568 511378 516060 517864 523536 525091 529120 529411 529430 530017 530497 531196 532182 532500 532798 533241 533337 534804 534825 534848 535072 537113 539170 540238 541089 541854 543872 543874 543905 544409 550316 550742 554016 556030 556421 557605 564767 565101 572021 575335 575435 583996 586248 593092 593879 597142 597242 597670 601237 606538 606868 608395 609991 615627 616561 617130 619177 619199 630280 630533 630955 631572 633855 634195 635227 636290 646246 647626 650506 651577 651578 651991 654297 658124 662197 665930 675934 697369 711820 726665 732423 738854 746942 747966 760025 771827 786461 801880 804462 807692 809459 812800 815330 815784 816260 820340 820590 820767 820900 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian interracial"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.65%) |
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.