Query Metrics
7
Database Queries
7
Different statements
376.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.78 ms (55.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob big dildo"
]
|
||||||||||||||||||||||||||||||
|
144.30 ms (38.33%) |
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 108925 188031 384118 385661 388862 410962 412194 414114 418466 420383 427339 432955 435549 435794 437807 439151 439532 442430 447597 460072 462079 465334 468220 468482 468661 468733 471088 471153 471668 478463 481297 483946 485350 490953 491103 498915 499957 502468 504060 508541 508565 509833 518611 521829 522161 522363 530124 530372 530482 530765 531107 531183 531217 532748 532854 536266 536340 536344 536608 537913 538484 546083 550536 551018 555075 555599 564864 581136 590169 593296 598406 599967 607355 607631 613000 621235 624739 629411 631358 639735 642065 643080 652513 654257 666969 666974 671083 678125 679491 684660 688990 704236 717859 720478 723618 728269 739558 742681 746096 751035 751571 762673 770383 777039 781922 782861 788360 790629 793683 795406 797051 799725 805146 805151 806692 806904 807219 809046 814989 816547 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (4.07%) |
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 581136 805151 481297 460072 536266 666974 590169 793683 742681 437807 502468 530482 536340 814989 420383 717859 471153 671083 508541 384118 485350 108925 678125 509833 684660 447597 809046 546083 816547 688990 652513 795406 536344 531183 639735 521829 414114 442430 531107 777039 504060 728269 751571 799725 410962 432955 427339 550536 491103 629411 607355 471088 654257 790629 782861 746096 806904 435549 388862 607631 631358 806692 739558 770383 624739 498915 483946 468661 598406 723618 530124 666969 679491 788360 781922 797051 555599 643080 412194 531217 751035 522363 593296 518611 532854 468220 538484 642065 530765 530372 613000 439532 462079 418466 555075 805146 551018 439151 599967 468733 508565 385661 537913 532748 536608 471668 522161 468482 490953 621235 499957 435794 478463 704236 762673 807219 465334 564864 188031 720478 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.78%) |
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 108925 188031 384118 385661 388862 410962 412194 414114 418466 420383 427339 432955 435549 435794 437807 439151 439532 442430 447597 460072 462079 465334 468220 468482 468661 468733 471088 471153 471668 478463 481297 483946 485350 490953 491103 498915 499957 502468 504060 508541 508565 509833 518611 521829 522161 522363 530124 530372 530482 530765 531107 531183 531217 532748 532854 536266 536340 536344 536608 537913 538484 546083 550536 551018 555075 555599 564864 581136 590169 593296 598406 599967 607355 607631 613000 621235 624739 629411 631358 639735 642065 643080 652513 654257 666969 666974 671083 678125 679491 684660 688990 704236 717859 720478 723618 728269 739558 742681 746096 751035 751571 762673 770383 777039 781922 782861 788360 790629 793683 795406 797051 799725 805146 805151 806692 806904 807219 809046 814989 816547 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.43%) |
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.