Query Metrics
7
Database Queries
7
Different statements
208.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.81 ms (86.39%) |
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 154127 389794 403439 414269 416164 418145 419822 420140 420217 423998 434293 434349 438432 442114 443233 443250 445651 446778 453470 457650 460533 462848 467875 469125 471074 473873 475425 475426 476663 477052 483684 499872 504155 511953 513977 516640 517304 517511 519374 521139 521238 521800 523884 525431 525468 526061 526189 530423 531353 538045 545445 548926 550952 554551 554954 556481 556885 556909 557720 558158 559784 559787 567561 578323 582076 583694 584046 586113 589166 598638 598692 598882 604080 612091 619666 621450 621827 626044 636907 640859 662813 668292 672304 679972 687305 692963 701285 705007 711725 712496 716763 716965 728567 728571 728635 734214 735906 736037 739878 742359 745921 749248 752657 753124 787290 788598 789479 792729 793151 794312 796678 796681 796715 796801 796997 797001 802914 803484 808265 811125 ] |
||||||||||||||||||||||||||||||
|
16.95 ms (8.14%) |
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 796678 668292 586113 793151 499872 803484 728571 796681 538045 583694 469125 526061 477052 462848 475425 550952 728567 612091 438432 530423 662813 753124 742359 420217 796715 640859 419822 473873 154127 626044 516640 519374 483684 567561 443233 457650 558158 808265 403439 471074 445651 443250 420140 545445 434349 475426 511953 584046 598882 749248 414269 554551 811125 735906 716965 521800 523884 416164 476663 556909 796801 802914 460533 557720 525468 517304 589166 521238 467875 525431 526189 559784 598638 446778 517511 556885 513977 604080 559787 423998 578323 418145 442114 796997 434293 556481 716763 531353 711725 521139 672304 621827 679972 734214 687305 389794 701285 619666 788598 789479 453470 705007 621450 792729 752657 739878 728635 504155 797001 787290 712496 554954 598692 636907 736037 794312 745921 582076 548926 692963 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (1.92%) |
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 154127 389794 403439 414269 416164 418145 419822 420140 420217 423998 434293 434349 438432 442114 443233 443250 445651 446778 453470 457650 460533 462848 467875 469125 471074 473873 475425 475426 476663 477052 483684 499872 504155 511953 513977 516640 517304 517511 519374 521139 521238 521800 523884 525431 525468 526061 526189 530423 531353 538045 545445 548926 550952 554551 554954 556481 556885 556909 557720 558158 559784 559787 567561 578323 582076 583694 584046 586113 589166 598638 598692 598882 604080 612091 619666 621450 621827 626044 636907 640859 662813 668292 672304 679972 687305 692963 701285 705007 711725 712496 716763 716965 728567 728571 728635 734214 735906 736037 739878 742359 745921 749248 752657 753124 787290 788598 789479 792729 793151 794312 796678 796681 796715 796801 796997 797001 802914 803484 808265 811125 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade dildo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
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.