Query Metrics
7
Database Queries
7
Different statements
167.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.76 ms (83.04%) |
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 15129 134947 187843 233617 271496 383235 391048 397531 397605 405966 410073 411628 411686 411716 411777 411837 411923 411936 411939 413283 413714 415781 416855 422264 422278 422286 422426 425959 426452 426812 427220 432494 433418 433740 435382 435929 437323 437333 437341 437634 439701 440390 440798 441838 442011 442051 442101 442402 443130 443622 443771 445637 445774 446107 448466 449894 450249 450555 450796 452347 452350 453122 453244 453991 454463 454474 454476 455123 455757 455991 456034 456061 458362 460010 461404 462075 462568 463940 464015 470302 471067 474124 476952 477710 479261 482835 484329 487307 489926 490653 491337 492292 493134 499539 501169 501342 503104 503471 509225 514760 514761 517674 519579 520140 520186 522337 524907 525510 527147 550514 563673 567414 569138 574421 605409 624787 756252 813791 814037 814289 ] |
||||||||||||||||||||||||||||||
|
18.71 ms (11.20%) |
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 462568 391048 462075 413714 476952 461404 490653 492292 519579 499539 522337 501169 187843 411628 411777 433740 437333 422286 450796 456061 460010 514761 520186 509225 517674 524907 527147 574421 550514 567414 756252 233617 443130 479261 422264 432494 471067 426812 442402 484329 525510 503104 503471 443622 456034 569138 624787 520140 425959 443771 439701 470302 477710 445637 813791 514760 563673 415781 501342 605409 383235 134947 271496 15129 397531 397605 405966 411686 411716 411837 411936 413283 422278 437323 441838 410073 433418 442011 442051 442101 427220 411939 422426 435382 437341 440798 411923 416855 426452 435929 437634 440390 814289 814037 445774 446107 449894 450249 450555 452347 453122 453244 453991 454474 454476 455123 455757 455991 458362 463940 464015 474124 482835 487307 489926 491337 493134 448466 452350 454463 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.89%) |
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 15129 134947 187843 233617 271496 383235 391048 397531 397605 405966 410073 411628 411686 411716 411777 411837 411923 411936 411939 413283 413714 415781 416855 422264 422278 422286 422426 425959 426452 426812 427220 432494 433418 433740 435382 435929 437323 437333 437341 437634 439701 440390 440798 441838 442011 442051 442101 442402 443130 443622 443771 445637 445774 446107 448466 449894 450249 450555 450796 452347 452350 453122 453244 453991 454463 454474 454476 455123 455757 455991 456034 456061 458362 460010 461404 462075 462568 463940 464015 470302 471067 474124 476952 477710 479261 482835 484329 487307 489926 490653 491337 492292 493134 499539 501169 501342 503104 503471 509225 514760 514761 517674 519579 520140 520186 522337 524907 525510 527147 550514 563673 567414 569138 574421 605409 624787 756252 813791 814037 814289 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм полная"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм полная"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.