Query Metrics
7
Database Queries
7
Different statements
178.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.70 ms (85.16%) |
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 398447 420696 420734 420862 420879 434163 435016 437137 437296 439516 440257 440747 447225 449046 450861 451660 454966 455645 456126 456816 457129 457349 459332 460349 462292 463614 463705 463913 464305 464582 464750 469648 471759 473915 475000 476485 477156 480011 480079 486134 487650 488858 488905 489652 489702 490198 491372 493310 493933 495324 503009 506898 507107 512996 516538 517324 517625 523653 525950 526330 526353 527931 529522 534568 534571 534913 537278 537287 540247 540553 540916 546756 548023 552369 555698 557548 557744 561894 561927 569655 572683 577679 578261 583770 586427 587444 589391 590689 594380 600736 603704 609723 609759 614209 614611 617026 618239 624013 625436 628256 630328 632020 635627 644764 645270 651836 663347 710259 728087 773582 780201 807326 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (9.28%) |
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 586427 435016 451660 529522 516538 489702 710259 569655 480011 609723 471759 534568 557744 495324 555698 594380 469648 493933 455645 540916 590689 420862 780201 557548 503009 487650 475000 420734 525950 457349 517625 464582 506898 488905 583770 589391 488858 454966 587444 440257 456126 464750 534571 491372 456816 457129 523653 398447 440747 561894 773582 728087 420696 460349 537287 651836 644764 577679 609759 439516 464305 486134 572683 434163 617026 517324 537278 450861 462292 578261 540553 630328 447225 561927 614209 807326 420879 527931 437296 526330 463913 628256 463705 476485 540247 490198 489652 473915 437137 546756 477156 507107 512996 548023 625436 480079 645270 624013 603704 449046 552369 526353 463614 534913 635627 618239 459332 493310 632020 614611 600736 663347 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.53%) |
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 398447 420696 420734 420862 420879 434163 435016 437137 437296 439516 440257 440747 447225 449046 450861 451660 454966 455645 456126 456816 457129 457349 459332 460349 462292 463614 463705 463913 464305 464582 464750 469648 471759 473915 475000 476485 477156 480011 480079 486134 487650 488858 488905 489652 489702 490198 491372 493310 493933 495324 503009 506898 507107 512996 516538 517324 517625 523653 525950 526330 526353 527931 529522 534568 534571 534913 537278 537287 540247 540553 540916 546756 548023 552369 555698 557548 557744 561894 561927 569655 572683 577679 578261 583770 586427 587444 589391 590689 594380 600736 603704 609723 609759 614209 614611 617026 618239 624013 625436 628256 630328 632020 635627 644764 645270 651836 663347 710259 728087 773582 780201 807326 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"risky blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"risky минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"risky минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
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.