Query Metrics
7
Database Queries
7
Different statements
164.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.47 ms (79.53%) |
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 14232 14365 14599 32766 81565 180923 287540 382217 382362 384803 386728 389315 396540 396575 396593 396704 396718 396745 398053 403726 404384 404418 406363 408508 414101 416090 419600 420383 425627 429171 433555 433823 433863 437517 451431 457295 457296 465669 525039 529311 529330 529887 531602 532752 535467 536570 536585 543866 543894 554797 554834 575197 575909 580752 583313 595706 601198 602061 604500 606392 606657 606780 613015 619487 620487 622582 641003 643964 650263 650506 661969 669192 669564 673731 675008 681511 681643 693220 701309 701406 707290 709935 715089 715523 715553 716088 719807 719832 720924 722520 722527 724283 728225 728442 729160 729883 731481 731888 732442 732892 733307 735942 737673 741308 747879 748195 755222 757480 792561 800475 802432 802467 805307 806089 812372 814512 815852 822286 826232 826521 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (10.36%) |
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 529887 529330 669564 601198 802467 728225 403726 805307 675008 575197 404384 707290 543866 719807 641003 457295 465669 701309 643964 619487 732892 620487 701406 715553 806089 396745 622582 396593 396718 420383 815852 536570 650506 800475 731481 735942 384803 396704 543894 722520 693220 709935 802432 747879 748195 755222 757480 729160 732442 180923 382362 408508 826232 724283 792561 14232 398053 429171 433823 814512 457296 529311 535467 532752 536585 554797 681643 715089 720924 719832 606392 613015 733307 741308 287540 416090 14599 389315 396575 826521 650263 673731 729883 81565 451431 396540 433555 437517 414101 531602 580752 661969 669192 715523 722527 575909 583313 595706 602061 606780 812372 731888 728442 737673 604500 606657 404418 425627 386728 406363 433863 14365 382217 419600 32766 822286 525039 554834 681511 716088 ] |
||||||||||||||||||||||||||||||
|
7.08 ms (4.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock секс"
]
|
||||||||||||||||||||||||||||||
|
3.27 ms (1.99%) |
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 14232 14365 14599 32766 81565 180923 287540 382217 382362 384803 386728 389315 396540 396575 396593 396704 396718 396745 398053 403726 404384 404418 406363 408508 414101 416090 419600 420383 425627 429171 433555 433823 433863 437517 451431 457295 457296 465669 525039 529311 529330 529887 531602 532752 535467 536570 536585 543866 543894 554797 554834 575197 575909 580752 583313 595706 601198 602061 604500 606392 606657 606780 613015 619487 620487 622582 641003 643964 650263 650506 661969 669192 669564 673731 675008 681511 681643 693220 701309 701406 707290 709935 715089 715523 715553 716088 719807 719832 720924 722520 722527 724283 728225 728442 729160 729883 731481 731888 732442 732892 733307 735942 737673 741308 747879 748195 755222 757480 792561 800475 802432 802467 805307 806089 812372 814512 815852 822286 826232 826521 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock fuck"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock секс"
]
|
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.