Query Metrics
7
Database Queries
7
Different statements
147.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.91 ms (84.45%) |
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 90684 405709 418559 418654 419487 425500 426461 427878 429124 432707 448557 450515 456634 462253 465617 465951 467397 470802 470947 475625 475857 476746 486111 489120 496361 498025 498066 499814 504776 506522 516402 516442 518349 519492 520982 525774 531903 540098 550130 550505 550507 551627 553723 557977 564443 572004 572827 574580 585023 586527 591077 593533 594866 594916 594918 595654 597831 600553 601065 602929 605929 607735 609712 611336 615622 620276 620280 620285 621578 622037 623860 624249 624365 624508 640738 664433 672408 682047 683074 684298 687542 687544 688342 689272 693023 694154 696928 696934 698289 698293 698301 698680 698708 699023 699053 699333 699335 702077 702430 702835 703192 706290 709428 712035 713270 713630 721798 727594 733181 734824 741127 743009 743396 753993 759570 764352 766687 771874 805347 808114 ] |
||||||||||||||||||||||||||||||
|
13.23 ms (8.94%) |
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 609712 620285 621578 624508 611336 595654 733181 734824 741127 743009 743396 759570 771874 753993 622037 698293 698708 721798 808114 465617 456634 432707 405709 519492 602929 550130 564443 702430 499814 489120 597831 426461 585023 448557 475625 462253 496361 525774 664433 684298 687544 702077 703192 712035 696928 698680 699053 702835 709428 672408 683074 688342 694154 698301 699333 713270 713630 593533 624249 586527 607735 615622 620276 600553 623860 624365 594866 594916 594918 601065 605929 805347 727594 766687 764352 640738 696934 90684 475857 419487 467397 486111 557977 572004 620280 518349 591077 427878 504776 516442 418654 425500 429124 418559 450515 465951 470802 470947 476746 498025 498066 506522 516402 520982 531903 540098 550505 551627 553723 572827 550507 574580 699023 699335 706290 687542 689272 693023 698289 682047 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.52%) |
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 90684 405709 418559 418654 419487 425500 426461 427878 429124 432707 448557 450515 456634 462253 465617 465951 467397 470802 470947 475625 475857 476746 486111 489120 496361 498025 498066 499814 504776 506522 516402 516442 518349 519492 520982 525774 531903 540098 550130 550505 550507 551627 553723 557977 564443 572004 572827 574580 585023 586527 591077 593533 594866 594916 594918 595654 597831 600553 601065 602929 605929 607735 609712 611336 615622 620276 620280 620285 621578 622037 623860 624249 624365 624508 640738 664433 672408 682047 683074 684298 687542 687544 688342 689272 693023 694154 696928 696934 698289 698293 698301 698680 698708 699023 699053 699333 699335 702077 702430 702835 703192 706290 709428 712035 713270 713630 721798 727594 733181 734824 741127 743009 743396 753993 759570 764352 766687 771874 805347 808114 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden old man"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт old мужчин"
]
|
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.