Query Metrics
7
Database Queries
7
Different statements
175.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.12 ms (84.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 252608 387545 392986 393127 395654 399332 402979 412155 417173 422453 432383 441427 441577 441615 451012 452490 453514 458902 461585 462116 462304 467169 469740 475541 484011 485039 489022 495131 500152 503721 511182 514150 519683 520337 521019 521179 521939 523935 524973 527262 540724 543330 549146 553142 558218 559928 561310 561916 563870 566517 567523 571765 571772 571777 577887 579159 580491 585835 585930 588844 590807 598869 599481 603910 605928 611518 620060 622465 625134 625259 634799 645369 648762 651794 659330 665418 677015 677132 682573 685051 685055 687408 696688 699674 706912 707384 708869 718933 719573 729836 731794 736911 739905 744290 745214 751725 758270 763850 766342 769324 770718 778588 784110 786383 787906 788007 788144 788669 789157 789856 791413 795440 797817 800003 801274 803142 814073 821864 823217 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (8.65%) |
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 549146 558218 561916 563870 659330 707384 708869 665418 677132 696688 620060 611518 598869 778588 786383 789157 789856 769324 770718 745214 758270 731794 718933 787906 788669 791413 795440 432383 451012 402979 441427 441577 814073 458902 520337 577887 559928 571772 645369 685051 699674 580491 634799 588844 801274 763850 800003 729836 744290 461585 484011 500152 503721 489022 452490 603910 252608 399332 441615 821864 519683 543330 579159 571765 571777 677015 706912 685055 682573 553142 566517 585835 736911 719573 467169 469740 412155 392986 395654 393127 523935 524973 527262 823217 462304 485039 514150 521019 495131 511182 536850 567523 648762 651794 687408 561310 625259 590807 605928 625134 585930 599481 788007 788144 784110 797817 751725 739905 766342 622465 803142 475541 387545 422453 453514 417173 462116 540724 521179 521939 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.06%) |
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 252608 387545 392986 393127 395654 399332 402979 412155 417173 422453 432383 441427 441577 441615 451012 452490 453514 458902 461585 462116 462304 467169 469740 475541 484011 485039 489022 495131 500152 503721 511182 514150 519683 520337 521019 521179 521939 523935 524973 527262 540724 543330 549146 553142 558218 559928 561310 561916 563870 566517 567523 571765 571772 571777 577887 579159 580491 585835 585930 588844 590807 598869 599481 603910 605928 611518 620060 622465 625134 625259 634799 645369 648762 651794 659330 665418 677015 677132 682573 685051 685055 687408 696688 699674 706912 707384 708869 718933 719573 729836 731794 736911 739905 744290 745214 751725 758270 763850 766342 769324 770718 778588 784110 786383 787906 788007 788144 788669 789157 789856 791413 795440 797817 800003 801274 803142 814073 821864 823217 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls student"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк student"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк student"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.