Query Metrics
7
Database Queries
7
Different statements
156.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.46 ms (81.24%) |
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 75762 114360 124361 233353 237293 350425 384262 391940 395881 400470 407876 408249 408464 411710 411985 413053 413827 418969 425249 427543 437176 439607 441022 444542 445903 453156 457971 458327 458651 459579 460141 464446 472531 473316 477908 478832 486556 495665 496049 504214 504846 512973 529846 537199 538031 544381 547974 550379 553442 555750 555793 556030 556427 556653 558037 560195 560202 560411 560429 564180 565254 568580 574451 580216 582790 584234 587311 587885 598042 600856 601381 608534 609147 612856 614718 614867 614980 619536 619987 628391 628396 630524 633114 633733 637004 637427 640770 644192 667679 694967 695107 698124 718091 720614 726520 726529 727022 746722 747597 764333 770462 772100 772113 779224 779346 781761 786277 790234 790804 794933 797264 803081 804099 804609 807332 807334 814235 816776 817398 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (11.33%) |
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 473316 459579 477908 425249 504214 384262 114360 124361 237293 395881 350425 75762 400470 408249 408464 411985 411710 816776 817398 464446 538031 496049 486556 584234 550379 556653 564180 553442 555750 558037 560411 580216 667679 695107 694967 718091 720614 555793 574451 587885 600856 619987 644192 614718 619536 804609 779346 781761 804099 807332 807334 726520 746722 769103 790804 794933 803081 772100 772113 726529 747597 727022 764333 770462 614980 779224 786277 797264 413053 453156 460141 407876 437176 458651 233353 391940 457971 418969 504846 814235 445903 529846 544381 565254 547974 560195 560202 568580 582790 598042 601381 609147 614867 633733 628391 637004 640770 790234 633114 441022 413827 439607 472531 478832 444542 512973 427543 698124 458327 495665 537199 560429 556030 556427 587311 608534 630524 637427 612856 628396 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (2.43%) |
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 75762 114360 124361 233353 237293 350425 384262 391940 395881 400470 407876 408249 408464 411710 411985 413053 413827 418969 425249 427543 437176 439607 441022 444542 445903 453156 457971 458327 458651 459579 460141 464446 472531 473316 477908 478832 486556 495665 496049 504214 504846 512973 529846 537199 538031 544381 547974 550379 553442 555750 555793 556030 556427 556653 558037 560195 560202 560411 560429 564180 565254 568580 574451 580216 582790 584234 587311 587885 598042 600856 601381 608534 609147 612856 614718 614867 614980 619536 619987 628391 628396 630524 633114 633733 637004 637427 640770 644192 667679 694967 695107 698124 718091 720614 726520 726529 727022 746722 747597 764333 770462 772100 772113 779224 779346 781761 786277 790234 790804 794933 797264 803081 804099 804609 807332 807334 814235 816776 817398 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard young"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard young"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard 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.