Query Metrics
7
Database Queries
7
Different statements
162.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.29 ms (79.11%) |
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 38909 233504 382366 396688 397505 398761 405990 408528 419151 430508 431755 433582 434565 434783 436693 437172 438364 445736 445987 447002 447534 448554 448647 451579 455110 458382 459557 461384 461937 467395 467622 468530 469001 471832 474755 478556 479272 480775 482811 489598 490019 492783 498205 499977 500658 501273 501777 504367 504715 508265 508323 508354 509425 510048 511170 511233 511731 512299 512992 519237 520414 521035 521961 522237 523311 523628 526094 528918 531266 546308 548423 548436 550210 551174 551435 552115 552476 560481 560807 562275 569647 570013 570420 571070 571381 571921 571932 572048 572928 572962 572999 573016 573845 573852 573858 574143 574552 574874 575064 575085 575743 578022 579485 579941 585595 591819 597072 600142 600147 600385 600404 649588 649711 651097 654556 654901 657931 658008 659511 669973 ] |
||||||||||||||||||||||||||||||
|
22.78 ms (14.05%) |
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 461937 552476 448647 458382 480775 434565 436693 233504 419151 430508 431755 447534 467622 434783 447002 455110 479272 445987 448554 499977 501777 508323 511233 521035 492783 511731 512299 521961 489598 500658 504715 508354 510048 519237 520414 523311 526094 501273 504367 511170 512992 523628 528918 531266 509425 550210 437172 438364 467395 459557 522237 498205 408528 433582 482811 445736 469001 474755 552115 571921 571932 572999 573852 575064 579485 560481 562275 571070 572962 573016 575085 546308 548423 548436 570420 572048 572928 574552 574874 575743 579941 570013 571381 578022 597072 591819 468530 471832 397505 478556 396688 451579 490019 382366 398761 574143 569647 573858 649711 651097 657931 659511 654901 649588 654556 658008 669973 551435 600147 600142 585595 600385 38909 508265 551174 560807 573845 461384 600404 405990 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.55%) |
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 38909 233504 382366 396688 397505 398761 405990 408528 419151 430508 431755 433582 434565 434783 436693 437172 438364 445736 445987 447002 447534 448554 448647 451579 455110 458382 459557 461384 461937 467395 467622 468530 469001 471832 474755 478556 479272 480775 482811 489598 490019 492783 498205 499977 500658 501273 501777 504367 504715 508265 508323 508354 509425 510048 511170 511233 511731 512299 512992 519237 520414 521035 521961 522237 523311 523628 526094 528918 531266 546308 548423 548436 550210 551174 551435 552115 552476 560481 560807 562275 569647 570013 570420 571070 571381 571921 571932 572048 572928 572962 572999 573016 573845 573852 573858 574143 574552 574874 575064 575085 575743 578022 579485 579941 585595 591819 597072 600142 600147 600385 600404 649588 649711 651097 654556 654901 657931 658008 659511 669973 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девки с большими членами"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девк большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
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.