Query Metrics
7
Database Queries
7
Different statements
1036.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
332.70 ms (32.10%) |
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 72519 288510 433473 452983 461040 464373 464935 471802 477802 479798 484282 485754 486941 489461 491403 491410 495361 499798 502744 506275 506348 506769 509341 515246 515378 518111 518188 518583 519046 519904 520630 520980 523312 524903 525716 525768 526222 526261 526762 527128 527485 527617 528388 528562 531432 535014 537870 539346 540657 543860 544420 544500 545831 549170 550769 550972 552595 554053 554899 554911 556005 556655 557533 558347 559884 560080 561926 563477 563883 564213 564327 565393 565557 565745 566002 566246 566928 567163 567405 567474 569098 569154 571442 571445 574426 578416 578664 580424 581596 581602 582392 582997 584516 586480 586637 587516 589442 591338 592996 598334 598979 599222 599255 599556 604473 604901 604923 610293 611245 615724 615898 617076 624854 631616 632578 637706 640837 676467 677300 774319 ] |
||||||||||||||||||||||||||||||
|
271.03 ms (26.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 526222 506769 528562 566002 567474 589442 540657 631616 72519 531432 580424 550769 560080 564213 554899 611245 489461 452983 486941 569154 565557 604473 502744 774319 288510 527485 559884 552595 566246 565393 566928 617076 520630 491403 599255 471802 578664 574426 582997 592996 464373 526261 556005 549170 557533 599222 586480 604901 615724 615898 485754 520980 537870 526762 518583 544420 558347 571442 637706 484282 584516 565745 491410 518188 539346 554911 569098 581602 545831 604923 591338 599556 640837 610293 598979 527617 515246 554053 581596 479798 515378 519046 586637 587516 564327 433473 528388 523312 495361 563477 567405 582392 525716 506275 567163 563883 506348 525768 544500 578416 477802 543860 499798 518111 556655 571445 624854 461040 527128 509341 519904 524903 535014 464935 550972 561926 677300 676467 598334 632578 ] |
||||||||||||||||||||||||||||||
|
214.50 ms (20.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк сиськ"
]
|
||||||||||||||||||||||||||||||
|
211.57 ms (20.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"jerking tits"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (0.26%) |
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 72519 288510 433473 452983 461040 464373 464935 471802 477802 479798 484282 485754 486941 489461 491403 491410 495361 499798 502744 506275 506348 506769 509341 515246 515378 518111 518188 518583 519046 519904 520630 520980 523312 524903 525716 525768 526222 526261 526762 527128 527485 527617 528388 528562 531432 535014 537870 539346 540657 543860 544420 544500 545831 549170 550769 550972 552595 554053 554899 554911 556005 556655 557533 558347 559884 560080 561926 563477 563883 564213 564327 565393 565557 565745 566002 566246 566928 567163 567405 567474 569098 569154 571442 571445 574426 578416 578664 580424 581596 581602 582392 582997 584516 586480 586637 587516 589442 591338 592996 598334 598979 599222 599255 599556 604473 604901 604923 610293 611245 615724 615898 617076 624854 631616 632578 637706 640837 676467 677300 774319 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.18%) |
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.