Query Metrics
7
Database Queries
7
Different statements
183.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.19 ms (86.76%) |
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 384289 384411 385313 385438 387106 388401 389923 391715 399310 416921 417888 420201 422335 426152 426200 433766 434709 434724 445730 450251 452532 454711 462223 463747 468783 470315 472755 476155 476157 486275 491487 508103 512902 516436 527499 533922 536271 550732 554307 556418 559961 561730 564771 565054 565468 565470 565483 571049 571050 572709 574578 574813 581633 587587 588811 590089 591955 593878 595447 595538 596039 598087 598492 598670 598726 598781 598814 600460 600583 603371 604222 605329 605331 605334 617493 618920 619427 620141 622607 622623 622699 624238 625699 642401 645389 647839 659314 670762 671578 674688 675409 676518 682495 683559 685612 691235 694192 696129 697291 697298 699026 699587 702634 704773 712971 713063 715095 719102 720050 720397 724722 729940 742124 757897 759660 770325 804337 820686 821599 824351 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (8.44%) |
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 696129 571049 388401 598087 389923 491487 595447 757897 385313 571050 593878 697291 729940 691235 512902 384289 699026 561730 682495 645389 463747 387106 462223 699587 622623 683559 596039 508103 559961 824351 715095 724722 619427 434709 702634 600460 720397 591955 600583 625699 704773 742124 770325 697298 588811 450251 574813 605329 433766 587587 420201 713063 454711 642401 468783 550732 712971 470315 598670 598726 536271 452532 476157 516436 647839 719102 694192 598814 804337 476155 565054 385438 384411 821599 527499 565483 675409 676518 574578 590089 565470 622607 426200 556418 572709 674688 598492 620141 622699 533922 671578 598781 604222 605331 605334 434724 417888 426152 565468 391715 486275 554307 720050 445730 820686 472755 581633 659314 685612 670762 603371 618920 624238 595538 759660 617493 399310 416921 422335 564771 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.35%) |
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 384289 384411 385313 385438 387106 388401 389923 391715 399310 416921 417888 420201 422335 426152 426200 433766 434709 434724 445730 450251 452532 454711 462223 463747 468783 470315 472755 476155 476157 486275 491487 508103 512902 516436 527499 533922 536271 550732 554307 556418 559961 561730 564771 565054 565468 565470 565483 571049 571050 572709 574578 574813 581633 587587 588811 590089 591955 593878 595447 595538 596039 598087 598492 598670 598726 598781 598814 600460 600583 603371 604222 605329 605331 605334 617493 618920 619427 620141 622607 622623 622699 624238 625699 642401 645389 647839 659314 670762 671578 674688 675409 676518 682495 683559 685612 691235 694192 696129 697291 697298 699026 699587 702634 704773 712971 713063 715095 719102 720050 720397 724722 729940 742124 757897 759660 770325 804337 820686 821599 824351 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy teen small"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая teen маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая teen маленькая"
]
|
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.