Query Metrics
7
Database Queries
7
Different statements
148.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.85 ms (81.83%) |
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 412716 417095 417126 418175 419277 422282 424350 424353 425554 428076 436869 437965 441714 444326 446674 448975 449545 450853 451094 453984 455047 457909 457926 458278 458293 458781 459122 459680 463379 465084 466799 480347 481756 481757 482115 485417 489658 489744 492958 495279 501543 502217 506072 509478 511924 520084 523422 526152 528585 536115 543355 545866 552533 553262 555166 558373 560179 563637 563892 566337 566743 567717 571820 577086 578182 580588 585775 586463 588190 588317 589212 594557 594560 596714 600498 603896 607034 610322 616862 617732 621485 623967 626015 626590 628948 630317 630664 666044 684695 707440 719781 724467 727673 735871 739782 742839 744184 746093 746171 757177 759690 759712 759758 759762 763590 766149 776130 779996 785188 793827 796125 796221 802291 806173 806910 807462 811337 813482 813904 815592 ] |
||||||||||||||||||||||||||||||
|
18.00 ms (12.09%) |
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 785188 763590 796125 807462 813482 759762 412716 719781 742839 744184 793827 436869 813904 453984 455047 458293 449545 506072 480347 543355 555166 666044 707440 684695 553262 578182 588317 621485 628948 585775 594557 610322 589212 802291 727673 759712 766149 739782 759758 746093 746171 757177 759690 617732 630317 779996 796221 424350 441714 446674 457926 466799 481756 458278 459122 419277 450853 481757 485417 489744 520084 815592 567717 571820 586463 811337 457909 422282 424353 444326 482115 492958 502217 526152 552533 563637 566337 577086 545866 580588 558373 563892 560179 566743 603896 616862 596714 776130 806910 724467 735871 630664 806173 428076 463379 465084 418175 425554 437965 448975 417126 528585 501543 511924 489658 509478 458781 536115 626015 623967 417095 459680 451094 495279 523422 588190 600498 594560 607034 626590 ] |
||||||||||||||||||||||||||||||
|
2.47 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 412716 417095 417126 418175 419277 422282 424350 424353 425554 428076 436869 437965 441714 444326 446674 448975 449545 450853 451094 453984 455047 457909 457926 458278 458293 458781 459122 459680 463379 465084 466799 480347 481756 481757 482115 485417 489658 489744 492958 495279 501543 502217 506072 509478 511924 520084 523422 526152 528585 536115 543355 545866 552533 553262 555166 558373 560179 563637 563892 566337 566743 567717 571820 577086 578182 580588 585775 586463 588190 588317 589212 594557 594560 596714 600498 603896 607034 610322 616862 617732 621485 623967 626015 626590 628948 630317 630664 666044 684695 707440 719781 724467 727673 735871 739782 742839 744184 746093 746171 757177 759690 759712 759758 759762 763590 766149 776130 779996 785188 793827 796125 796221 802291 806173 806910 807462 811337 813482 813904 815592 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"inside of pussy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.94%) |
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.