Query Metrics
7
Database Queries
7
Different statements
263.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.90 ms (87.40%) |
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 384581 405709 416288 420320 426480 427171 432782 437829 441017 443669 454244 459378 462706 467418 467445 469303 470716 472616 472695 474797 476334 480814 485302 485398 487067 487144 488203 489120 492515 493242 494649 494768 498024 498064 503920 503953 503962 504765 506659 506665 511523 511803 513280 515281 517144 522362 522489 524025 529546 533589 533636 550130 552083 553706 553720 557983 560152 560157 560169 560445 560825 562882 564443 565046 566047 571036 571464 574162 574176 574179 584673 586472 586474 591607 593368 594770 599436 600078 600107 600115 601952 604159 605355 605395 606738 610595 612336 617178 620277 620282 620619 620987 621504 622826 623724 623831 624214 624369 624511 674064 675381 681478 686710 687551 689634 694387 699025 699334 702430 704561 706676 706984 709543 712978 721617 721646 739557 789677 799642 803293 ] |
||||||||||||||||||||||||||||||
|
22.82 ms (8.67%) |
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 467445 470716 506665 511523 498064 513280 699025 488203 426480 472695 524025 469303 533636 384581 427171 416288 432782 459378 467418 498024 504765 552083 560157 565046 571464 557983 574162 584673 675381 699334 706984 712978 704561 686710 687551 560169 566047 594770 599436 604159 605355 610595 593368 600107 600115 612336 620277 620987 624369 586474 623724 789677 803293 739557 706676 454244 441017 522362 492515 517144 487067 503953 515281 503962 506659 437829 485302 574176 694387 571036 622826 601952 617178 623831 462706 480814 476334 443669 474797 503920 709543 799642 420320 560825 405709 533589 494649 522489 485398 529546 550130 553706 560445 574179 562882 564443 553720 560152 721617 674064 681478 689634 721646 621504 591607 606738 586472 600078 605395 620282 620619 624511 702430 472616 489120 493242 487144 511803 494768 624214 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.21%) |
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 384581 405709 416288 420320 426480 427171 432782 437829 441017 443669 454244 459378 462706 467418 467445 469303 470716 472616 472695 474797 476334 480814 485302 485398 487067 487144 488203 489120 492515 493242 494649 494768 498024 498064 503920 503953 503962 504765 506659 506665 511523 511803 513280 515281 517144 522362 522489 524025 529546 533589 533636 550130 552083 553706 553720 557983 560152 560157 560169 560445 560825 562882 564443 565046 566047 571036 571464 574162 574176 574179 584673 586472 586474 591607 593368 594770 599436 600078 600107 600115 601952 604159 605355 605395 606738 610595 612336 617178 620277 620282 620619 620987 621504 622826 623724 623831 624214 624369 624511 674064 675381 681478 686710 687551 689634 694387 699025 699334 702430 704561 706676 706984 709543 712978 721617 721646 739557 789677 799642 803293 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young hidden"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young скрыт"
]
|
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.