Query Metrics
7
Database Queries
7
Different statements
164.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.04 ms (82.09%) |
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 395499 404349 415435 415735 420478 421360 422548 423561 423987 424643 427368 428262 429229 429543 429635 429939 431671 432317 432800 434345 434716 443333 443428 445623 445825 445880 445938 446972 447257 449679 451729 459819 465575 466698 467381 467889 468565 470786 473045 473256 477926 477989 482239 483340 484573 484981 488361 492572 492815 495673 497007 497831 501295 502302 507879 510254 510816 511819 517221 520534 520738 521812 534047 536853 541582 543228 544523 544571 545860 551976 556314 556490 557993 558617 559873 559926 562375 562824 564827 565023 565051 565473 566345 566863 571217 572738 574049 574216 574467 574642 576705 576830 578295 579135 583267 583501 583541 584337 584983 585249 586015 590258 590992 592388 592481 592486 596373 603144 605330 605347 606732 606824 609182 641362 644657 659370 663381 668936 720033 732899 ] |
||||||||||||||||||||||||||||||
|
18.57 ms (11.29%) |
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 420478 431671 429229 466698 470786 473045 429939 459819 465575 590992 422548 434716 446972 451729 502302 511819 521812 501295 536853 468565 559926 574642 576830 551976 583501 584337 541582 543228 544523 566345 574467 576705 663381 668936 659370 545860 562824 565473 572738 574216 585249 592388 603144 605330 732899 606824 644657 415435 432800 477926 477989 395499 429543 473256 429635 484573 488361 483340 497831 492572 432317 415735 584983 447257 445623 445880 467381 482239 492815 495673 497007 520534 534047 517221 507879 510816 544571 558617 565023 556314 556490 562375 557993 571217 574049 579135 583267 583541 720033 559873 564827 565051 566863 578295 586015 590258 592481 592486 606732 609182 596373 641362 605347 404349 443428 467889 423987 445938 484981 520738 428262 510254 424643 421360 423561 434345 427368 443333 445825 449679 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.21%) |
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 395499 404349 415435 415735 420478 421360 422548 423561 423987 424643 427368 428262 429229 429543 429635 429939 431671 432317 432800 434345 434716 443333 443428 445623 445825 445880 445938 446972 447257 449679 451729 459819 465575 466698 467381 467889 468565 470786 473045 473256 477926 477989 482239 483340 484573 484981 488361 492572 492815 495673 497007 497831 501295 502302 507879 510254 510816 511819 517221 520534 520738 521812 534047 536853 541582 543228 544523 544571 545860 551976 556314 556490 557993 558617 559873 559926 562375 562824 564827 565023 565051 565473 566345 566863 571217 572738 574049 574216 574467 574642 576705 576830 578295 579135 583267 583501 583541 584337 584983 585249 586015 590258 590992 592388 592481 592486 596373 603144 605330 605347 606732 606824 609182 641362 644657 659370 663381 668936 720033 732899 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy skinny fuck"
]
|
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.