Query Metrics
7
Database Queries
7
Different statements
143.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.16 ms (81.88%) |
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 6643 33236 109043 383547 385538 387241 390082 390493 390702 391134 393077 395527 398166 398212 401881 403109 406521 407586 408578 411630 411769 411910 411951 423177 426250 427264 429592 429936 430244 444739 445730 448403 449097 451797 456875 458301 462233 466918 468484 474078 474691 475864 476155 476306 483792 490825 493228 496458 500698 502033 508705 510894 512227 516076 516125 517439 524901 525742 549247 552898 559405 563776 565931 578174 584921 588900 596523 596967 599737 612160 612298 614847 615964 617575 619573 642126 646807 649952 650977 660769 665224 665294 665416 666080 667222 670952 677360 677371 691607 694192 697302 701416 707605 714032 714934 718558 719102 719205 724520 724696 724762 729972 732169 733342 734278 739060 739955 740512 742269 743769 746632 750072 759015 789269 795812 802382 818134 819396 819988 825140 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (10.89%) |
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 584921 563776 665416 707605 719102 649952 665224 666080 670952 677360 677371 694192 665294 718558 559405 578174 614847 588900 596523 599737 612160 619573 596967 617575 642126 802382 789269 724696 729972 732169 733342 739060 724520 724762 740512 739955 750072 759015 615964 795812 109043 474078 391134 398212 408578 429936 458301 387241 390493 411769 406521 476155 508705 516125 510894 500698 516076 660769 719205 734278 650977 525742 667222 411630 517439 493228 502033 549247 565931 393077 395527 818134 383547 444739 445730 449097 33236 398166 411951 819396 825140 483792 691607 612298 6643 427264 646807 697302 742269 743769 819988 701416 714032 714934 746632 385538 390702 390082 401881 403109 411910 423177 426250 407586 429592 430244 552898 448403 468484 476306 451797 456875 474691 462233 466918 475864 490825 512227 496458 524901 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.20%) |
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 6643 33236 109043 383547 385538 387241 390082 390493 390702 391134 393077 395527 398166 398212 401881 403109 406521 407586 408578 411630 411769 411910 411951 423177 426250 427264 429592 429936 430244 444739 445730 448403 449097 451797 456875 458301 462233 466918 468484 474078 474691 475864 476155 476306 483792 490825 493228 496458 500698 502033 508705 510894 512227 516076 516125 517439 524901 525742 549247 552898 559405 563776 565931 578174 584921 588900 596523 596967 599737 612160 612298 614847 615964 617575 619573 642126 646807 649952 650977 660769 665224 665294 665416 666080 667222 670952 677360 677371 691607 694192 697302 701416 707605 714032 714934 718558 719102 719205 724520 724696 724762 729972 732169 733342 734278 739060 739955 740512 742269 743769 746632 750072 759015 789269 795812 802382 818134 819396 819988 825140 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy cock"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая cock"
]
|
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.