Query Metrics
7
Database Queries
7
Different statements
185.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.13 ms (87.25%) |
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 162405 191420 383774 398970 405934 409300 409936 411321 411371 411767 411916 411984 414174 415557 418148 419530 425970 430495 432699 448711 450344 451967 452008 452183 453351 453727 454166 457384 459620 462080 462486 463743 464246 465351 466229 466251 466381 466722 466818 467233 467961 468180 469609 470208 470927 470942 470980 473904 474161 474405 474474 474861 475669 475825 476588 476750 478762 479253 480414 481748 482355 482361 483142 483150 483557 486815 488658 489868 489938 490407 490913 490928 490944 491926 491988 498481 501518 503961 505963 506047 509234 509286 511178 512536 512541 513593 514818 517013 517839 518744 518858 521465 522504 523356 524335 526060 528659 529227 529347 530011 531900 531994 534258 534261 534395 534709 535433 537105 538681 540654 544500 555937 558877 563175 583097 589656 727859 727888 740001 762671 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (8.16%) |
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 518858 476588 411371 432699 411916 490944 459620 486815 512541 489868 544500 563175 558877 583097 411767 511178 535433 506047 405934 411984 415557 409300 451967 463743 476750 478762 480414 483142 462080 470980 474161 475669 505963 534261 498481 514818 534258 537105 531900 469609 482361 470208 474474 162405 470927 490913 490928 462486 530011 419530 534709 466251 466229 518744 450344 481748 509234 468180 383774 465351 475825 491926 191420 488658 457384 524335 531994 517839 540654 555937 727859 740001 513593 418148 509286 414174 727888 534395 425970 482355 589656 490407 517013 473904 453727 483557 521465 501518 529227 538681 466381 467961 762671 430495 452183 464246 479253 526060 453351 523356 483150 448711 466722 452008 474861 489938 512536 474405 411321 454166 466818 467233 470942 503961 522504 491988 528659 398970 409936 529347 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.31%) |
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 162405 191420 383774 398970 405934 409300 409936 411321 411371 411767 411916 411984 414174 415557 418148 419530 425970 430495 432699 448711 450344 451967 452008 452183 453351 453727 454166 457384 459620 462080 462486 463743 464246 465351 466229 466251 466381 466722 466818 467233 467961 468180 469609 470208 470927 470942 470980 473904 474161 474405 474474 474861 475669 475825 476588 476750 478762 479253 480414 481748 482355 482361 483142 483150 483557 486815 488658 489868 489938 490407 490913 490928 490944 491926 491988 498481 501518 503961 505963 506047 509234 509286 511178 512536 512541 513593 514818 517013 517839 518744 518858 521465 522504 523356 524335 526060 528659 529227 529347 530011 531900 531994 534258 534261 534395 534709 535433 537105 538681 540654 544500 555937 558877 563175 583097 589656 727859 727888 740001 762671 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white panties mature"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white трусик нижн бел mature"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white трусик нижн бел mature"
]
|
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.