Query Metrics
7
Database Queries
7
Different statements
699.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
419.52 ms (59.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian teen fuck"
]
|
||||||||||||||||||||||||||||||
|
255.76 ms (36.56%) |
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 373852 382381 385710 388512 395249 395597 395664 401344 402266 405990 406134 414048 416138 418009 418332 418706 420192 420613 420621 422511 422513 422543 422550 422561 422572 422591 422592 422649 422657 422661 422671 422879 422901 422908 422923 422926 422953 422958 422985 423007 423025 423263 423266 429385 433152 435727 445252 453019 456622 456642 456700 459232 460710 475799 477216 478025 478452 482621 488379 491354 497444 502466 508962 511249 511260 511264 512189 512224 537201 542542 542553 543501 543823 543919 545508 551973 559093 560216 562872 564066 564778 565344 571824 583397 584550 585390 585761 585967 586623 586886 590935 592380 600460 600560 601200 602581 604319 605380 619451 622521 636288 637168 647619 651561 651620 658163 659269 699820 701744 713550 722519 741109 744090 744704 748686 758728 761005 800415 816079 823245 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (2.45%) |
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 491354 475799 542542 542553 823245 602581 405990 560216 559093 422901 422511 478025 395597 604319 423007 422649 423025 600460 637168 601200 423263 453019 422543 478452 744090 422561 422879 422572 508962 562872 651620 761005 422923 543501 592380 800415 422657 512224 511260 565344 622521 418706 395249 701744 418332 511264 571824 583397 585967 402266 488379 543919 418009 395664 586623 420192 422926 600560 422671 433152 414048 482621 545508 564066 748686 477216 422958 422592 619451 586886 722519 502466 658163 713550 585761 445252 564778 382381 512189 511249 435727 816079 758728 699820 388512 422513 385710 459232 543823 460710 584550 741109 373852 605380 422591 420613 659269 590935 429385 401344 422550 422908 537201 636288 456642 416138 422953 456700 551973 456622 420621 647619 651561 744704 422985 423266 406134 422661 497444 585390 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (0.48%) |
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 373852 382381 385710 388512 395249 395597 395664 401344 402266 405990 406134 414048 416138 418009 418332 418706 420192 420613 420621 422511 422513 422543 422550 422561 422572 422591 422592 422649 422657 422661 422671 422879 422901 422908 422923 422926 422953 422958 422985 423007 423025 423263 423266 429385 433152 435727 445252 453019 456622 456642 456700 459232 460710 475799 477216 478025 478452 482621 488379 491354 497444 502466 508962 511249 511260 511264 512189 512224 537201 542542 542553 543501 543823 543919 545508 551973 559093 560216 562872 564066 564778 565344 571824 583397 584550 585390 585761 585967 586623 586886 590935 592380 600460 600560 601200 602581 604319 605380 619451 622521 636288 637168 647619 651561 651620 658163 659269 699820 701744 713550 722519 741109 744090 744704 748686 758728 761005 800415 816079 823245 ] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк teen секс"
]
|
||||||||||||||||||||||||||||||
|
1.11 ms (0.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк teen секс"
]
|
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.