Query Metrics
7
Database Queries
7
Different statements
197.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.67 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 384200 385471 385913 390255 391072 392423 393049 398053 405846 410841 418306 419155 422524 422529 422602 422762 422776 422934 422969 423199 423243 424740 425764 426200 428527 429129 431323 431811 434759 434803 435644 443845 444938 447797 451981 453247 454833 456005 456167 456176 456622 457266 458844 459819 460953 465194 471133 471355 473746 473763 475817 478431 482237 483708 483809 485302 491452 491512 496108 499036 500570 510578 512174 516812 521177 523326 523399 536525 547518 549320 550197 550733 550776 551017 551973 554333 558366 558368 558372 558410 558426 559873 565976 582863 585857 586585 593405 593431 595690 595819 598621 600559 600806 601132 602044 604799 615002 615625 624759 634413 635160 637737 641492 650957 658198 658989 711820 717274 735604 737146 747984 784604 784613 784624 793636 799394 800504 805226 808754 808886 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (8.26%) |
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 585857 615002 601132 615625 784604 805226 419155 422762 558410 641492 808886 602044 390255 431811 658989 393049 391072 405846 473763 499036 516812 595819 800504 458844 398053 475817 422776 422524 422934 422602 453247 551973 456622 523399 512174 456176 456167 735604 392423 385913 422969 547518 447797 471133 428527 658198 634413 624759 496108 435644 444938 637737 558372 650957 595690 483708 550776 460953 558426 431323 551017 451981 491452 384200 808754 747984 426200 425764 523326 549320 784613 536525 565976 554333 410841 429129 582863 635160 478431 456005 500570 558368 550733 598621 593405 423199 454833 457266 422529 471355 459819 491512 711820 737146 799394 717274 385471 586585 423243 424740 434759 418306 443845 521177 485302 550197 558366 600559 483809 482237 465194 473746 559873 784624 793636 434803 604799 510578 600806 593431 ] |
||||||||||||||||||||||||||||||
|
3.42 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 384200 385471 385913 390255 391072 392423 393049 398053 405846 410841 418306 419155 422524 422529 422602 422762 422776 422934 422969 423199 423243 424740 425764 426200 428527 429129 431323 431811 434759 434803 435644 443845 444938 447797 451981 453247 454833 456005 456167 456176 456622 457266 458844 459819 460953 465194 471133 471355 473746 473763 475817 478431 482237 483708 483809 485302 491452 491512 496108 499036 500570 510578 512174 516812 521177 523326 523399 536525 547518 549320 550197 550733 550776 551017 551973 554333 558366 558368 558372 558410 558426 559873 565976 582863 585857 586585 593405 593431 595690 595819 598621 600559 600806 601132 602044 604799 615002 615625 624759 634413 635160 637737 641492 650957 658198 658989 711820 717274 735604 737146 747984 784604 784613 784624 793636 799394 800504 805226 808754 808886 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob asian"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.