Query Metrics
7
Database Queries
7
Different statements
149.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.11 ms (81.81%) |
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 7871 33284 34382 56632 105845 192760 358507 365863 383100 383656 384188 384549 386749 388907 390129 390190 391487 391502 397699 401222 402337 411052 424009 425041 426985 429483 430607 438078 438365 452844 453063 453276 454016 458753 459126 460242 463026 466047 467066 468556 468815 469126 473697 475201 475238 475492 475877 477871 483951 486269 497645 502523 505196 509150 511031 518722 518796 521495 523583 524329 524401 525917 526071 530104 538345 539066 543641 557619 560911 565930 574902 579429 581001 592435 592703 593023 593124 603736 606238 606435 616630 616772 623216 626645 642536 650683 651325 662905 666066 666347 679361 679401 684480 685767 691521 695196 697735 707531 712423 712426 712428 728453 728485 733445 734071 738849 740366 741932 744254 746669 749047 753047 784944 787524 795926 802551 803937 806720 810798 825304 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (11.86%) |
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 712426 712428 650683 616772 626645 642536 802551 391502 384549 453063 530104 579429 475238 475877 666347 390190 383656 105845 483951 390129 454016 524329 459126 525917 603736 386749 523583 662905 606435 606238 749047 787524 738849 741932 733445 734071 469126 430607 526071 511031 425041 475492 744254 365863 34382 679401 468556 825304 466047 467066 502523 574902 402337 438078 486269 460242 543641 557619 697735 666066 651325 593124 806720 746669 473697 458753 505196 384188 383100 560911 33284 453276 56632 521495 475201 463026 391487 593023 388907 452844 524401 691521 795926 429483 592703 784944 426985 477871 401222 695196 497645 411052 707531 684480 685767 712423 592435 623216 616630 803937 810798 728485 753047 728453 538345 509150 565930 581001 397699 438365 192760 424009 518796 740366 7871 358507 679361 468815 518722 539066 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.14%) |
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 7871 33284 34382 56632 105845 192760 358507 365863 383100 383656 384188 384549 386749 388907 390129 390190 391487 391502 397699 401222 402337 411052 424009 425041 426985 429483 430607 438078 438365 452844 453063 453276 454016 458753 459126 460242 463026 466047 467066 468556 468815 469126 473697 475201 475238 475492 475877 477871 483951 486269 497645 502523 505196 509150 511031 518722 518796 521495 523583 524329 524401 525917 526071 530104 538345 539066 543641 557619 560911 565930 574902 579429 581001 592435 592703 593023 593124 603736 606238 606435 616630 616772 623216 626645 642536 650683 651325 662905 666066 666347 679361 679401 684480 685767 691521 695196 697735 707531 712423 712426 712428 728453 728485 733445 734071 738849 740366 741932 744254 746669 749047 753047 784944 787524 795926 802551 803937 806720 810798 825304 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.