Query Metrics
7
Database Queries
7
Different statements
156.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.34 ms (78.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 398949 402378 402784 402793 412132 414038 416292 421108 421201 424443 425003 426710 428020 432707 432831 434361 438725 442520 442864 443934 448991 449717 450178 450440 454972 455945 458429 459907 460516 461346 462349 465352 466157 466291 466317 469876 470130 470514 470924 471196 473372 474984 478184 481725 484398 488604 490440 491130 495096 495459 495744 496935 497240 498656 500365 500504 501623 502418 502663 503304 506982 507310 514104 516870 520482 520890 521078 521483 521653 525349 527721 527943 529180 529434 529438 532355 535342 536664 542944 543314 543924 546594 551437 552323 552770 557938 557943 557946 557949 559551 567187 570397 586687 587416 590881 590887 590899 595061 595682 598204 599055 600833 603663 604710 609540 610002 615774 624137 634811 646937 653596 663835 675071 677279 680590 728143 728930 775958 802763 809466 ] |
||||||||||||||||||||||||||||||
|
24.27 ms (15.53%) |
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 500365 506982 516870 460516 609540 590899 432707 466317 425003 529180 474984 532355 543314 402793 490440 414038 663835 675071 478184 557946 603663 598204 484398 529434 448991 542944 557949 557943 599055 587416 624137 615774 438725 470924 491130 402784 428020 450178 488604 521078 502418 520890 527943 461346 551437 552770 567187 646937 653596 610002 586687 809466 728143 634811 802763 434361 462349 481725 442520 470130 442864 443934 469876 398949 465352 470514 503304 495744 496935 497240 498656 501623 502663 521483 536664 421108 421201 416292 458429 459907 495459 473372 552323 595061 471196 680590 520482 527721 466157 595682 412132 600833 450440 495096 529438 402378 432831 449717 455945 454972 507310 514104 521653 535342 500504 525349 546594 570397 543924 557938 677279 559551 590881 590887 604710 728930 775958 426710 466291 424443 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.07%) |
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 398949 402378 402784 402793 412132 414038 416292 421108 421201 424443 425003 426710 428020 432707 432831 434361 438725 442520 442864 443934 448991 449717 450178 450440 454972 455945 458429 459907 460516 461346 462349 465352 466157 466291 466317 469876 470130 470514 470924 471196 473372 474984 478184 481725 484398 488604 490440 491130 495096 495459 495744 496935 497240 498656 500365 500504 501623 502418 502663 503304 506982 507310 514104 516870 520482 520890 521078 521483 521653 525349 527721 527943 529180 529434 529438 532355 535342 536664 542944 543314 543924 546594 551437 552323 552770 557938 557943 557946 557949 559551 567187 570397 586687 587416 590881 590887 590899 595061 595682 598204 599055 600833 603663 604710 609540 610002 615774 624137 634811 646937 653596 663835 675071 677279 680590 728143 728930 775958 802763 809466 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur facesitting"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.89%) |
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.