Query Metrics
7
Database Queries
7
Different statements
176.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.59 ms (84.89%) |
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 155257 234690 352189 370829 393435 424248 424660 430002 435551 440639 446002 449428 460293 468072 468238 469128 472864 473426 474441 479351 479474 480477 481961 485966 486810 496334 504509 506458 509800 511277 512543 513962 514877 515546 521261 523881 529293 529795 529799 531789 532817 534586 537572 537848 538760 545328 546422 546838 547426 547480 547483 547486 547489 548957 554487 554571 554919 555258 555329 555387 555389 555752 558176 558494 559355 561034 561036 562784 565119 573270 576545 576943 578493 581006 590498 591003 592461 595438 599906 603616 604109 605906 621964 624229 624794 625181 625521 628055 629281 641924 646329 650305 654174 660385 666869 668559 669270 671584 671713 676303 680423 700975 713876 717873 720719 725739 761946 776726 777094 781457 797339 801430 815199 816067 817288 817581 818387 819571 820793 823354 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (8.51%) |
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 629281 777094 797339 155257 352189 479351 480477 460293 469128 481961 506458 511277 521261 595438 725739 537572 473426 370829 446002 430002 504509 554919 646329 669270 641924 776726 761946 538760 650305 548957 801430 424660 449428 468072 509800 817581 820793 823354 554487 624794 628055 781457 558176 513962 529293 234690 393435 435551 424248 440639 668559 816067 818387 815199 819571 817288 486810 472864 485966 529795 532817 537848 523881 529799 534586 515546 496334 512543 514877 531789 468238 474441 479474 546838 547486 555389 562784 573270 576943 578493 581006 545328 546422 547483 547489 547426 547480 554571 555329 555387 555752 559355 561034 561036 565119 671584 700975 660385 666869 680423 713876 717873 720719 654174 671713 676303 555258 558494 576545 591003 592461 599906 624229 625521 603616 621964 590498 604109 605906 625181 ] |
||||||||||||||||||||||||||||||
|
4.56 ms (2.59%) |
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 155257 234690 352189 370829 393435 424248 424660 430002 435551 440639 446002 449428 460293 468072 468238 469128 472864 473426 474441 479351 479474 480477 481961 485966 486810 496334 504509 506458 509800 511277 512543 513962 514877 515546 521261 523881 529293 529795 529799 531789 532817 534586 537572 537848 538760 545328 546422 546838 547426 547480 547483 547486 547489 548957 554487 554571 554919 555258 555329 555387 555389 555752 558176 558494 559355 561034 561036 562784 565119 573270 576545 576943 578493 581006 590498 591003 592461 595438 599906 603616 604109 605906 621964 624229 624794 625181 625521 628055 629281 641924 646329 650305 654174 660385 666869 668559 669270 671584 671713 676303 680423 700975 713876 717873 720719 725739 761946 776726 777094 781457 797339 801430 815199 816067 817288 817581 818387 819571 820793 823354 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачать мастурбация зрелых"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача мастурбац зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
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.