Query Metrics
7
Database Queries
7
Different statements
167.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.61 ms (81.78%) |
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 419093 427614 428798 434168 437336 440645 442288 442783 445884 446295 448362 449361 453273 453307 455976 459407 460370 460728 465270 467932 469952 477335 479629 480833 483162 484398 490409 490929 491021 491208 491988 501338 502197 502695 502995 504772 508474 509033 509328 512551 513141 515018 515022 515839 517000 518040 518735 519023 519034 520694 520697 523256 523832 524848 525012 525116 527444 528084 531920 531996 532129 534168 534377 535344 537122 537123 538008 539512 546878 546944 548870 549822 549840 549845 550644 551923 552043 557128 557177 557551 557558 558003 558176 559008 559067 559687 559696 560410 561601 562598 563141 563218 563450 563456 563898 563931 565982 568346 574384 579284 582249 586682 586962 588992 591198 595956 597874 599368 602672 608437 609803 610588 610660 621734 621966 626266 630475 650806 663380 680838 ] |
||||||||||||||||||||||||||||||
|
20.30 ms (12.15%) |
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 531996 562598 557177 561601 549822 549840 626266 608437 483162 491988 520694 504772 538008 460728 563450 630475 460370 586682 558176 515018 502197 513141 477335 453273 509328 582249 559687 467932 528084 565982 602672 534168 491021 446295 508474 559696 597874 465270 484398 539512 546878 490929 455976 515022 560410 563931 563898 491208 535344 523256 453307 557558 549845 509033 501338 448362 537123 546944 427614 519023 579284 442783 419093 469952 550644 440645 557128 548870 519034 428798 568346 459407 445884 480833 518735 515839 502995 534377 586962 588992 559008 563218 490409 574384 502695 532129 610588 525116 551923 680838 563141 595956 621734 437336 531920 512551 591198 442288 434168 449361 537122 557551 621966 523832 527444 599368 525012 552043 517000 559067 663380 610660 520697 609803 563456 558003 650806 518040 479629 524848 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.59%) |
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 419093 427614 428798 434168 437336 440645 442288 442783 445884 446295 448362 449361 453273 453307 455976 459407 460370 460728 465270 467932 469952 477335 479629 480833 483162 484398 490409 490929 491021 491208 491988 501338 502197 502695 502995 504772 508474 509033 509328 512551 513141 515018 515022 515839 517000 518040 518735 519023 519034 520694 520697 523256 523832 524848 525012 525116 527444 528084 531920 531996 532129 534168 534377 535344 537122 537123 538008 539512 546878 546944 548870 549822 549840 549845 550644 551923 552043 557128 557177 557551 557558 558003 558176 559008 559067 559687 559696 560410 561601 562598 563141 563218 563450 563456 563898 563931 565982 568346 574384 579284 582249 586682 586962 588992 591198 595956 597874 599368 602672 608437 609803 610588 610660 621734 621966 626266 630475 650806 663380 680838 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties step mom"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел step mom"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел step mom"
]
|
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.