Query Metrics
8
Database Queries
8
Different statements
148.04 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.90 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum on pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.98 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”Pñö¬pY¨2f4k~p¹"
]
|
||||||||||||||||||||||||||||||
| 4 | 14.14 ms |
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 725062 751920 768615 738818 727593 734587 738353 744919 770359 612498 615686 779666 792188 792700 794396 811961 463394 436732 558472 433386 442467 456685 496252 689937 696116 646246 595069 591461 741185 728523 764005 783112 420315 444814 503891 527477 401960 441971 814395 455177 489251 528598 510507 510931 532299 505389 507214 518642 560522 566184 578745 707524 680822 684511 695048 700028 546890 553896 604243 591732 592298 610510 617606 807478 734252 741655 807462 808884 725203 730800 741935 742149 769513 726941 728255 756659 771922 699836 803309 462172 424918 451494 478275 483888 492992 508799 458313 623972 435043 460410 499964 506246 489829 398380 428082 444843 429611 454037 487051 453993 488982 449506 449511 452962 453043 454034 520939 522278 539360 502010 522277 490707 541015 546221 549658 542069 546426 552591 562482 563300 ] |
||||||||||||||||||||||||||||||
| 5 | 3.02 ms |
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 398380 401960 420315 424918 428082 429611 433386 435043 436732 441971 442467 444814 444843 449506 449511 451494 452962 453043 453993 454034 454037 455177 456685 458313 460410 462172 463394 478275 483888 487051 488982 489251 489829 490707 492992 496252 499964 502010 503891 505389 506246 507214 508799 510507 510931 518642 520939 522277 522278 527477 528598 532299 539360 541015 542069 546221 546426 546890 549658 552591 553896 558472 560522 562482 563300 566184 578745 591461 591732 592298 595069 604243 610510 612498 615686 617606 623972 646246 680822 684511 689937 695048 696116 699836 700028 707524 725062 725203 726941 727593 728255 728523 730800 734252 734587 738353 738818 741185 741655 741935 742149 744919 751920 756659 764005 768615 769513 770359 771922 779666 783112 792188 792700 794396 803309 807462 807478 808884 811961 814395 ] |
||||||||||||||||||||||||||||||
| 6 | 122.24 ms |
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 398380 401960 420315 424918 428082 429611 433386 435043 436732 441971 442467 444814 444843 449506 449511 451494 452962 453043 453993 454034 454037 455177 456685 458313 460410 462172 463394 478275 483888 487051 488982 489251 489829 490707 492992 496252 499964 502010 503891 505389 506246 507214 508799 510507 510931 518642 520939 522277 522278 527477 528598 532299 539360 541015 542069 546221 546426 546890 549658 552591 553896 558472 560522 562482 563300 566184 578745 591461 591732 592298 595069 604243 610510 612498 615686 617606 623972 646246 680822 684511 689937 695048 696116 699836 700028 707524 725062 725203 726941 727593 728255 728523 730800 734252 734587 738353 738818 741185 741655 741935 742149 744919 751920 756659 764005 768615 769513 770359 771922 779666 783112 792188 792700 794396 803309 807462 807478 808884 811961 814395 ] |
||||||||||||||||||||||||||||||
| 7 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.32 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum pussy"
]
|
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.