Query Metrics
7
Database Queries
7
Different statements
160.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.93 ms (83.70%) |
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 402724 415618 419627 421207 427454 428276 431448 432077 434642 437855 439845 445471 451866 453039 457152 457974 467613 473539 486336 491781 496270 500300 501313 503419 508437 516450 520739 523567 524508 526203 527975 528202 528923 529556 530030 530681 530696 533738 533948 535505 539203 540518 541197 542590 544840 545341 545409 545418 556741 558820 565501 566667 581968 586596 590280 590444 592645 599835 599856 599966 600290 603132 604016 604289 604364 616994 617437 622402 627725 627807 628333 628371 628383 630550 631202 632978 633451 633497 633796 634116 634153 637021 640793 641975 645276 647837 647854 647877 647936 648575 651209 662222 666881 666894 666895 666903 670239 676087 676112 677672 677781 677783 685714 695123 696582 707391 716220 719333 810109 811497 814746 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (9.93%) |
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 542590 558820 670239 590280 592645 434642 402724 500300 491781 516450 528202 520739 685714 622402 634116 533738 535505 501313 540518 541197 647877 677781 599856 637021 586596 811497 627807 457152 529556 565501 545341 814746 530681 666881 677672 666903 600290 523567 527975 645276 604289 421207 437855 467613 603132 427454 662222 473539 503419 530030 647936 640793 633451 432077 627725 530696 648575 604016 415618 676087 651209 676112 719333 617437 633796 439845 632978 566667 696582 634153 431448 496270 599835 544840 666895 599966 451866 695123 628371 604364 453039 533948 545409 445471 428276 716220 631202 641975 810109 633497 524508 539203 647837 628383 508437 647854 677783 630550 419627 590444 457974 545418 556741 707391 666894 628333 486336 616994 581968 526203 528923 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.03%) |
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 402724 415618 419627 421207 427454 428276 431448 432077 434642 437855 439845 445471 451866 453039 457152 457974 467613 473539 486336 491781 496270 500300 501313 503419 508437 516450 520739 523567 524508 526203 527975 528202 528923 529556 530030 530681 530696 533738 533948 535505 539203 540518 541197 542590 544840 545341 545409 545418 556741 558820 565501 566667 581968 586596 590280 590444 592645 599835 599856 599966 600290 603132 604016 604289 604364 616994 617437 622402 627725 627807 628333 628371 628383 630550 631202 632978 633451 633497 633796 634116 634153 637021 640793 641975 645276 647837 647854 647877 647936 648575 651209 662222 666881 666894 666895 666903 670239 676087 676112 677672 677781 677783 685714 695123 696582 707391 716220 719333 810109 811497 814746 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rough teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"rough teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"rough teen анал"
]
|
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.