Query Metrics
7
Database Queries
7
Different statements
196.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.98 ms (87.88%) |
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 191487 239677 249637 328534 382411 386304 392458 394751 395833 396560 396609 397849 399058 399352 399414 400753 401203 401724 401728 402657 402664 403579 404264 404829 405507 409080 412949 413235 414098 415097 421435 425992 429181 433694 433745 445017 448692 449868 457145 463262 466968 467324 472151 473094 474852 475698 477396 483734 491977 494365 502562 503828 505690 513290 516686 523367 524863 529286 532441 533480 534237 536932 538428 549977 560184 562128 564608 565100 565149 568600 571269 575020 575197 576415 580706 586463 586631 590244 593394 604083 607101 607152 607215 617130 624831 626138 627740 630227 630266 630292 635948 639131 645010 650793 657865 672140 675008 689005 718203 725115 727801 730466 737910 738855 743159 747004 781697 789692 790983 803091 803321 807621 813388 821844 821848 823929 825039 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.56%) |
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 624831 607152 607101 617130 790983 803091 807621 813388 730466 737910 725115 738855 607215 635948 718203 45605 41516 402657 491977 586631 675008 575197 239677 145646 394751 392458 382411 399352 401724 421435 821844 821848 823929 523367 536932 533480 568600 564608 575020 657865 650793 593394 639131 586463 626138 630292 590244 627740 781697 803321 727801 743159 630227 789692 409080 467324 401728 402664 191487 396560 397849 399058 404264 403579 412949 445017 425992 429181 415097 645010 825039 472151 477396 448692 473094 474852 503828 494365 524863 538428 505690 483734 571269 580706 672140 689005 549977 560184 604083 747004 630266 463262 395833 413235 249637 404829 399414 475698 513290 502562 516686 386304 328534 396609 400753 401203 405507 433694 433745 414098 449868 466968 457145 532441 529286 534237 565100 576415 565149 562128 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.15%) |
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 191487 239677 249637 328534 382411 386304 392458 394751 395833 396560 396609 397849 399058 399352 399414 400753 401203 401724 401728 402657 402664 403579 404264 404829 405507 409080 412949 413235 414098 415097 421435 425992 429181 433694 433745 445017 448692 449868 457145 463262 466968 467324 472151 473094 474852 475698 477396 483734 491977 494365 502562 503828 505690 513290 516686 523367 524863 529286 532441 533480 534237 536932 538428 549977 560184 562128 564608 565100 565149 568600 571269 575020 575197 576415 580706 586463 586631 590244 593394 604083 607101 607152 607215 617130 624831 626138 627740 630227 630266 630292 635948 639131 645010 650793 657865 672140 675008 689005 718203 725115 727801 730466 737910 738855 743159 747004 781697 789692 790983 803091 803321 807621 813388 821844 821848 823929 825039 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black old"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black old"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black old"
]
|
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.