Query Metrics
7
Database Queries
7
Different statements
185.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.65 ms (86.46%) |
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 21500 78307 213057 383226 386578 401559 403317 406339 407279 411389 411392 411406 411470 413503 413642 418215 420106 425106 428133 429086 431337 436883 448398 448864 452163 452604 453036 453714 458062 459795 461271 462021 465607 465763 466027 466212 466263 468110 468664 470154 470927 472128 476439 479025 481124 481286 485159 490884 491991 497915 505333 509897 512916 514188 519742 520211 525193 525397 527713 528265 539288 546941 546945 546955 559552 560063 560395 563188 563200 565733 565976 567755 570646 573000 576690 576701 576728 579617 582393 597799 606043 616292 619450 619491 621663 637106 637421 637522 641778 643121 648220 651693 661568 674216 679396 696985 705173 709411 720273 721721 722512 724305 736489 740792 741187 741294 741906 757105 760963 766831 769923 777054 785355 789968 796805 805023 809902 814138 818868 821532 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (8.05%) |
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 563200 565976 560395 661568 709411 679396 696985 720273 546941 597799 641778 606043 637522 643121 637106 796805 740792 741906 736489 619491 721721 386578 403317 431337 406339 411389 459795 411406 411470 411392 448398 491991 413642 429086 497915 579617 805023 741294 461271 470154 514188 452604 520211 757105 766831 741187 468110 519742 814138 674216 563188 777054 785355 705173 476439 466027 525193 525397 512916 465607 546945 651693 619450 789968 769923 453714 453036 462021 465763 401559 418215 470927 472128 509897 490884 485159 527713 724305 576701 621663 425106 407279 818868 505333 570646 567755 573000 576728 78307 481286 21500 479025 468664 582393 760963 616292 722512 481124 428133 576690 648220 637421 809902 466212 383226 448864 546955 559552 560063 565733 466263 528265 539288 213057 413503 420106 436883 821532 458062 452163 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.66%) |
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 21500 78307 213057 383226 386578 401559 403317 406339 407279 411389 411392 411406 411470 413503 413642 418215 420106 425106 428133 429086 431337 436883 448398 448864 452163 452604 453036 453714 458062 459795 461271 462021 465607 465763 466027 466212 466263 468110 468664 470154 470927 472128 476439 479025 481124 481286 485159 490884 491991 497915 505333 509897 512916 514188 519742 520211 525193 525397 527713 528265 539288 546941 546945 546955 559552 560063 560395 563188 563200 565733 565976 567755 570646 573000 576690 576701 576728 579617 582393 597799 606043 616292 619450 619491 621663 637106 637421 637522 641778 643121 648220 651693 661568 674216 679396 696985 705173 709411 720273 721721 722512 724305 736489 740792 741187 741294 741906 757105 760963 766831 769923 777054 785355 789968 796805 805023 809902 814138 818868 821532 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose жоп лиза"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose ass licking"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose жоп лиза"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.