Query Metrics
7
Database Queries
7
Different statements
149.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.71 ms (81.46%) |
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 311854 395228 395691 396609 400166 400196 400249 407220 413904 417064 421128 421277 425784 430175 462280 464385 469533 469690 470749 471994 480719 482674 483660 484157 490050 494276 495706 499014 500614 507813 508525 510254 512890 512927 513029 515119 516634 518795 519385 519931 523600 534204 534850 545701 550976 551388 551577 552004 552043 552319 554513 556397 557948 560408 572005 575233 575472 580330 581401 583819 585698 586429 586494 587110 588281 588295 590859 590881 592437 593186 593470 593855 597967 603991 605467 607344 607919 608395 615015 617191 622187 622229 623818 624841 655410 663495 663511 665490 672040 680590 684228 688548 696226 696227 696228 709294 713023 727648 727770 727839 736068 740651 741959 742154 743331 745939 748365 751722 766718 766735 766812 774294 774382 774495 807519 812079 815292 816523 823168 827324 ] |
||||||||||||||||||||||||||||||
|
17.75 ms (11.88%) |
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 425784 421277 396609 462280 665490 588281 597967 500614 552043 593186 615015 469533 534850 395228 663511 400166 413904 417064 494276 519385 513029 587110 590881 603991 534204 575233 663495 554513 575472 588295 516634 592437 624841 586494 593470 400196 508525 523600 688548 495706 421128 556397 572005 557948 483660 482674 550976 605467 583819 680590 745939 430175 469690 552319 607344 400249 484157 622229 470749 593855 551577 519931 490050 507813 581401 499014 518795 480719 560408 608395 512927 551388 622187 586429 623818 510254 464385 655410 617191 585698 515119 590859 607919 552004 774382 812079 766718 727839 807519 741959 709294 696227 742154 736068 743331 727770 713023 471994 696226 684228 545701 727648 766812 740651 672040 766735 816523 512890 748365 823168 827324 815292 751722 580330 774495 774294 696228 395691 311854 407220 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.73%) |
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 311854 395228 395691 396609 400166 400196 400249 407220 413904 417064 421128 421277 425784 430175 462280 464385 469533 469690 470749 471994 480719 482674 483660 484157 490050 494276 495706 499014 500614 507813 508525 510254 512890 512927 513029 515119 516634 518795 519385 519931 523600 534204 534850 545701 550976 551388 551577 552004 552043 552319 554513 556397 557948 560408 572005 575233 575472 580330 581401 583819 585698 586429 586494 587110 588281 588295 590859 590881 592437 593186 593470 593855 597967 603991 605467 607344 607919 608395 615015 617191 622187 622229 623818 624841 655410 663495 663511 665490 672040 680590 684228 688548 696226 696227 696228 709294 713023 727648 727770 727839 736068 740651 741959 742154 743331 745939 748365 751722 766718 766735 766812 774294 774382 774495 807519 812079 815292 816523 823168 827324 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens sex"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens секс"
]
|
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.