Query Metrics
7
Database Queries
7
Different statements
157.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.98 ms (81.12%) |
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 75852 95700 191487 382928 383075 386596 387218 388713 390820 395499 396560 397849 399058 399354 399355 399358 399414 401728 402876 402885 403579 404264 404320 405848 411477 413235 417074 417441 417929 419595 420094 421328 425694 429181 430535 433580 440687 443662 445017 445050 445741 450774 451637 453202 453235 457166 460328 462742 463262 464350 464604 468006 468008 469985 471425 472151 472448 473094 480417 481582 481672 483734 486674 488383 489217 489844 494349 494365 499333 499334 499668 500665 502048 503241 503426 505090 508421 508775 516655 518935 519085 519105 520213 521593 524505 525663 526669 529268 531248 532877 533002 533931 536542 546861 555814 577353 584230 585328 592687 596001 601101 604451 604503 606599 606838 625448 625752 630266 632261 634115 644917 645010 647972 650764 660739 680198 689005 702634 755030 805429 ] |
||||||||||||||||||||||||||||||
|
18.83 ms (11.94%) |
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 395499 464604 471425 382928 399358 401728 402885 425694 481582 500665 489844 494349 502048 505090 519105 396560 399354 402876 430535 440687 419595 433580 443662 453235 460328 468008 445741 488383 473094 499333 499334 508775 532877 494365 521593 526669 533002 503241 508421 516655 462742 483734 577353 584230 660739 680198 650764 689005 702634 555814 585328 604451 606599 625448 592687 604503 596001 625752 805429 755030 606838 630266 75852 404320 463262 469985 480417 413235 417074 386596 399355 399414 420094 421328 445050 468006 503426 499668 519085 525663 601101 546861 647972 634115 632261 417929 95700 383075 191487 388713 387218 390820 397849 399058 404264 405848 403579 445017 429181 411477 417441 644917 645010 453202 464350 457166 472151 472448 481672 486674 489217 450774 451637 518935 536542 520213 529268 531248 533931 524505 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.10%) |
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 75852 95700 191487 382928 383075 386596 387218 388713 390820 395499 396560 397849 399058 399354 399355 399358 399414 401728 402876 402885 403579 404264 404320 405848 411477 413235 417074 417441 417929 419595 420094 421328 425694 429181 430535 433580 440687 443662 445017 445050 445741 450774 451637 453202 453235 457166 460328 462742 463262 464350 464604 468006 468008 469985 471425 472151 472448 473094 480417 481582 481672 483734 486674 488383 489217 489844 494349 494365 499333 499334 499668 500665 502048 503241 503426 505090 508421 508775 516655 518935 519085 519105 520213 521593 524505 525663 526669 529268 531248 532877 533002 533931 536542 546861 555814 577353 584230 585328 592687 596001 601101 604451 604503 606599 606838 625448 625752 630266 632261 634115 644917 645010 647972 650764 660739 680198 689005 702634 755030 805429 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock bbc"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock bbc"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock bbc"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.