Query Metrics
7
Database Queries
7
Different statements
246.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.03 ms (68.54%) |
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 396005 413827 420406 421977 422582 422595 422638 422908 423037 423266 423267 423568 425118 429898 432243 435428 443383 443659 447208 447452 447803 447851 448033 451572 452483 453162 457232 460027 461056 467195 467613 468012 468433 469023 470527 470852 476116 476957 477340 478832 486217 486885 487087 487361 489120 491169 493992 496080 498119 499182 501329 503369 508156 508199 508473 509810 512224 513638 516307 516351 516925 517655 518920 519317 520729 520957 520961 521089 521579 522617 523509 523567 523856 530269 530380 530757 532753 532912 533519 533538 533738 535584 536668 537901 538270 540338 543841 548228 549122 549860 552272 561814 565247 567779 575469 575806 586889 597703 603132 604289 605462 613488 634148 634185 639748 640770 647877 650851 651162 652833 666550 670239 677142 677973 716496 727648 790754 808327 821851 ] |
||||||||||||||||||||||||||||||
|
67.51 ms (27.38%) |
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 520957 650851 762121 501329 530757 540338 677142 575469 549860 422908 423568 821851 457232 477340 537901 516925 530380 716496 634148 586889 808327 423267 423266 443659 513638 487087 469023 532753 496080 535584 640770 460027 468433 478832 486885 422595 447851 467195 452483 518920 536668 499182 516307 548228 543841 575806 652833 670239 677973 549122 396005 435428 447452 425118 468012 470527 516351 523856 491169 503369 523509 520961 520729 597703 487361 453162 508473 530269 533738 519317 493992 552272 647877 561814 639748 447208 413827 447803 470852 498119 508156 421977 538270 509810 613488 517655 727648 604289 522617 423037 432243 422582 448033 486217 533519 533538 512224 532912 567779 666550 651162 565247 634185 790754 476116 476957 429898 443383 451572 422638 489120 523567 508199 521579 521089 420406 461056 467613 603132 605462 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.30%) |
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 396005 413827 420406 421977 422582 422595 422638 422908 423037 423266 423267 423568 425118 429898 432243 435428 443383 443659 447208 447452 447803 447851 448033 451572 452483 453162 457232 460027 461056 467195 467613 468012 468433 469023 470527 470852 476116 476957 477340 478832 486217 486885 487087 487361 489120 491169 493992 496080 498119 499182 501329 503369 508156 508199 508473 509810 512224 513638 516307 516351 516925 517655 518920 519317 520729 520957 520961 521089 521579 522617 523509 523567 523856 530269 530380 530757 532753 532912 533519 533538 533738 535584 536668 537901 538270 540338 543841 548228 549122 549860 552272 561814 565247 567779 575469 575806 586889 597703 603132 604289 605462 613488 634148 634185 639748 640770 647877 650851 651162 652833 666550 670239 677142 677973 716496 727648 790754 808327 821851 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм teen анал"
]
|
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.