Query Metrics
7
Database Queries
7
Different statements
195.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.04 ms (86.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 229389 302443 388803 389602 391150 406105 411488 413277 415894 419198 419970 420515 423663 424606 426399 426481 429107 430261 430397 431691 436758 446497 446745 447761 447881 450255 450287 450378 452427 452897 453208 454755 456190 458007 458678 464266 469054 469737 470061 471063 471077 471088 471113 471969 472155 475407 476063 479148 479204 480226 480428 480494 480837 483346 486765 495172 510546 522689 527920 529988 530942 530943 536375 548465 549794 549800 550031 550032 553517 558172 566653 567063 567888 568208 569050 570956 571193 580359 582444 584046 591106 592975 595867 596632 598557 601529 602328 602556 614805 633163 650748 652886 660834 667250 692421 700250 742348 771519 781857 803046 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (7.96%) |
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 471077 570956 592975 471969 229389 522689 429107 652886 700250 450378 536375 692421 548465 614805 742348 469054 595867 447881 452897 446497 453208 550032 553517 602556 302443 456190 480494 406105 419970 470061 480428 411488 549800 436758 430397 596632 580359 391150 424606 476063 530942 567888 584046 602328 591106 781857 479148 452427 454755 495172 423663 450287 567063 415894 388803 568208 549794 650748 571193 483346 527920 803046 430261 471063 566653 480837 389602 458678 469737 569050 447761 450255 510546 431691 471113 771519 420515 660834 426481 479204 480226 475407 530943 558172 582444 458007 413277 419198 486765 667250 529988 426399 446745 601529 598557 633163 471088 472155 550031 464266 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (1.90%) |
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 229389 302443 388803 389602 391150 406105 411488 413277 415894 419198 419970 420515 423663 424606 426399 426481 429107 430261 430397 431691 436758 446497 446745 447761 447881 450255 450287 450378 452427 452897 453208 454755 456190 458007 458678 464266 469054 469737 470061 471063 471077 471088 471113 471969 472155 475407 476063 479148 479204 480226 480428 480494 480837 483346 486765 495172 510546 522689 527920 529988 530942 530943 536375 548465 549794 549800 550031 550032 553517 558172 566653 567063 567888 568208 569050 570956 571193 580359 582444 584046 591106 592975 595867 596632 598557 601529 602328 602556 614805 633163 650748 652886 660834 667250 692421 700250 742348 771519 781857 803046 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cam girl masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
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.