Query Metrics
7
Database Queries
7
Different statements
177.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.75 ms (83.62%) |
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 394532 396275 396740 397345 397350 397535 399058 399853 404234 404366 408994 414509 414516 418049 418411 418421 419149 419906 421127 425707 426041 427126 428523 428569 431028 443205 443215 443301 444823 445284 445526 445551 445821 445900 447043 447323 447340 447855 449019 451684 456254 459234 459237 463943 467844 468574 468584 468587 469656 470321 471355 473056 473094 473778 475451 475750 475989 479333 484342 489366 489370 496088 498238 506579 508534 510622 511268 516427 517727 517819 518935 521779 522905 526996 535465 540595 540918 540926 543892 545539 548046 548872 552030 552567 553920 555807 556406 561818 564827 565051 566102 569134 573873 579624 581132 584153 585373 585398 587125 592374 598252 600485 600553 600623 618373 619367 620291 624249 652121 658110 667106 693024 702404 744844 747004 747929 755743 777306 791368 827610 ] |
||||||||||||||||||||||||||||||
|
19.93 ms (11.20%) |
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 508534 535465 475750 548872 693024 652121 658110 702404 564827 565051 620291 624249 600623 600553 777306 791368 755743 747929 397345 397535 473778 445821 447043 471355 397350 419149 451684 489370 540926 667106 600485 618373 399058 443215 426041 445551 449019 459234 517819 518935 573873 414509 445526 467844 456254 414516 479333 469656 516427 498238 396740 543892 585373 404234 496088 396275 399853 418049 428523 444823 421127 443205 443301 827610 475451 445900 473094 553920 555807 581132 561818 566102 569134 584153 587125 619367 585398 592374 744844 747004 394532 445284 463943 468584 468574 468587 470321 431028 526996 540918 484342 489366 517727 522905 552030 447323 475989 404366 425707 579624 548046 428569 418411 418421 473056 598252 427126 447340 506579 419906 408994 459237 447855 510622 540595 511268 521779 545539 552567 556406 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.57%) |
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 394532 396275 396740 397345 397350 397535 399058 399853 404234 404366 408994 414509 414516 418049 418411 418421 419149 419906 421127 425707 426041 427126 428523 428569 431028 443205 443215 443301 444823 445284 445526 445551 445821 445900 447043 447323 447340 447855 449019 451684 456254 459234 459237 463943 467844 468574 468584 468587 469656 470321 471355 473056 473094 473778 475451 475750 475989 479333 484342 489366 489370 496088 498238 506579 508534 510622 511268 516427 517727 517819 518935 521779 522905 526996 535465 540595 540918 540926 543892 545539 548046 548872 552030 552567 553920 555807 556406 561818 564827 565051 566102 569134 573873 579624 581132 584153 585373 585398 587125 592374 598252 600485 600553 600623 618373 619367 620291 624249 652121 658110 667106 693024 702404 744844 747004 747929 755743 777306 791368 827610 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny tiny tits"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые tiny сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые tiny сиськ"
]
|
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.