Query Metrics
7
Database Queries
7
Different statements
146.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.04 ms (82.04%) |
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 186993 384532 386728 387599 395459 407762 408961 417173 417265 423481 423880 429086 430014 438959 439484 441334 443055 445747 448647 451870 454336 455386 458634 461512 465369 465741 466573 467680 470504 472560 472778 474538 475420 480248 488190 493942 500186 503018 506571 508468 510609 510864 511903 512809 514224 515791 517565 526534 531197 533807 538223 540155 540195 555082 556714 565376 565720 573293 578430 581450 589390 590480 591418 601024 603992 610097 617615 620757 621337 623508 625236 630639 633853 663321 670246 682336 689318 689595 692187 692432 692669 697180 701573 701649 702364 702446 707688 717731 719461 720618 722843 728134 732236 733048 734387 744596 748159 749889 752414 755483 762848 765640 766433 770278 776316 781980 782057 784954 785269 792188 795267 795497 806414 808044 809516 810811 811271 813482 813894 825686 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (9.86%) |
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 732236 455386 825686 480248 506571 689595 692432 692669 625236 810811 785269 744596 765640 792188 795267 408961 808044 813894 458634 512809 503018 555082 692187 722843 623508 784954 766433 813482 752414 755483 701649 702446 417173 514224 620757 186993 439484 441334 417265 438959 472560 511903 540195 556714 573293 663321 670246 682336 701573 697180 717731 689318 719461 610097 590480 617615 621337 589390 776316 782057 795497 733048 748159 728134 734387 770278 749889 781980 386728 423880 395459 465369 465741 430014 445747 461512 466573 565720 630639 603992 493942 384532 407762 510864 538223 472778 474538 578430 720618 702364 707688 633853 591418 601024 806414 809516 811271 762848 443055 448647 387599 454336 526534 488190 500186 508468 540155 429086 423481 451870 470504 467680 475420 531197 515791 533807 510609 517565 581450 565376 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy sucking"
]
|
||||||||||||||||||||||||||||||
|
2.71 ms (1.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy sucking"
]
|
||||||||||||||||||||||||||||||
|
2.70 ms (1.85%) |
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 186993 384532 386728 387599 395459 407762 408961 417173 417265 423481 423880 429086 430014 438959 439484 441334 443055 445747 448647 451870 454336 455386 458634 461512 465369 465741 466573 467680 470504 472560 472778 474538 475420 480248 488190 493942 500186 503018 506571 508468 510609 510864 511903 512809 514224 515791 517565 526534 531197 533807 538223 540155 540195 555082 556714 565376 565720 573293 578430 581450 589390 590480 591418 601024 603992 610097 617615 620757 621337 623508 625236 630639 633853 663321 670246 682336 689318 689595 692187 692432 692669 697180 701573 701649 702364 702446 707688 717731 719461 720618 722843 728134 732236 733048 734387 744596 748159 749889 752414 755483 762848 765640 766433 770278 776316 781980 782057 784954 785269 792188 795267 795497 806414 808044 809516 810811 811271 813482 813894 825686 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy sucking"
]
|
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.