Query Metrics
7
Database Queries
7
Different statements
565.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.72 ms (37.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine big ass"
]
|
||||||||||||||||||||||||||||||
|
206.35 ms (36.50%) |
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 428235 428305 428553 432270 432294 434080 439417 446107 448082 448551 448914 449024 452822 452824 455902 464844 467112 468233 468495 469096 469636 472257 475415 475422 475426 476657 480477 481226 486243 491126 496240 499919 510956 511869 513221 514086 515265 515272 515423 516640 518183 518185 518187 518505 518891 522151 522163 522182 526164 533841 569756 576125 577122 582396 592593 593486 597878 603391 604721 606549 615022 630406 631301 631321 631331 642042 642065 642835 651632 651863 660417 662856 663158 669589 670956 670970 681804 692654 700682 700693 713156 716001 728363 730338 738480 738487 742421 750623 766294 766830 766939 770169 772235 773846 774842 774874 776997 777001 777762 777921 779769 780065 780067 782419 782894 783214 783319 787095 793962 796640 800502 800508 800543 804159 804465 806413 807142 808115 811325 815270 ] |
||||||||||||||||||||||||||||||
|
123.00 ms (21.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 428235 428305 428553 432270 432294 434080 439417 446107 448082 448551 448914 449024 452822 452824 455902 464844 467112 468233 468495 469096 469636 472257 475415 475422 475426 476657 480477 481226 486243 491126 496240 499919 510956 511869 513221 514086 515265 515272 515423 516640 518183 518185 518187 518505 518891 522151 522163 522182 526164 533841 569756 576125 577122 582396 592593 593486 597878 603391 604721 606549 615022 630406 631301 631321 631331 642042 642065 642835 651632 651863 660417 662856 663158 669589 670956 670970 681804 692654 700682 700693 713156 716001 728363 730338 738480 738487 742421 750623 766294 766830 766939 770169 772235 773846 774842 774874 776997 777001 777762 777921 779769 780065 780067 782419 782894 783214 783319 787095 793962 796640 800502 800508 800543 804159 804465 806413 807142 808115 811325 815270 ] |
||||||||||||||||||||||||||||||
|
18.54 ms (3.28%) |
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 486243 515423 522163 533841 651863 662856 716001 603391 631331 774842 787095 783214 800508 738487 770169 782419 782894 783319 800543 766939 742421 750623 766294 631301 804465 439417 481226 514086 516640 446107 452822 469636 692654 631321 779769 738480 777001 455902 475426 452824 468233 660417 713156 642042 592593 811325 800502 730338 728363 766830 518505 515272 448082 518185 428553 432270 467112 518187 576125 642065 491126 496240 511869 510956 569756 670956 670970 773846 448914 468495 428305 480477 472257 522182 475415 663158 700693 669589 681804 700682 807142 772235 793962 806413 808115 630406 774874 776997 777921 780067 804159 476657 522151 428235 449024 469096 615022 593486 796640 518183 597878 434080 432294 815270 448551 464844 475422 518891 513221 526164 499919 515265 582396 577122 651632 604721 606549 642835 777762 780065 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сексмашин большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.32%) |
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.