Query Metrics
7
Database Queries
7
Different statements
194.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.53 ms (87.27%) |
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 72386 202134 204992 382200 385759 395625 396993 398044 403549 404684 406191 407064 419308 421418 429602 435703 436588 440642 442201 442290 444422 445922 452194 452334 454569 454621 454942 455775 456579 457207 457581 460809 463978 464093 464097 464120 464340 465664 465680 472659 476309 477032 480517 484539 486647 487726 494086 495336 507668 517741 518347 523087 529256 529688 530523 536728 554867 590078 590733 591693 594500 597682 597853 601008 607478 623645 626118 634200 638483 644190 644943 646097 647669 653179 663494 669224 669563 669564 674049 674063 674662 678483 707308 716052 716881 717140 723991 732323 737305 739671 745034 750685 750848 759267 759269 765245 778148 784533 795393 796372 797641 805489 806092 806197 806198 814894 815142 815241 815779 815801 815814 815927 815939 816034 816053 816441 816484 816516 820559 823295 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.66%) |
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 745034 750685 815241 204992 816034 805489 382200 778148 398044 759269 464120 716881 406191 717140 72386 634200 464340 407064 495336 452334 456579 436588 653179 674662 815814 815939 815779 644190 444422 454942 669224 674063 678483 591693 723991 737305 739671 797641 463978 601008 457207 440642 669563 597682 759267 403549 806197 823295 716052 815142 707308 626118 820559 638483 395625 445922 816484 816053 494086 465664 396993 806198 404684 816516 517741 590733 202134 518347 594500 476309 480517 421418 815927 385759 530523 669564 646097 429602 644943 607478 806092 750848 663494 623645 536728 529256 507668 523087 452194 597853 460809 484539 674049 814894 815801 442201 454569 464093 554867 795393 816441 455775 477032 647669 590078 457581 486647 784533 796372 765245 465680 419308 442290 464097 529688 472659 487726 732323 435703 454621 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.73%) |
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 72386 202134 204992 382200 385759 395625 396993 398044 403549 404684 406191 407064 419308 421418 429602 435703 436588 440642 442201 442290 444422 445922 452194 452334 454569 454621 454942 455775 456579 457207 457581 460809 463978 464093 464097 464120 464340 465664 465680 472659 476309 477032 480517 484539 486647 487726 494086 495336 507668 517741 518347 523087 529256 529688 530523 536728 554867 590078 590733 591693 594500 597682 597853 601008 607478 623645 626118 634200 638483 644190 644943 646097 647669 653179 663494 669224 669563 669564 674049 674063 674662 678483 707308 716052 716881 717140 723991 732323 737305 739671 745034 750685 750848 759267 759269 765245 778148 784533 795393 796372 797641 805489 806092 806197 806198 814894 815142 815241 815779 815801 815814 815927 815939 816034 816053 816441 816484 816516 820559 823295 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil booty sex"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл booty секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"масл booty секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.75%) |
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.