Query Metrics
7
Database Queries
7
Different statements
155.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.60 ms (82.09%) |
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 14323 88286 119927 161378 187353 188499 386421 390125 390713 391945 392015 394590 395628 396720 396722 398121 398646 401793 403575 416593 416632 416678 419567 423662 424174 426997 428035 428045 429134 429736 432283 434286 435373 435537 435551 439142 439647 441589 443198 445351 451092 451616 452876 454647 456233 458014 458305 460120 460813 461704 463904 463915 465519 468166 470056 470125 471681 473740 475647 476164 477589 480478 484809 485546 487414 487726 488837 490741 490866 492294 493691 495758 499771 503473 516460 516527 518125 519481 520419 520767 522681 523883 524838 526073 528143 530429 535429 538007 541251 541278 546958 547237 552608 554416 555048 559521 567127 577100 579582 583774 590804 591835 597790 601696 621125 621759 627361 636958 639379 643681 654165 659394 659964 665796 674181 695911 724114 733317 780724 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (11.48%) |
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 547237 659964 559521 621759 627361 461704 391945 485546 519481 386421 390125 161378 394590 451092 695911 591835 398121 398646 428035 535429 567127 554416 546958 454647 188499 187353 396722 416593 432283 435537 441589 416632 443198 435551 419567 458014 451616 487414 493691 456233 530429 471681 659394 665796 780724 724114 733317 643681 439647 392015 396720 435373 452876 14323 445351 460813 424174 439142 516460 390713 401793 416678 423662 463915 480478 477589 475647 476164 577100 654165 674181 555048 601696 597790 636958 639379 88286 468166 429134 429736 463904 434286 473740 119927 460120 499771 528143 492294 526073 541251 490866 516527 524838 488837 490741 538007 621125 395628 579582 484809 458305 471695 520419 465519 470125 541278 552608 428045 470056 403575 487726 503473 495758 426997 590804 523883 520767 522681 583774 518125 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.71%) |
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 14323 88286 119927 161378 187353 188499 386421 390125 390713 391945 392015 394590 395628 396720 396722 398121 398646 401793 403575 416593 416632 416678 419567 423662 424174 426997 428035 428045 429134 429736 432283 434286 435373 435537 435551 439142 439647 441589 443198 445351 451092 451616 452876 454647 456233 458014 458305 460120 460813 461704 463904 463915 465519 468166 470056 470125 471681 473740 475647 476164 477589 480478 484809 485546 487414 487726 488837 490741 490866 492294 493691 495758 499771 503473 516460 516527 518125 519481 520419 520767 522681 523883 524838 526073 528143 530429 535429 538007 541251 541278 546958 547237 552608 554416 555048 559521 567127 577100 579582 583774 590804 591835 597790 601696 621125 621759 627361 636958 639379 643681 654165 659394 659964 665796 674181 695911 724114 733317 780724 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anus anal"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анус анал"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
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.