Query Metrics
7
Database Queries
7
Different statements
264.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.80 ms (88.30%) |
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 390001 391715 393590 406299 408601 413818 413950 414184 414357 416365 418873 421323 423645 424470 424523 428703 431446 431730 432823 445896 445971 446105 447124 451588 462515 463864 465509 468622 469911 469918 469924 471792 473735 476248 478787 484609 485507 486589 487713 491394 491905 496792 497560 498102 498194 500596 502249 504268 505134 507312 508839 512561 513768 515193 516449 516635 519261 520215 522361 535028 540912 541605 543817 543919 544833 548258 548609 550669 550670 550764 550781 551991 552030 552703 553494 554743 558129 558447 559918 560445 561103 561412 565355 565371 565373 566439 566502 567067 568309 570074 574566 574823 576082 576412 577699 580256 582227 583724 590429 593835 596192 598386 599963 600330 603628 605355 605650 607237 617408 619409 628365 632001 635234 646937 648836 661253 675034 678967 714109 722689 ] |
||||||||||||||||||||||||||||||
|
19.72 ms (7.45%) |
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 583724 552030 558129 565373 574823 678967 714109 544833 561103 590429 599963 603628 390001 414184 476248 424470 432823 447124 469911 478787 413818 516635 484609 491394 500596 508839 513768 516449 498194 540912 445896 485507 491905 498102 505134 550764 568309 565371 550781 646937 722689 648836 553494 559918 565355 605355 607237 617408 619409 635234 497560 520215 522361 504268 486589 515193 552703 661253 391715 550669 550670 431446 421323 543919 580256 445971 570074 451588 598386 414357 507312 632001 473735 428703 446105 566502 577699 487713 576412 512561 431730 582227 566439 558447 469918 519261 496792 408601 413950 423645 502249 468622 567067 574566 576082 548609 593835 600330 605650 406299 462515 465509 424523 469924 471792 393590 416365 418873 463864 535028 548258 560445 541605 543817 561412 675034 551991 554743 596192 628365 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
2.42 ms (0.91%) |
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 390001 391715 393590 406299 408601 413818 413950 414184 414357 416365 418873 421323 423645 424470 424523 428703 431446 431730 432823 445896 445971 446105 447124 451588 462515 463864 465509 468622 469911 469918 469924 471792 473735 476248 478787 484609 485507 486589 487713 491394 491905 496792 497560 498102 498194 500596 502249 504268 505134 507312 508839 512561 513768 515193 516449 516635 519261 520215 522361 535028 540912 541605 543817 543919 544833 548258 548609 550669 550670 550764 550781 551991 552030 552703 553494 554743 558129 558447 559918 560445 561103 561412 565355 565371 565373 566439 566502 567067 568309 570074 574566 574823 576082 576412 577699 580256 582227 583724 590429 593835 596192 598386 599963 600330 603628 605355 605650 607237 617408 619409 628365 632001 635234 646937 648836 661253 675034 678967 714109 722689 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny mmf"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.53%) |
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.