Query Metrics
7
Database Queries
7
Different statements
172.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.78 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 152056 152479 152765 152883 183601 382801 383687 389696 392915 404608 416299 428810 517479 530559 541134 543106 553831 557069 557794 568188 570746 587978 588278 592680 592962 594581 596965 597164 609732 614183 623372 626135 626265 630016 630030 633030 633179 634473 646079 649276 655485 658966 662559 668732 682957 684886 689477 691148 693230 700196 702300 705211 713008 715592 716999 719380 719889 721729 723575 726467 730473 730614 730636 735463 737286 741468 749662 750652 751217 751508 753628 756513 757453 759866 762499 762964 764617 764659 765839 768269 768888 771400 773431 777755 781105 781805 784581 786477 787070 787400 787881 789030 789070 789187 791478 793113 793308 795379 796946 800596 801149 801216 801717 804177 804563 809529 810399 810948 813643 816130 816790 818000 818135 819448 819913 821788 822938 823612 824488 ] |
||||||||||||||||||||||||||||||
|
11.86 ms (6.88%) |
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 715592 716999 791478 383687 623372 804177 773431 183601 723575 824488 819448 543106 691148 684886 630030 730614 762964 801149 730636 759866 751217 750652 626265 800596 152765 428810 818135 816130 530559 646079 662559 700196 713008 594581 592680 626135 596965 749662 756513 757453 777755 781105 821788 816790 702300 721729 682957 588278 793308 801216 796946 762499 771400 810399 765839 730473 764617 768888 764659 633030 789187 795379 152056 822938 823612 689477 655485 658966 587978 781805 789030 810948 784581 793113 726467 741468 737286 768269 786477 557069 152883 568188 719380 649276 633179 634473 819913 719889 597164 809529 787881 382801 404608 822897 517479 557794 668732 693230 570746 614183 789070 753628 804563 416299 813643 541134 553831 705211 592962 609732 630016 787400 735463 751508 787070 801717 389696 152479 392915 818000 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.87%) |
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 152056 152479 152765 152883 183601 382801 383687 389696 392915 404608 416299 428810 517479 530559 541134 543106 553831 557069 557794 568188 570746 587978 588278 592680 592962 594581 596965 597164 609732 614183 623372 626135 626265 630016 630030 633030 633179 634473 646079 649276 655485 658966 662559 668732 682957 684886 689477 691148 693230 700196 702300 705211 713008 715592 716999 719380 719889 721729 723575 726467 730473 730614 730636 735463 737286 741468 749662 750652 751217 751508 753628 756513 757453 759866 762499 762964 764617 764659 765839 768269 768888 771400 773431 777755 781105 781805 784581 786477 787070 787400 787881 789030 789070 789187 791478 793113 793308 795379 796946 800596 801149 801216 801717 804177 804563 809529 810399 810948 813643 816130 816790 818000 818135 819448 819913 821788 822938 823612 824488 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck hotel"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hotel"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hotel"
]
|
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.