Query Metrics
7
Database Queries
7
Different statements
187.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.26 ms (86.22%) |
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 383641 395648 395719 395727 395751 400965 401127 415761 434275 443476 447615 460879 461155 462209 463815 467608 473739 478184 479175 488747 497368 499125 503673 505614 509454 513098 516615 520224 528282 530376 531163 531165 531215 533512 533747 536693 537676 538520 538803 543627 545416 558119 560076 565251 565253 566736 568315 574184 582217 588520 591612 594246 595588 597227 597230 597232 597494 598872 601150 601641 603009 609682 615918 624175 628396 629199 631192 631965 632633 632979 633766 634145 634151 634155 634163 634199 637031 637034 637042 637122 637438 640728 640763 640779 640797 640801 640806 642053 642691 642775 642777 645858 646838 649509 650174 650762 650767 652586 659418 666546 672711 674962 675002 678127 678967 678973 680112 680122 680200 680206 689001 696997 705832 710524 727812 731683 741542 748530 751589 785727 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (8.80%) |
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 400965 650174 650762 650767 634199 640779 447615 652586 488747 565251 531215 659418 609682 642053 696997 537676 560076 678967 675002 751589 597227 531165 680200 597232 689001 680206 478184 503673 401127 680122 705832 597230 642777 631192 415761 395648 463815 588520 538520 594246 785727 395751 558119 566736 646838 601150 632979 624175 497368 509454 678973 634145 637031 443476 574184 642775 520224 505614 513098 645858 531163 637034 395719 473739 595588 545416 634163 634155 598872 601641 640801 640806 461155 666546 642691 640797 462209 674962 479175 543627 565253 640763 533512 568315 710524 582217 615918 434275 499125 533747 467608 536693 649509 591612 628396 727812 631965 672711 629199 640728 637042 637122 637438 731683 741542 748530 632633 633766 383641 395727 680112 516615 538803 597494 528282 530376 460879 678127 603009 634151 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.40%) |
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 383641 395648 395719 395727 395751 400965 401127 415761 434275 443476 447615 460879 461155 462209 463815 467608 473739 478184 479175 488747 497368 499125 503673 505614 509454 513098 516615 520224 528282 530376 531163 531165 531215 533512 533747 536693 537676 538520 538803 543627 545416 558119 560076 565251 565253 566736 568315 574184 582217 588520 591612 594246 595588 597227 597230 597232 597494 598872 601150 601641 603009 609682 615918 624175 628396 629199 631192 631965 632633 632979 633766 634145 634151 634155 634163 634199 637031 637034 637042 637122 637438 640728 640763 640779 640797 640801 640806 642053 642691 642775 642777 645858 646838 649509 650174 650762 650767 652586 659418 666546 672711 674962 675002 678127 678967 678973 680112 680122 680200 680206 689001 696997 705832 710524 727812 731683 741542 748530 751589 785727 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl first anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк first анал"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк first анал"
]
|
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.