Query Metrics
7
Database Queries
7
Different statements
158.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.72 ms (82.73%) |
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 326081 385971 395228 395860 400166 400196 400249 413904 417064 421128 421277 430175 446906 458916 462280 464385 469690 470749 480719 482674 483660 484157 484541 490050 492676 494276 495706 499014 500614 506548 507813 508525 510254 512927 513029 516634 518795 519891 519931 523600 534204 534850 544746 544758 550976 551388 551577 552001 552004 552319 554513 556397 556773 557948 560408 562765 572005 575233 581401 583819 585698 586429 586494 587110 588281 588295 590859 590881 592437 593186 593470 593855 597967 603991 605467 607344 607919 608395 615015 617191 622005 622119 622154 623818 624841 649920 651680 651945 654206 655410 657128 657252 659259 659280 663495 663502 663511 665490 674107 680590 688548 688674 728879 730818 732060 735863 739052 741950 742185 742199 745939 746421 790971 792486 792511 798780 800590 807918 812510 819510 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (10.73%) |
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 395228 446906 665490 597967 462280 500614 593186 615015 588295 575233 663511 400166 413904 745939 519891 458916 400196 484541 421277 495706 587110 590881 588281 554513 513029 603991 534204 508525 417064 534850 523600 556397 663495 516634 592437 586494 593470 688548 484157 557948 607344 494276 469690 624841 605467 421128 572005 430175 552319 470749 519931 483660 482674 550976 680590 400249 551577 593855 490050 507813 583819 608395 581401 499014 560408 512927 551388 518795 480719 623818 510254 586429 617191 464385 655410 552004 590859 585698 607919 544746 800590 649920 657128 544758 659259 622119 812510 742199 790971 792486 819510 735863 688674 792511 326081 659280 654206 742185 651680 730818 732060 385971 798780 395860 746421 728879 506548 622005 807918 663502 552001 556773 562765 492676 741950 739052 622154 674107 651945 657252 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.12%) |
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 326081 385971 395228 395860 400166 400196 400249 413904 417064 421128 421277 430175 446906 458916 462280 464385 469690 470749 480719 482674 483660 484157 484541 490050 492676 494276 495706 499014 500614 506548 507813 508525 510254 512927 513029 516634 518795 519891 519931 523600 534204 534850 544746 544758 550976 551388 551577 552001 552004 552319 554513 556397 556773 557948 560408 562765 572005 575233 581401 583819 585698 586429 586494 587110 588281 588295 590859 590881 592437 593186 593470 593855 597967 603991 605467 607344 607919 608395 615015 617191 622005 622119 622154 623818 624841 649920 651680 651945 654206 655410 657128 657252 659259 659280 663495 663502 663511 665490 674107 680590 688548 688674 728879 730818 732060 735863 739052 741950 742185 742199 745939 746421 790971 792486 792511 798780 800590 807918 812510 819510 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 sex threesome"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.02%) |
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.