Query Metrics
7
Database Queries
7
Different statements
324.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
296.75 ms (91.59%) |
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 395818 412363 418934 419555 421070 424443 424457 424484 425043 425316 426203 426543 426710 430833 432807 432869 439733 445751 446501 447916 448831 450510 451929 452084 452144 454027 454262 455265 456609 462101 464139 465333 465954 466090 466291 466494 466733 466915 468374 469534 470159 470506 471183 471612 473787 474550 474561 476119 476299 476628 482292 482506 484435 484699 485708 486399 487348 487763 489108 491775 494983 494987 496835 501465 502247 505400 510287 515122 516989 517492 517874 518011 518441 518582 518751 521852 522604 522610 523861 524777 524879 528682 531437 533541 533966 536293 540498 541607 543924 550382 554770 556025 563536 566288 569533 570725 580368 581620 585798 586690 588283 590130 590943 595783 596462 602960 603653 607398 607620 616711 625526 640531 662396 669188 670089 689702 702678 716882 776312 802121 ] |
||||||||||||||||||||||||||||||
|
17.41 ms (5.37%) |
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 476628 424457 425316 454262 465954 470159 466494 446501 445751 448831 522610 523861 489108 517874 496835 510287 491775 518582 466733 474561 456609 471612 451929 494987 533541 528682 566288 776312 462101 471183 518751 524777 531437 563536 570725 554770 580368 602960 603653 556025 669188 517492 468374 418934 482506 505400 518441 586690 395818 466090 494983 616711 450510 670089 689702 607398 521852 426543 412363 421070 452144 454027 466915 470506 476119 476299 447916 455265 482292 501465 540498 516989 536293 518011 487348 550382 569533 581620 541607 543924 716882 585798 595783 607620 596462 588283 590130 590943 625526 802121 640531 702678 426710 432807 439733 466291 432869 465333 419555 424443 424484 425043 430833 474550 426203 473787 485708 486399 484699 522604 487763 484435 662396 464139 469534 452084 524879 515122 533966 502247 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (0.98%) |
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 395818 412363 418934 419555 421070 424443 424457 424484 425043 425316 426203 426543 426710 430833 432807 432869 439733 445751 446501 447916 448831 450510 451929 452084 452144 454027 454262 455265 456609 462101 464139 465333 465954 466090 466291 466494 466733 466915 468374 469534 470159 470506 471183 471612 473787 474550 474561 476119 476299 476628 482292 482506 484435 484699 485708 486399 487348 487763 489108 491775 494983 494987 496835 501465 502247 505400 510287 515122 516989 517492 517874 518011 518441 518582 518751 521852 522604 522610 523861 524777 524879 528682 531437 533541 533966 536293 540498 541607 543924 550382 554770 556025 563536 566288 569533 570725 580368 581620 585798 586690 588283 590130 590943 595783 596462 602960 603653 607398 607620 616711 625526 640531 662396 669188 670089 689702 702678 716882 776312 802121 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature 69 position"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature поз position 69"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature поз position 69"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.46%) |
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.