Query Metrics
7
Database Queries
7
Different statements
220.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.59 ms (88.71%) |
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 4229 146944 220792 319463 365885 382188 382207 384272 385469 385889 386405 386416 389182 389425 391649 407426 407705 412642 419293 424614 426283 428920 432317 442013 445498 449078 449930 451281 454793 460833 464601 474226 477325 477980 489000 492462 494530 497691 500843 504629 509594 513975 520830 522592 522850 526162 527301 528127 529488 531507 533644 534047 536089 537844 542831 543228 544571 548277 554995 555348 555368 555377 555396 563103 564388 567107 568991 572738 573165 574642 577038 578418 578574 580319 581401 582029 583860 584983 588770 590771 591790 591916 594143 594363 595362 596796 597917 598552 600144 601524 602947 605201 605561 606506 607610 613640 614345 617193 617385 630830 630955 636462 645971 659370 661915 663350 663451 664818 691820 707556 713332 721277 725407 738528 759712 769291 770269 773794 789844 807902 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (6.78%) |
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 594363 595362 598552 605201 605561 606506 617193 617385 630830 591790 594143 596796 600144 602947 613640 614345 725407 789844 807902 759712 769291 770269 773794 738528 601524 607610 630955 636462 713332 4229 146944 319463 382188 386416 389425 385469 442013 474226 477980 365885 407426 419293 451281 528127 494530 489000 504629 509594 529488 391649 389182 581401 426283 522592 721277 385889 386405 384272 220792 382207 407705 424614 432317 412642 428920 584983 445498 460833 449078 464601 492462 449930 454793 522850 526162 527301 513975 531507 534047 537844 497691 500843 520830 533644 536089 477325 542831 544571 554995 555368 555377 555396 563103 564388 568991 573165 574642 577038 578418 580319 543228 582029 664818 707556 691820 645971 659370 661915 663350 663451 548277 555348 567107 572738 578574 583860 588770 590771 591916 597917 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.33%) |
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 4229 146944 220792 319463 365885 382188 382207 384272 385469 385889 386405 386416 389182 389425 391649 407426 407705 412642 419293 424614 426283 428920 432317 442013 445498 449078 449930 451281 454793 460833 464601 474226 477325 477980 489000 492462 494530 497691 500843 504629 509594 513975 520830 522592 522850 526162 527301 528127 529488 531507 533644 534047 536089 537844 542831 543228 544571 548277 554995 555348 555368 555377 555396 563103 564388 567107 568991 572738 573165 574642 577038 578418 578574 580319 581401 582029 583860 584983 588770 590771 591790 591916 594143 594363 595362 596796 597917 598552 600144 601524 602947 605201 605561 606506 607610 613640 614345 617193 617385 630830 630955 636462 645971 659370 661915 663350 663451 664818 691820 707556 713332 721277 725407 738528 759712 769291 770269 773794 789844 807902 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy riding"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая riding"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая riding"
]
|
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.