Query Metrics
7
Database Queries
7
Different statements
153.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.57 ms (85.49%) |
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 88664 401799 418827 432294 434349 443236 448079 449014 449024 452822 452824 459388 464951 468012 469636 470471 475411 475426 476705 483522 487537 492906 494302 495204 499885 500912 511869 513221 513223 515253 518187 518505 522156 522174 530021 534772 534777 545411 547476 566545 567054 569729 569776 582580 582582 592593 593521 610151 623276 629281 630406 633455 636955 642042 656851 660577 663158 668300 670956 680242 692665 695866 700693 707964 728290 730073 737578 738446 738453 738472 738483 738492 738496 739135 739148 739155 740450 752636 752683 752711 753703 755949 758336 758786 772211 772235 774862 774872 776538 777001 777016 779769 780065 780684 782845 782891 782936 785589 793297 795373 796372 796640 796675 796678 796681 796696 796715 797003 799362 799853 801621 803995 806375 806541 806584 807142 807634 807651 808341 817172 ] |
||||||||||||||||||||||||||||||
|
12.81 ms (8.33%) |
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 452824 511869 464951 670956 518505 475411 534777 518187 534772 796640 752683 738496 752636 483522 499885 547476 663158 700693 695866 569729 633455 780684 806584 807142 772235 782891 752711 737578 739155 630406 796678 796681 494302 448079 449014 522156 515253 569776 582582 566545 692665 88664 817172 476705 495204 656851 660577 668300 707964 593521 636955 623276 610151 774872 793297 776538 795373 808341 758336 772211 782936 801621 803995 740450 728290 738453 738472 738492 739135 739148 730073 753703 755949 774862 782845 799853 806375 807634 807651 443236 500912 401799 468012 432294 418827 452822 469636 513221 530021 545411 642042 592593 779769 780065 785589 796372 796696 796715 777016 797003 806541 738446 738483 758786 629281 777001 796675 799362 487537 492906 459388 434349 449024 475426 470471 522174 513223 567054 582580 680242 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.88%) |
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 88664 401799 418827 432294 434349 443236 448079 449014 449024 452822 452824 459388 464951 468012 469636 470471 475411 475426 476705 483522 487537 492906 494302 495204 499885 500912 511869 513221 513223 515253 518187 518505 522156 522174 530021 534772 534777 545411 547476 566545 567054 569729 569776 582580 582582 592593 593521 610151 623276 629281 630406 633455 636955 642042 656851 660577 663158 668300 670956 680242 692665 695866 700693 707964 728290 730073 737578 738446 738453 738472 738483 738492 738496 739135 739148 739155 740450 752636 752683 752711 753703 755949 758336 758786 772211 772235 774862 774872 776538 777001 777016 779769 780065 780684 782845 782891 782936 785589 793297 795373 796372 796640 796675 796678 796681 796696 796715 797003 799362 799853 801621 803995 806375 806541 806584 807142 807634 807651 808341 817172 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine dildo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин дилд"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
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.