Query Metrics
7
Database Queries
7
Different statements
435.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
280.74 ms (64.53%) |
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 547933 549776 566619 566625 568519 559063 559064 567384 567431 581618 649614 663546 682839 546943 549353 551038 552280 557991 561026 563432 567397 572533 587797 600341 622356 625279 584250 571650 547607 558009 581370 544280 544116 699546 709052 586294 592460 748551 567951 542190 558172 576643 560076 584004 691186 581341 582342 619379 644005 590693 606056 619076 473242 460903 515014 567393 568185 541293 572176 560452 622978 466969 543584 549765 584244 551939 652561 670040 709624 563201 611365 576678 583387 544113 690803 646895 571240 580286 606778 622976 593294 641370 603147 634746 615757 566370 546774 749455 563418 541408 546993 563537 606782 601853 620157 489468 418978 542934 563196 583832 563431 672805 597152 748349 581296 566304 525745 563198 572541 570394 550232 622833 733378 622831 565351 601851 617641 561028 549767 567425 ] |
||||||||||||||||||||||||||||||
|
145.48 ms (33.44%) |
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 418978 460903 466969 473242 489468 515014 525745 541293 541408 542190 542934 543584 544113 544116 544280 546774 546943 546993 547607 547933 549353 549765 549767 549776 550232 551038 551939 552280 557991 558009 558172 559063 559064 560076 560452 561026 561028 563196 563198 563201 563418 563431 563432 563537 565351 566304 566370 566619 566625 567384 567393 567397 567425 567431 567951 568185 568519 570394 571240 571650 572176 572533 572541 576643 576678 580286 581296 581341 581370 581618 582342 583387 583832 584004 584244 584250 586294 587797 590693 592460 593294 597152 600341 601851 601853 603147 606056 606778 606782 611365 615757 617641 619076 619379 620157 622356 622831 622833 622976 622978 625279 634746 641370 644005 646895 649614 652561 663546 670040 672805 682839 690803 691186 699546 709052 709624 733378 748349 748551 749455 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro wife"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.46%) |
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 418978 460903 466969 473242 489468 515014 525745 541293 541408 542190 542934 543584 544113 544116 544280 546774 546943 546993 547607 547933 549353 549765 549767 549776 550232 551038 551939 552280 557991 558009 558172 559063 559064 560076 560452 561026 561028 563196 563198 563201 563418 563431 563432 563537 565351 566304 566370 566619 566625 567384 567393 567397 567425 567431 567951 568185 568519 570394 571240 571650 572176 572533 572541 576643 576678 580286 581296 581341 581370 581618 582342 583387 583832 584004 584244 584250 586294 587797 590693 592460 593294 597152 600341 601851 601853 603147 606056 606778 606782 611365 615757 617641 619076 619379 620157 622356 622831 622833 622976 622978 625279 634746 641370 644005 646895 649614 652561 663546 670040 672805 682839 690803 691186 699546 709052 709624 733378 748349 748551 749455 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр жен"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр жен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.34%) |
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.