Query Metrics
7
Database Queries
7
Different statements
178.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.40 ms (86.55%) |
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 117221 191575 314541 389765 390538 393314 398492 401840 431405 446359 455611 513106 527627 533867 549856 551992 558843 562535 569202 573761 574247 576359 581355 581676 581890 583947 583985 583995 585102 590188 591192 596464 597269 600366 601512 601994 603172 603181 603242 604383 604844 606472 606560 607108 610847 614186 614407 617620 623519 626310 630234 630679 630857 632607 633776 636070 638633 641928 649543 650808 651062 651855 651856 653943 670040 670965 671334 671354 673353 673357 674128 675951 679441 679453 680202 681867 682508 684126 692506 696355 696998 697025 699694 700659 711891 716577 720050 721538 724179 729881 733877 737521 745550 746994 775810 775834 775862 775966 775971 775988 784111 784151 784254 784308 786007 789711 795139 798411 801942 801975 805275 805387 807390 807692 808511 808730 809493 809525 811486 824130 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (8.15%) |
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 569202 549856 551992 573761 581676 583985 574247 650808 651062 670040 679453 680202 682508 699694 651855 651856 653943 670965 671354 696998 716577 671334 673357 674128 681867 697025 720050 721538 558843 576359 581890 600366 601994 606472 590188 604844 630857 591192 596464 597269 614186 633776 603181 630234 630679 775834 784111 805275 807390 775862 786007 801942 801975 805387 733877 737521 729881 746994 601512 604383 623519 626310 632607 636070 789711 401840 446359 455611 191575 389765 390538 527627 513106 585102 562535 393314 314541 117221 398492 431405 824130 533867 581355 673353 700659 675951 692506 696355 711891 649543 679441 684126 583947 583995 603242 606560 610847 638633 607108 617620 603172 614407 641928 775810 775966 775971 775988 784254 808511 808730 809493 809525 798411 745550 784151 784308 795139 807692 811486 724179 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.68%) |
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 117221 191575 314541 389765 390538 393314 398492 401840 431405 446359 455611 513106 527627 533867 549856 551992 558843 562535 569202 573761 574247 576359 581355 581676 581890 583947 583985 583995 585102 590188 591192 596464 597269 600366 601512 601994 603172 603181 603242 604383 604844 606472 606560 607108 610847 614186 614407 617620 623519 626310 630234 630679 630857 632607 633776 636070 638633 641928 649543 650808 651062 651855 651856 653943 670040 670965 671334 671354 673353 673357 674128 675951 679441 679453 680202 681867 682508 684126 692506 696355 696998 697025 699694 700659 711891 716577 720050 721538 724179 729881 733877 737521 745550 746994 775810 775834 775862 775966 775971 775988 784111 784151 784254 784308 786007 789711 795139 798411 801942 801975 805275 805387 807390 807692 808511 808730 809493 809525 811486 824130 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.75%) |
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.