Query Metrics
7
Database Queries
7
Different statements
188.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.80 ms (87.27%) |
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 108107 188390 232953 382444 386794 393102 394409 394425 398552 407792 409934 411695 424529 425215 464530 464791 469427 472676 483378 497209 499359 507263 509440 512199 517005 518828 520875 531275 531535 534003 535053 536453 543535 544489 544493 544501 544502 549799 550486 554848 555082 562567 566488 579190 581305 618757 620009 624837 632074 650519 661593 670234 680442 699625 706888 715367 717664 724233 726957 726967 727034 727047 727754 727787 727810 728541 729272 731399 734373 734489 738327 738639 740792 742407 748323 748467 752966 756233 759905 760976 763914 765547 765723 766503 766509 770208 771968 776968 781666 782470 792946 796048 796164 796276 797206 800259 802554 803722 805282 808049 811837 817347 817698 818986 823578 823613 823760 824262 824265 824359 824461 824672 825110 825243 826057 826157 826316 826880 827220 827669 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (7.89%) |
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 620009 632074 802554 738327 776968 517005 108107 469427 650519 796164 562567 543535 520875 544501 766509 766503 424529 512199 566488 425215 531535 497209 518828 409934 544489 483378 544493 544502 509440 549799 534003 742407 771968 624837 699625 808049 232953 811837 770208 464530 188390 826316 826057 618757 824265 760976 817347 536453 824461 824672 824359 727810 818986 748323 717664 706888 763914 781666 727754 740792 464791 394425 661593 782470 499359 825243 550486 765723 386794 827220 824262 800259 796276 727787 407792 726957 823578 554848 727047 728541 729272 734489 792946 731399 738639 752966 715367 823760 823613 531275 680442 734373 727034 748467 765547 394409 382444 724233 393102 398552 535053 472676 555082 579190 581305 670234 797206 796048 805282 756233 803722 726967 759905 411695 825110 826880 817698 826157 827669 507263 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.38%) |
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 108107 188390 232953 382444 386794 393102 394409 394425 398552 407792 409934 411695 424529 425215 464530 464791 469427 472676 483378 497209 499359 507263 509440 512199 517005 518828 520875 531275 531535 534003 535053 536453 543535 544489 544493 544501 544502 549799 550486 554848 555082 562567 566488 579190 581305 618757 620009 624837 632074 650519 661593 670234 680442 699625 706888 715367 717664 724233 726957 726967 727034 727047 727754 727787 727810 728541 729272 731399 734373 734489 738327 738639 740792 742407 748323 748467 752966 756233 759905 760976 763914 765547 765723 766503 766509 770208 771968 776968 781666 782470 792946 796048 796164 796276 797206 800259 802554 803722 805282 808049 811837 817347 817698 818986 823578 823613 823760 824262 824265 824359 824461 824672 825110 825243 826057 826157 826316 826880 827220 827669 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature slut"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature slut"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature slut"
]
|
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.