Query Metrics
7
Database Queries
7
Different statements
184.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.40 ms (87.52%) |
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 107712 183036 185044 185834 229345 251363 282430 314133 358778 381855 382261 382857 383932 385347 385758 385761 387470 389933 390192 390698 393458 393700 396215 400926 401468 402373 402536 405124 408299 412642 414933 415698 416177 417064 417272 423948 424497 424562 424837 425033 425875 427019 427803 429193 429432 430556 432707 436542 444185 444601 445763 447309 449267 452015 454857 454916 455325 456706 457062 457806 458587 458597 459192 459712 460674 464233 464727 464744 465712 467163 468065 472693 479283 479486 484026 486136 493469 497537 498104 499136 500716 510823 510969 511383 511996 513845 515568 516087 518286 522403 524528 525749 526248 528927 529367 537144 538212 541688 541770 546926 558045 558344 563787 566867 569219 569906 571623 574586 575197 586576 591314 597134 598191 598500 603179 603923 619539 622187 641665 674778 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (7.33%) |
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 598191 603923 454916 415698 529367 385347 619539 424837 390698 358778 455325 393700 424562 229345 381855 402536 405124 449267 538212 528927 510823 425033 499136 432707 566867 417064 390192 385758 401468 408299 569906 416177 591314 597134 467163 464744 563787 389933 465712 541770 515568 541688 472693 464727 414933 282430 251363 383932 107712 537144 674778 603179 586576 400926 479486 571623 396215 498104 525749 516087 500716 641665 569219 185044 185834 387470 429432 558045 598500 444185 497537 385761 183036 423948 460674 484026 458587 458597 382261 393458 412642 447309 574586 457062 430556 314133 526248 575197 468065 522403 513845 456706 454857 459192 402373 425875 459712 436542 622187 524528 558344 444601 452015 546926 493469 510969 518286 382857 429193 427803 417272 424497 445763 511383 464233 427019 457806 479283 511996 486136 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.44%) |
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 107712 183036 185044 185834 229345 251363 282430 314133 358778 381855 382261 382857 383932 385347 385758 385761 387470 389933 390192 390698 393458 393700 396215 400926 401468 402373 402536 405124 408299 412642 414933 415698 416177 417064 417272 423948 424497 424562 424837 425033 425875 427019 427803 429193 429432 430556 432707 436542 444185 444601 445763 447309 449267 452015 454857 454916 455325 456706 457062 457806 458587 458597 459192 459712 460674 464233 464727 464744 465712 467163 468065 472693 479283 479486 484026 486136 493469 497537 498104 499136 500716 510823 510969 511383 511996 513845 515568 516087 518286 522403 524528 525749 526248 528927 529367 537144 538212 541688 541770 546926 558045 558344 563787 566867 569219 569906 571623 574586 575197 586576 591314 597134 598191 598500 603179 603923 619539 622187 641665 674778 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни бабе"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.