Query Metrics
7
Database Queries
7
Different statements
151.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.56 ms (81.98%) |
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 97045 161823 373884 382825 386684 394542 395597 398230 399094 399604 401971 404765 408974 411353 415299 417441 417926 418943 419765 420441 422491 423670 428892 430484 436481 437789 437961 439194 443203 446041 447533 449592 450803 451232 452135 453903 454599 457688 458179 458348 459097 460225 460424 460680 464165 464610 465185 465838 468022 470067 471517 471592 472309 472626 474178 474369 478319 480954 481727 482812 483014 485105 486955 489634 490284 493349 493460 493898 494365 494670 496013 497250 498924 499149 499324 500888 501649 502566 502896 505378 506090 507199 509630 510121 511913 519115 520599 522083 523689 524845 525833 525872 527324 543833 548908 558606 558770 560179 565722 571500 573470 576062 578123 578343 582051 582521 592342 597583 602009 602848 603166 603253 605455 624886 631466 679244 719806 731884 791933 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (11.49%) |
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 719806 560179 453903 511913 574070 497250 506090 382825 373884 395597 398230 399604 418943 417441 499324 460680 631466 386684 436481 451232 458179 470067 471517 417926 430484 478319 510121 501649 573470 605455 791933 731884 401971 525833 411353 437961 486955 449592 498924 494365 494670 558606 582521 571500 548908 565722 582051 679244 602009 624886 602848 443203 457688 480954 423670 459097 437789 464610 474178 481727 420441 493349 499149 500888 502896 505378 525872 489634 490284 496013 507199 509630 519115 483014 493460 522083 465838 460424 603166 603253 408974 471592 527324 502566 404765 454599 474369 558770 576062 592342 465185 428892 520599 161823 394542 415299 419765 482812 452135 460225 543833 578123 597583 450803 485105 524845 464165 472626 468022 493898 439194 422491 472309 399094 523689 97045 458348 578343 447533 446041 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.70%) |
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 97045 161823 373884 382825 386684 394542 395597 398230 399094 399604 401971 404765 408974 411353 415299 417441 417926 418943 419765 420441 422491 423670 428892 430484 436481 437789 437961 439194 443203 446041 447533 449592 450803 451232 452135 453903 454599 457688 458179 458348 459097 460225 460424 460680 464165 464610 465185 465838 468022 470067 471517 471592 472309 472626 474178 474369 478319 480954 481727 482812 483014 485105 486955 489634 490284 493349 493460 493898 494365 494670 496013 497250 498924 499149 499324 500888 501649 502566 502896 505378 506090 507199 509630 510121 511913 519115 520599 522083 523689 524845 525833 525872 527324 543833 548908 558606 558770 560179 565722 571500 573470 576062 578123 578343 582051 582521 592342 597583 602009 602848 603166 603253 605455 624886 631466 679244 719806 731884 791933 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сделай глубокий минет…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сдела глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
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.