Query Metrics
7
Database Queries
7
Different statements
160.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.48 ms (85.80%) |
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 90485 185834 213604 249597 383089 383389 384963 385422 385701 389806 391576 392989 397953 403289 404126 416242 419066 419265 420473 421377 422336 423033 425322 427940 428833 429588 432976 441452 443120 445585 447304 448715 449082 458082 464039 466424 474281 474336 476372 483778 489902 490893 491907 492582 494318 496703 498765 499741 500923 511966 513880 516990 517552 520301 527450 527627 530803 532902 535749 540911 549775 551980 555910 559186 560102 560174 560381 565321 570248 570372 573114 574606 576014 580291 580704 581607 591721 592065 603910 607579 610152 633112 635948 640435 650485 650603 660233 661313 663410 666132 666808 667829 667901 673074 683593 687889 695652 699626 709871 716965 718983 720126 720456 721711 722261 722860 726876 728314 736693 741544 748685 750213 753118 758000 766348 770391 784550 786831 804876 810122 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (7.83%) |
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 570248 695652 666132 610152 786831 709871 249597 753118 384963 389806 683593 383089 663410 425322 427940 449082 516990 560102 736693 607579 810122 397953 422336 483778 687889 660233 720126 667829 804876 718983 419066 559186 784550 728314 741544 489902 494318 721711 722860 766348 385422 445585 650603 722261 576014 560381 661313 673074 591721 750213 748685 635948 403289 448715 720456 404126 551980 580704 666808 699626 633112 385701 392989 458082 517552 573114 540911 770391 726876 603910 428833 447304 90485 496703 499741 213604 441452 419265 520301 570372 466424 474281 429588 420473 416242 185834 513880 474336 383389 530803 758000 421377 432976 535749 650485 549775 560174 640435 716965 391576 476372 443120 511966 527450 490893 464039 667901 581607 592065 423033 527627 491907 492582 498765 500923 532902 555910 574606 580291 565321 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.08%) |
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 90485 185834 213604 249597 383089 383389 384963 385422 385701 389806 391576 392989 397953 403289 404126 416242 419066 419265 420473 421377 422336 423033 425322 427940 428833 429588 432976 441452 443120 445585 447304 448715 449082 458082 464039 466424 474281 474336 476372 483778 489902 490893 491907 492582 494318 496703 498765 499741 500923 511966 513880 516990 517552 520301 527450 527627 530803 532902 535749 540911 549775 551980 555910 559186 560102 560174 560381 565321 570248 570372 573114 574606 576014 580291 580704 581607 591721 592065 603910 607579 610152 633112 635948 640435 650485 650603 660233 661313 663410 666132 666808 667829 667901 673074 683593 687889 695652 699626 709871 716965 718983 720126 720456 721711 722261 722860 726876 728314 736693 741544 748685 750213 753118 758000 766348 770391 784550 786831 804876 810122 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс тонкие"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex slim"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
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.