Query Metrics
7
Database Queries
7
Different statements
375.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
350.76 ms (93.32%) |
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 383599 387936 393391 397335 397373 406179 411524 413376 413719 414105 415265 415564 417002 418492 422591 423522 425495 426021 426458 428889 429208 431523 434669 438929 440669 443256 443322 443555 445748 445961 447121 447423 447480 447532 447741 447761 451144 451655 451663 452302 454051 454687 454993 455599 456790 458033 458912 459611 460716 462170 463798 463917 464624 467684 469156 469396 472089 474896 475407 476012 477895 479007 480008 480504 481684 486711 488822 491707 496451 496975 497961 499109 502884 503350 504144 504962 505923 506469 509069 509197 509560 511581 511675 512698 513160 514482 517063 517863 522319 523462 524310 525836 526910 529684 530478 531114 531352 542674 543864 545509 548251 567821 571380 585096 585984 588792 590228 590620 598207 620261 621268 634139 639809 665984 702680 740690 780215 791926 811643 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (4.33%) |
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 811643 417002 387936 426021 443555 411524 413376 509197 486711 511581 383599 454051 542674 543864 590228 443256 447761 469156 445748 460716 467684 472089 522319 531352 414105 459611 406179 598207 428889 488822 454993 415265 397373 620261 477895 451655 497961 585096 438929 440669 517863 526910 530478 512698 514482 475407 454687 524310 491707 451144 481684 499109 462170 502884 525836 517063 665984 702680 791926 588792 567821 523462 621268 780215 529684 545509 509560 740690 531114 474896 639809 524760 504144 458033 426458 571380 503350 476012 451663 479007 505923 447423 393391 464624 397335 425495 443322 480504 504962 511675 434669 463798 506469 585984 413719 431523 452302 447480 429208 469396 423522 447121 480008 496451 415564 422591 456790 513160 509069 548251 634139 590620 447741 458912 418492 447532 463917 445961 455599 496975 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (0.64%) |
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 383599 387936 393391 397335 397373 406179 411524 413376 413719 414105 415265 415564 417002 418492 422591 423522 425495 426021 426458 428889 429208 431523 434669 438929 440669 443256 443322 443555 445748 445961 447121 447423 447480 447532 447741 447761 451144 451655 451663 452302 454051 454687 454993 455599 456790 458033 458912 459611 460716 462170 463798 463917 464624 467684 469156 469396 472089 474896 475407 476012 477895 479007 480008 480504 481684 486711 488822 491707 496451 496975 497961 499109 502884 503350 504144 504962 505923 506469 509069 509197 509560 511581 511675 512698 513160 514482 517063 517863 522319 523462 524310 525836 526910 529684 530478 531114 531352 542674 543864 545509 548251 567821 571380 585096 585984 588792 590228 590620 598207 620261 621268 634139 639809 665984 702680 740690 780215 791926 811643 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep throat fuck"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс секс"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.