Query Metrics
7
Database Queries
7
Different statements
171.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.59 ms (80.98%) |
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 378046 403909 405921 406171 417212 420192 420559 420561 423375 425351 428415 431446 432337 434702 434712 446894 447885 448445 453358 460736 461576 461591 467559 467581 474748 476106 476259 477210 478973 480429 481134 481147 482824 485269 491776 492215 493192 509713 510588 510747 513126 515131 517841 518206 520448 523109 523212 530024 530694 530696 534027 536648 536665 537210 537648 537919 541646 541721 542196 543425 545519 545602 551225 551941 556029 558134 558191 559162 560299 561814 565364 565366 565367 566079 566112 567208 567909 568305 568999 569682 570426 571199 576049 576113 577356 577435 582821 583507 583670 583700 583725 586886 587651 588499 598686 599862 600271 600337 601094 601324 602532 605453 606275 607132 613832 619439 623199 628117 630221 632692 639716 640770 640772 642775 647830 647952 649546 656009 674968 674995 ] |
||||||||||||||||||||||||||||||
|
22.49 ms (13.14%) |
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 642775 520448 565366 606275 453358 481134 513126 477210 586886 542196 420561 601324 566079 656009 623199 476259 570426 567909 576049 545602 417212 461591 492215 420559 551941 640772 523109 482824 600337 428415 420192 537919 556029 565367 583670 478973 510588 605453 607132 481147 559162 545519 561814 583725 598686 588499 640770 467559 425351 518206 378046 405921 434702 565364 582821 480429 517841 406171 446894 569682 649546 560299 541721 567208 576113 476106 403909 509713 523212 536648 674968 639716 571199 630221 536665 537648 474748 551225 647952 600271 613832 461576 510747 583507 448445 647830 628117 602532 447885 485269 434712 599862 432337 632692 566112 460736 587651 601094 558134 493192 530694 530024 537210 674995 515131 467581 541646 577435 619439 530696 577356 568999 491776 534027 583700 431446 568305 543425 558191 423375 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.80%) |
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 378046 403909 405921 406171 417212 420192 420559 420561 423375 425351 428415 431446 432337 434702 434712 446894 447885 448445 453358 460736 461576 461591 467559 467581 474748 476106 476259 477210 478973 480429 481134 481147 482824 485269 491776 492215 493192 509713 510588 510747 513126 515131 517841 518206 520448 523109 523212 530024 530694 530696 534027 536648 536665 537210 537648 537919 541646 541721 542196 543425 545519 545602 551225 551941 556029 558134 558191 559162 560299 561814 565364 565366 565367 566079 566112 567208 567909 568305 568999 569682 570426 571199 576049 576113 577356 577435 582821 583507 583670 583700 583725 586886 587651 588499 598686 599862 600271 600337 601094 601324 602532 605453 606275 607132 613832 619439 623199 628117 630221 632692 639716 640770 640772 642775 647830 647952 649546 656009 674968 674995 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"маленькая задница мжм…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая жоп мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.78%) |
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.