Query Metrics
7
Database Queries
7
Different statements
510.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
484.29 ms (94.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 400849 414369 420178 425724 430297 430707 431643 443637 444913 444940 445607 445935 450171 453125 453190 453242 454227 454447 458000 458761 459476 460294 460969 461731 462818 463152 464336 464359 465571 465698 467029 468900 470041 474089 475592 476229 476260 476339 476619 483448 488439 489272 490304 491164 491411 491865 494282 494289 496017 496662 506345 507643 509842 510425 513583 514843 515350 515952 520143 523169 524903 525468 525479 527415 527418 527885 529378 530745 531539 532630 536481 536491 537098 544834 550220 551115 560123 563732 568365 568982 568989 569098 571102 571823 575924 577211 578198 580642 580744 582444 585746 590870 591942 592951 592985 594207 603217 603264 610293 614742 621787 640314 651609 654634 663427 663490 664837 665110 665113 666776 666784 667554 667644 675515 678764 695163 696513 748128 771482 781914 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (3.29%) |
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 654634 663427 667644 696513 665113 550220 560123 580642 592985 621787 640314 590870 594207 748128 771482 781914 444913 476229 465571 420178 470041 476619 450171 458000 468900 425724 430297 459476 460294 506345 483448 489272 513583 525468 491865 431643 414369 443637 430707 445935 453125 453242 454227 464336 453190 454447 461731 465698 445607 462818 476260 515350 515952 525479 527418 529378 520143 531539 532630 536491 494289 496017 496662 514843 474089 491411 563732 569098 577211 582444 568365 578198 568982 580744 664837 665110 651609 663490 666776 667554 544834 568989 575924 591942 592951 585746 603217 603264 610293 614742 475592 463152 467029 400849 476339 444940 460969 488439 509842 510425 491164 527885 458761 490304 523169 527415 507643 537098 494282 536481 524903 530745 464359 571102 551115 675515 678764 666784 695163 571823 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.53%) |
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 400849 414369 420178 425724 430297 430707 431643 443637 444913 444940 445607 445935 450171 453125 453190 453242 454227 454447 458000 458761 459476 460294 460969 461731 462818 463152 464336 464359 465571 465698 467029 468900 470041 474089 475592 476229 476260 476339 476619 483448 488439 489272 490304 491164 491411 491865 494282 494289 496017 496662 506345 507643 509842 510425 513583 514843 515350 515952 520143 523169 524903 525468 525479 527415 527418 527885 529378 530745 531539 532630 536481 536491 537098 544834 550220 551115 560123 563732 568365 568982 568989 569098 571102 571823 575924 577211 578198 580642 580744 582444 585746 590870 591942 592951 592985 594207 603217 603264 610293 614742 621787 640314 651609 654634 663427 663490 664837 665110 665113 666776 666784 667554 667644 675515 678764 695163 696513 748128 771482 781914 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw hair"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw hair"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw hair"
]
|
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.