Query Metrics
7
Database Queries
7
Different statements
147.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.52 ms (82.25%) |
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 395406 396358 399414 400912 400946 404368 405054 409921 411320 414110 414342 416820 420182 422785 426032 426301 429424 429770 431446 433745 435624 436031 436037 436044 437526 445941 448823 457751 461624 463262 468006 471811 476409 478033 480420 486696 488551 492338 497470 497550 503105 507887 512329 512453 512830 514797 514798 521970 524183 530017 530060 530385 530623 531198 533376 535582 536292 536580 536712 538881 540595 542591 543865 550198 550210 552703 556051 557136 560184 562263 563654 565277 565413 565414 568058 570748 572042 573238 576030 576344 583724 585994 591612 592038 593167 597997 597999 599885 599923 600253 601514 601623 601637 604470 609682 612844 622682 623203 627805 627814 628082 628085 631947 637113 642044 644940 646920 648560 648846 650158 650333 666868 674943 679317 714464 720381 720393 732574 747004 761004 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (11.11%) |
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 720381 720393 550210 560184 565414 597999 599923 612844 593167 604470 732574 747004 400912 436031 463262 426301 445941 471811 395406 436037 399414 422785 468006 512329 507887 521970 486696 497470 497550 512830 666868 674943 642044 476409 530060 530017 627814 524183 650158 591612 623203 400946 404368 405054 426032 433745 437526 409921 414342 416820 429770 435624 644940 492338 448823 457751 530385 535582 540595 503105 533376 536580 514798 538881 530623 531198 536292 543865 552703 542591 550198 562263 570748 572042 576344 583724 556051 557136 563654 576030 646920 648846 650333 714464 679317 565413 568058 573238 599885 601514 631947 597997 600253 637113 585994 592038 601623 601637 609682 627805 761004 622682 628085 396358 436044 478033 480420 414110 429424 420182 461624 411320 512453 514797 488551 536712 648560 431446 565277 628082 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teen bbc"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.67%) |
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 395406 396358 399414 400912 400946 404368 405054 409921 411320 414110 414342 416820 420182 422785 426032 426301 429424 429770 431446 433745 435624 436031 436037 436044 437526 445941 448823 457751 461624 463262 468006 471811 476409 478033 480420 486696 488551 492338 497470 497550 503105 507887 512329 512453 512830 514797 514798 521970 524183 530017 530060 530385 530623 531198 533376 535582 536292 536580 536712 538881 540595 542591 543865 550198 550210 552703 556051 557136 560184 562263 563654 565277 565413 565414 568058 570748 572042 573238 576030 576344 583724 585994 591612 592038 593167 597997 597999 599885 599923 600253 601514 601623 601637 604470 609682 612844 622682 623203 627805 627814 628082 628085 631947 637113 642044 644940 646920 648560 648846 650158 650333 666868 674943 679317 714464 720381 720393 732574 747004 761004 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen bbc"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teen bbc"
]
|
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.