Query Metrics
7
Database Queries
7
Different statements
185.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.31 ms (82.97%) |
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 24255 34198 88591 191075 191343 382124 382462 383350 387072 387556 391077 391928 394773 395662 395676 395887 398968 404302 404464 405482 407524 411588 411723 415548 416029 416102 418441 419617 421074 422152 424404 426781 428089 428096 428837 430705 431321 439217 439679 439766 441910 442970 442997 443459 444344 444650 446762 454008 456796 457205 457469 459954 462198 464426 466064 466278 469371 475316 483654 484569 489171 491276 494333 496595 502717 505387 506833 508597 509050 511808 511826 517355 522627 524876 528215 532048 535447 536436 542742 565736 565986 566684 572766 591130 592118 604826 610308 667541 669200 669452 687584 713423 721500 725485 732755 732789 733122 737650 748519 749645 761022 766767 767279 773686 780371 780667 786136 791501 791879 793077 794895 798409 801049 809809 811162 811864 813769 813819 824195 827383 ] |
||||||||||||||||||||||||||||||
|
21.13 ms (11.36%) |
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 395662 506833 813769 610308 811864 191075 442997 794895 713423 592118 786136 801049 809809 748519 798409 459954 489171 382124 737650 416102 669452 424404 456796 824195 464426 566684 572766 669200 791501 469371 502717 483654 457205 667541 733122 725485 522627 391077 428837 391928 505387 524876 439766 394773 387556 405482 404464 416029 431321 442970 462198 475316 511808 542742 411588 398968 528215 780371 604826 766767 395887 454008 761022 411723 395676 591130 407524 404302 439679 535447 767279 34198 24255 428096 444650 749645 428089 517355 791879 383350 827383 813819 687584 773686 508597 457469 811162 732789 732755 426781 532048 421074 439217 446762 496595 444344 793077 382462 466278 511826 491276 88591 441910 565986 509050 484569 780667 191343 387072 415548 466064 721500 565736 536436 419617 422152 494333 430705 443459 418441 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.89%) |
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 24255 34198 88591 191075 191343 382124 382462 383350 387072 387556 391077 391928 394773 395662 395676 395887 398968 404302 404464 405482 407524 411588 411723 415548 416029 416102 418441 419617 421074 422152 424404 426781 428089 428096 428837 430705 431321 439217 439679 439766 441910 442970 442997 443459 444344 444650 446762 454008 456796 457205 457469 459954 462198 464426 466064 466278 469371 475316 483654 484569 489171 491276 494333 496595 502717 505387 506833 508597 509050 511808 511826 517355 522627 524876 528215 532048 535447 536436 542742 565736 565986 566684 572766 591130 592118 604826 610308 667541 669200 669452 687584 713423 721500 725485 732755 732789 733122 737650 748519 749645 761022 766767 767279 773686 780371 780667 786136 791501 791879 793077 794895 798409 801049 809809 811162 811864 813769 813819 824195 827383 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин ван"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мам в душ"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
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.