Query Metrics
7
Database Queries
7
Different statements
170.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.42 ms (82.84%) |
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 418125 419088 420576 422438 422469 428382 431500 437217 437222 437607 443029 443068 448213 448763 450339 451605 453508 455612 456607 457841 463678 469648 469655 470218 471517 472370 474279 475010 476013 476460 478847 479555 480011 481419 482997 483560 485542 486116 487303 487313 487802 488709 489187 490328 490867 491309 491716 491719 491746 492458 493919 494802 497052 502639 503679 505431 506433 507433 509036 510077 513325 513346 513620 516039 516389 517248 520587 521571 521685 522584 525600 537282 537310 541080 546374 549814 551820 552781 552941 553654 555510 556241 556474 558210 558522 559236 560802 561236 564902 565400 565426 567648 568837 568961 570695 571832 574000 574043 588252 588261 598511 598839 601941 609103 609419 614434 617431 618806 620846 623471 644904 650228 663347 698878 717796 758380 758691 765055 769077 781397 ] |
||||||||||||||||||||||||||||||
|
18.59 ms (10.89%) |
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 650228 558210 717796 758380 574000 644904 490328 503679 537310 551820 564902 574043 556474 598511 609419 698878 443029 469648 475010 476460 422438 472370 418125 455612 419088 420576 437222 476013 502639 516389 488709 491719 494802 522584 487802 525600 487313 491309 509036 520587 485542 571832 457841 552941 451605 552781 568961 479555 506433 492458 487303 618806 617431 758691 765055 781397 470218 437607 481419 450339 456607 663347 559236 570695 565426 588261 431500 463678 471517 422469 428382 443068 513325 513620 483560 491716 497052 489187 507433 541080 482997 490867 769077 558522 588252 561236 556241 598839 448213 469655 521571 521685 510077 513346 517248 491746 516039 486116 493919 480011 623471 609103 614434 601941 537282 553654 567648 546374 555510 568837 549814 560802 565400 620846 437217 453508 474279 448763 478847 505431 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.00%) |
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 418125 419088 420576 422438 422469 428382 431500 437217 437222 437607 443029 443068 448213 448763 450339 451605 453508 455612 456607 457841 463678 469648 469655 470218 471517 472370 474279 475010 476013 476460 478847 479555 480011 481419 482997 483560 485542 486116 487303 487313 487802 488709 489187 490328 490867 491309 491716 491719 491746 492458 493919 494802 497052 502639 503679 505431 506433 507433 509036 510077 513325 513346 513620 516039 516389 517248 520587 521571 521685 522584 525600 537282 537310 541080 546374 549814 551820 552781 552941 553654 555510 556241 556474 558210 558522 559236 560802 561236 564902 565400 565426 567648 568837 568961 570695 571832 574000 574043 588252 588261 598511 598839 601941 609103 609419 614434 617431 618806 620846 623471 644904 650228 663347 698878 717796 758380 758691 765055 769077 781397 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian pov public"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск пов на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.88%) |
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.