Query Metrics
7
Database Queries
7
Different statements
257.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.12 ms (88.90%) |
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 41516 45605 145646 154410 239677 328446 328534 386304 390413 394751 395833 396527 396560 399058 399414 399876 401728 402657 402664 404264 405504 405954 409080 413235 414026 414098 414651 417865 419403 419751 421537 433694 433745 445017 445345 457145 462470 463262 467163 467324 469287 473094 475698 475703 477396 480439 483734 484786 484954 491977 494365 495269 495270 499274 499886 500551 502562 513290 523367 526188 529286 534237 543872 546977 559187 560184 562128 563478 564776 565096 565100 568053 573926 575020 575197 575734 576415 577377 579358 580706 584488 586631 599996 601114 604507 613170 622682 625450 626138 626603 630227 630266 630292 633798 645010 650385 650793 650955 663895 669771 672140 675008 689005 714464 720938 721060 729911 743159 747004 781697 789692 790983 803091 803321 806089 807621 811826 814512 815852 823929 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (7.21%) |
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 743159 630227 467324 154410 811826 565100 622682 405504 586631 469287 663895 396560 399058 404264 445017 645010 477396 473094 494365 483734 580706 672140 689005 560184 747004 630266 463262 395833 413235 399414 475698 513290 502562 405954 417865 499274 721060 806089 675008 575197 328446 414026 815852 814512 546977 563478 669771 790983 803091 807621 45605 41516 402657 491977 386304 328534 433694 433745 414098 457145 529286 534237 576415 562128 564776 714464 650955 575734 577377 613170 626603 729911 720938 390413 475703 495269 495270 584488 419751 421537 484954 526188 467163 579358 543872 650385 565096 604507 625450 599996 601114 633798 396527 445345 480439 484786 499886 500551 419403 239677 145646 394751 823929 523367 575020 650793 626138 630292 781697 803321 789692 409080 401728 402664 399876 414651 462470 568053 559187 573926 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.98%) |
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 41516 45605 145646 154410 239677 328446 328534 386304 390413 394751 395833 396527 396560 399058 399414 399876 401728 402657 402664 404264 405504 405954 409080 413235 414026 414098 414651 417865 419403 419751 421537 433694 433745 445017 445345 457145 462470 463262 467163 467324 469287 473094 475698 475703 477396 480439 483734 484786 484954 491977 494365 495269 495270 499274 499886 500551 502562 513290 523367 526188 529286 534237 543872 546977 559187 560184 562128 563478 564776 565096 565100 568053 573926 575020 575197 575734 576415 577377 579358 580706 584488 586631 599996 601114 604507 613170 622682 625450 626138 626603 630227 630266 630292 633798 645010 650385 650793 650955 663895 669771 672140 675008 689005 714464 720938 721060 729911 743159 747004 781697 789692 790983 803091 803321 806089 807621 811826 814512 815852 823929 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black old young"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black old young"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black old 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.