Query Metrics
7
Database Queries
7
Different statements
266.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
236.08 ms (88.68%) |
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 3444 24944 98871 146508 327659 359134 365893 384340 391594 415548 423837 443704 453311 459254 462584 466064 466205 468076 469774 471414 472857 473261 474089 479989 482304 482441 484540 486270 489989 490030 491209 497699 501556 505826 506318 509114 511826 517238 517540 517610 518573 518583 524470 528401 529713 530509 533198 533642 534243 539450 543448 547414 549825 552844 555732 555776 555959 560093 563187 563206 570730 581599 587180 588895 588911 589408 590952 591130 600394 604306 607096 614032 619791 620307 621152 621310 621350 652446 660006 664817 665250 665940 667293 667538 682145 686009 695603 703554 710265 711671 716192 716299 720410 726590 737185 739613 746021 756431 759756 760454 761743 762379 766537 766767 767272 789740 790752 792507 795136 799352 799802 799947 804458 806356 808449 814359 815263 815866 816050 818283 ] |
||||||||||||||||||||||||||||||
|
20.56 ms (7.72%) |
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 469774 528401 384340 391594 327659 3444 98871 415548 423837 814359 815263 818283 815866 816050 472857 489989 490030 462584 466064 486270 501556 517610 530509 509114 529713 524470 533198 533642 534243 471414 482441 484540 563206 555732 563187 570730 552844 560093 581599 665940 667293 695603 652446 664817 665250 667538 686009 710265 660006 703554 720410 547414 555776 555959 588911 620307 621152 587180 589408 614032 588895 590952 604306 619791 607096 621310 799352 799802 792507 761743 767272 789740 790752 795136 808449 759756 737185 746021 766537 739613 760454 762379 726590 756431 766767 621350 711671 716192 716299 799947 804458 806356 24944 473261 146508 359134 459254 365893 466205 517238 517540 506318 482304 443704 468076 491209 479989 453311 505826 511826 518573 497699 518583 539450 474089 543448 549825 682145 600394 591130 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.18%) |
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 3444 24944 98871 146508 327659 359134 365893 384340 391594 415548 423837 443704 453311 459254 462584 466064 466205 468076 469774 471414 472857 473261 474089 479989 482304 482441 484540 486270 489989 490030 491209 497699 501556 505826 506318 509114 511826 517238 517540 517610 518573 518583 524470 528401 529713 530509 533198 533642 534243 539450 543448 547414 549825 552844 555732 555776 555959 560093 563187 563206 570730 581599 587180 588895 588911 589408 590952 591130 600394 604306 607096 614032 619791 620307 621152 621310 621350 652446 660006 664817 665250 665940 667293 667538 682145 686009 695603 703554 710265 711671 716192 716299 720410 726590 737185 739613 746021 756431 759756 760454 761743 762379 766537 766767 767272 789740 790752 792507 795136 799352 799802 799947 804458 806356 808449 814359 815263 815866 816050 818283 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature milf shower"
]
|
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.