Query Metrics
7
Database Queries
7
Different statements
416.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.08 ms (51.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam сиськ"
]
|
||||||||||||||||||||||||||||||
|
179.44 ms (43.06%) |
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 389495 390389 406105 411488 414277 415544 415557 415579 419970 426478 426479 426611 429032 429107 430122 430397 431691 434991 436758 438770 442998 443532 444005 446264 448579 448582 450287 451598 452897 454139 454652 454740 456876 458230 459252 460567 461351 461561 461564 462934 465680 465996 466306 470061 470194 470394 471113 471116 472106 474903 475291 475876 478947 480494 482688 485317 485905 490178 494487 494488 504167 504272 507815 507986 510546 511428 511740 512310 512810 513277 521760 521904 528524 529149 546613 546681 548465 548752 550480 550716 553186 553194 553205 553601 556998 559673 561432 564641 566409 566886 567063 567759 570956 574846 575798 577119 584046 591106 595867 597043 600341 602556 603491 630856 631258 645426 649202 652683 654048 673574 697172 707687 707695 716536 727794 742596 751354 758648 799619 812279 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (3.83%) |
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 548752 550480 566886 546681 561432 645426 654048 553194 553601 603491 438770 448579 462934 389495 459252 465680 466306 444005 448582 461561 434991 490178 529149 485905 511740 512310 415544 419970 471116 470061 451598 553205 697172 707695 707687 630856 591106 727794 426479 474903 494487 521904 475291 458230 494488 577119 673574 553186 556998 812279 751354 716536 799619 390389 504167 507815 442998 415579 429032 446264 454139 485317 461351 470194 550716 570956 470394 465996 426478 411488 454652 480494 513277 511428 521760 431691 546613 567063 478947 510546 600341 436758 471113 504272 548465 758648 742596 631258 414277 454740 512810 406105 415557 430122 430397 574846 584046 564641 567759 575798 566409 652683 649202 559673 595867 597043 602556 443532 452897 460567 472106 461564 426611 429107 456876 475876 507986 450287 482688 528524 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (0.63%) |
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 389495 390389 406105 411488 414277 415544 415557 415579 419970 426478 426479 426611 429032 429107 430122 430397 431691 434991 436758 438770 442998 443532 444005 446264 448579 448582 450287 451598 452897 454139 454652 454740 456876 458230 459252 460567 461351 461561 461564 462934 465680 465996 466306 470061 470194 470394 471113 471116 472106 474903 475291 475876 478947 480494 482688 485317 485905 490178 494487 494488 504167 504272 507815 507986 510546 511428 511740 512310 512810 513277 521760 521904 528524 529149 546613 546681 548465 548752 550480 550716 553186 553194 553205 553601 556998 559673 561432 564641 566409 566886 567063 567759 570956 574846 575798 577119 584046 591106 595867 597043 600341 602556 603491 630856 631258 645426 649202 652683 654048 673574 697172 707687 707695 716536 727794 742596 751354 758648 799619 812279 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cam on tits"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.40%) |
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.