Query Metrics
7
Database Queries
7
Different statements
213.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.38 ms (87.87%) |
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 118086 154543 154972 340635 346141 352189 357499 386421 387848 388341 414271 428223 428257 428282 429859 435550 439059 439572 439993 441067 441110 446386 446797 447198 450572 450889 451121 451337 451775 452885 452889 456222 456236 456239 456244 461610 462337 466739 468684 469615 471682 473413 479542 480457 496340 497667 510532 512931 514235 519313 519699 519722 519760 526224 526608 529988 530011 531524 531869 534082 540504 541325 545305 545384 547485 559360 569656 573801 583387 584029 586760 590255 597167 600087 600312 608076 609892 614328 614978 615946 619108 620017 623420 628113 628485 633887 634071 634746 639752 639797 639804 639809 648224 656932 658789 660380 669007 680164 695559 710877 717535 719651 720007 720720 725619 735202 742353 745100 745129 745136 759370 770860 770864 782792 788580 788926 788953 789529 791012 811013 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (7.54%) |
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 720007 615946 619108 788580 456239 510532 526224 456244 439993 547485 720720 429859 656932 811013 450889 742353 719651 514235 531869 469615 386421 526608 446386 452885 450572 388341 559360 710877 669007 573801 584029 456222 512931 633887 118086 154543 496340 497667 529988 456236 461610 634746 428223 451775 154972 480457 770864 519760 648224 620017 628485 789529 471682 441067 352189 451121 447198 468684 435550 452889 479542 414271 428257 357499 519699 540504 600312 639752 717535 658789 680164 634071 614328 639804 600087 745136 791012 725619 759370 531524 346141 519313 614978 446797 387848 340635 569656 770860 639809 623420 735202 695559 541325 428282 609892 639797 439059 473413 519722 586760 441110 788953 788926 545305 590255 583387 439572 462337 466739 545384 451337 530011 534082 660380 608076 628113 597167 782792 745129 745100 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.31%) |
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 118086 154543 154972 340635 346141 352189 357499 386421 387848 388341 414271 428223 428257 428282 429859 435550 439059 439572 439993 441067 441110 446386 446797 447198 450572 450889 451121 451337 451775 452885 452889 456222 456236 456239 456244 461610 462337 466739 468684 469615 471682 473413 479542 480457 496340 497667 510532 512931 514235 519313 519699 519722 519760 526224 526608 529988 530011 531524 531869 534082 540504 541325 545305 545384 547485 559360 569656 573801 583387 584029 586760 590255 597167 600087 600312 608076 609892 614328 614978 615946 619108 620017 623420 628113 628485 633887 634071 634746 639752 639797 639804 639809 648224 656932 658789 660380 669007 680164 695559 710877 717535 719651 720007 720720 725619 735202 742353 745100 745129 745136 759370 770860 770864 782792 788580 788926 788953 789529 791012 811013 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fisting stockings"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.75%) |
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.