Query Metrics
7
Database Queries
7
Different statements
144.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.36 ms (82.44%) |
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 66907 276696 358449 381882 384878 384911 394204 394420 396527 398950 400888 400990 403216 403317 407570 411347 411389 411392 411398 411406 412303 416305 421007 422592 422652 422863 423040 423071 423242 424463 424740 432418 432663 433490 436444 439569 439576 440964 443018 443669 451243 453156 453429 453435 463710 466987 467048 470925 470959 471713 474161 479055 479124 482324 482511 489661 490202 490895 490903 492001 502212 515644 516002 521773 522478 524089 525118 525193 529184 531531 534279 544504 546937 547909 550437 550643 554524 555546 558614 559066 560389 560394 560395 562981 563133 563200 563213 563483 568100 569426 575716 581843 582548 584114 606738 620198 621504 628366 637134 638985 652358 666540 666550 669771 696985 709748 710282 730735 733855 740792 770152 770179 789693 792135 802460 807558 814235 816086 820529 826592 ] |
||||||||||||||||||||||||||||||
|
16.29 ms (11.25%) |
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 443018 816086 451243 466987 524089 529184 550437 581843 666540 709748 666550 563133 621504 637134 606738 638985 807558 733855 396527 440964 479055 422863 489661 490202 515644 384911 276696 66907 400888 403216 424740 439569 416305 826592 453435 463710 546937 554524 555546 560394 563483 582548 563200 584114 550643 560395 669771 696985 563213 789693 792135 802460 730735 740792 770179 770152 710282 381882 394204 400990 432418 453156 358449 394420 403317 436444 479124 384878 411389 411398 424463 482324 398950 411347 411406 412303 443669 470925 470959 411392 433490 439576 453429 490895 490903 516002 492001 525118 522478 422592 423040 422652 814235 467048 558614 575716 620198 628366 423071 421007 423242 407570 432663 820529 482511 474161 525193 534279 502212 531531 521773 471713 560389 544504 547909 559066 562981 568100 569426 652358 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.85%) |
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 66907 276696 358449 381882 384878 384911 394204 394420 396527 398950 400888 400990 403216 403317 407570 411347 411389 411392 411398 411406 412303 416305 421007 422592 422652 422863 423040 423071 423242 424463 424740 432418 432663 433490 436444 439569 439576 440964 443018 443669 451243 453156 453429 453435 463710 466987 467048 470925 470959 471713 474161 479055 479124 482324 482511 489661 490202 490895 490903 492001 502212 515644 516002 521773 522478 524089 525118 525193 529184 531531 534279 544504 546937 547909 550437 550643 554524 555546 558614 559066 560389 560394 560395 562981 563133 563200 563213 563483 568100 569426 575716 581843 582548 584114 606738 620198 621504 628366 637134 638985 652358 666540 666550 669771 696985 709748 710282 730735 733855 740792 770152 770179 789693 792135 802460 807558 814235 816086 820529 826592 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose young"
]
|
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.