Query Metrics
7
Database Queries
7
Different statements
144.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.24 ms (83.09%) |
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 414071 418817 423775 423783 423802 424265 444371 448140 448263 452823 452977 454755 457092 464815 469140 470034 471088 475318 475769 478985 483686 492407 492758 498490 511946 513501 515004 515016 515038 515413 515486 516574 516873 517304 523181 529905 532560 547466 547482 547488 547746 547757 547776 547783 551494 554529 557472 557490 568137 568425 569575 571039 573194 575656 576886 579271 580234 581438 582336 582587 585316 587524 596769 600087 602197 602594 605858 606088 606109 624742 626593 631481 635253 637512 639326 641362 660834 667189 669884 680423 692711 700975 702125 708232 750453 757427 757436 760667 783312 784729 785856 785916 785972 786406 786604 791504 800031 800677 802905 803756 805149 805366 806435 807589 807590 807599 807619 808440 809009 809023 809039 809075 809078 809081 810790 810791 810804 811337 812490 816722 ] |
||||||||||||||||||||||||||||||
|
13.63 ms (9.42%) |
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 557472 557490 568137 571039 573194 576886 579271 700975 708232 680423 667189 669884 692711 702125 547746 547757 547776 547783 580234 581438 582336 585316 606109 635253 602197 626593 587524 637512 641362 596769 600087 605858 631481 639326 784729 785856 785916 785972 786604 802905 803756 807589 807599 809009 809023 809039 809075 809078 809081 810790 810791 811337 786406 800677 805149 805366 812490 760667 783312 800031 807590 808440 810804 757427 750453 757436 606088 791504 806435 807619 475318 478985 423775 423802 469140 418817 424265 454755 475769 444371 457092 515486 492407 498490 515004 516873 515016 516574 483686 492758 513501 523181 660834 452977 470034 568425 554529 602594 624742 471088 423783 511946 414071 816722 448140 448263 452823 517304 529905 515038 515413 532560 464815 547466 547482 547488 551494 569575 575656 582587 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.87%) |
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 414071 418817 423775 423783 423802 424265 444371 448140 448263 452823 452977 454755 457092 464815 469140 470034 471088 475318 475769 478985 483686 492407 492758 498490 511946 513501 515004 515016 515038 515413 515486 516574 516873 517304 523181 529905 532560 547466 547482 547488 547746 547757 547776 547783 551494 554529 557472 557490 568137 568425 569575 571039 573194 575656 576886 579271 580234 581438 582336 582587 585316 587524 596769 600087 602197 602594 605858 606088 606109 624742 626593 631481 635253 637512 639326 641362 660834 667189 669884 680423 692711 700975 702125 708232 750453 757427 757436 760667 783312 784729 785856 785916 785972 786406 786604 791504 800031 800677 802905 803756 805149 805366 806435 807589 807590 807599 807619 808440 809009 809023 809039 809075 809078 809081 810790 810791 810804 811337 812490 816722 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom соло вебкамер"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom solo webcam"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom соло вебкамер"
]
|
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.