Query Metrics
7
Database Queries
7
Different statements
187.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.51 ms (79.29%) |
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 397508 402792 409841 416880 418594 422051 429455 434953 437861 444048 444296 445905 446449 446612 447008 448107 449722 451014 451304 451652 451788 452663 452825 453738 457192 457339 458471 458788 458957 461793 463468 463823 464608 465295 465301 465863 465889 466373 470251 471620 473789 479387 479960 481598 483495 483784 487294 488940 489073 490758 492054 493851 496169 496244 496667 498766 498855 498857 501509 501916 503794 507517 507702 512589 514076 515225 515635 518607 518634 519054 520283 520450 522735 522793 524914 525085 525590 525754 526489 527359 527555 527641 527670 536067 549729 557810 560814 561360 562793 569546 578302 578733 580414 580659 580935 586344 589174 592561 592824 592921 592958 595097 596740 599491 605194 615818 618612 626321 643489 661394 666983 680267 716927 723164 758224 762159 788252 798666 814699 814701 ] |
||||||||||||||||||||||||||||||
|
28.74 ms (15.35%) |
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 758224 626321 458788 466373 473789 457339 479387 434953 437861 409841 444296 452825 458957 461793 465889 446449 501509 514076 515225 522793 492054 501916 515635 525754 498855 526489 490758 498857 520450 402792 416880 422051 814701 814699 451014 453738 465295 488940 449722 451788 465301 445905 463823 481598 483784 503794 507517 525085 536067 519054 507702 524914 465863 549729 578302 580935 560814 562793 569546 561360 578733 666983 723164 661394 680267 716927 557810 580414 580659 589174 592561 592824 592921 592958 586344 596740 643489 595097 599491 618612 798666 788252 762159 605194 444048 458471 471620 470251 479960 429455 446612 448107 451304 447008 463468 518607 522735 527641 527670 518634 520283 496169 498766 525590 527359 527555 483495 489073 493851 496244 496667 512589 615818 397508 418594 464608 487294 451652 452663 457192 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.37%) |
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 397508 402792 409841 416880 418594 422051 429455 434953 437861 444048 444296 445905 446449 446612 447008 448107 449722 451014 451304 451652 451788 452663 452825 453738 457192 457339 458471 458788 458957 461793 463468 463823 464608 465295 465301 465863 465889 466373 470251 471620 473789 479387 479960 481598 483495 483784 487294 488940 489073 490758 492054 493851 496169 496244 496667 498766 498855 498857 501509 501916 503794 507517 507702 512589 514076 515225 515635 518607 518634 519054 520283 520450 522735 522793 524914 525085 525590 525754 526489 527359 527555 527641 527670 536067 549729 557810 560814 561360 562793 569546 578302 578733 580414 580659 580935 586344 589174 592561 592824 592921 592958 595097 596740 599491 605194 615818 618612 626321 643489 661394 666983 680267 716927 723164 758224 762159 788252 798666 814699 814701 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.83%) |
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.