Query Metrics
7
Database Queries
7
Different statements
166.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.32 ms (83.08%) |
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 4131 7051 74830 102441 157617 177496 181184 365938 379777 382032 383107 383355 384542 384798 384888 384984 385782 386625 387014 387318 388115 389157 392393 393526 396215 397876 402793 416241 419667 420094 420526 420881 424524 424812 428319 430936 431228 436510 444586 452286 454697 454973 457217 458587 470867 473235 473910 476844 482326 485262 489032 500302 513135 515199 515201 519978 523150 523906 537001 538216 540543 543510 548780 549943 550610 554647 555847 555850 556324 556858 558072 558432 559837 560302 561820 561853 566247 568581 568621 570595 573614 576100 584506 587637 591070 593883 595011 595022 595682 595755 597852 598851 603148 603549 609729 616973 622830 623815 625991 645663 649080 654417 663863 664841 674269 675025 679355 679702 682530 682902 684547 689498 701302 710832 724418 750525 793595 800579 826696 827963 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (10.75%) |
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 701302 424524 549943 625991 379777 679355 157617 800579 555850 4131 548780 485262 430936 664841 515199 550610 750525 102441 384542 682530 609729 482326 684547 436510 576100 388115 523150 679702 556324 523906 710832 558072 393526 402793 420094 682902 570595 396215 538216 383107 543510 385782 654417 561853 473235 649080 616973 560302 566247 595011 595755 597852 181184 689498 554647 458587 724418 420526 384798 593883 382032 595682 519978 428319 365938 591070 573614 387014 452286 454697 675025 540543 397876 674269 584506 470867 419667 513135 420881 424812 476844 416241 622830 587637 645663 384888 558432 389157 444586 387318 384984 555847 568581 556858 473910 603148 561820 7051 74830 603549 537001 623815 431228 827963 386625 177496 383355 454973 457217 598851 515201 568621 663863 489032 826696 595022 793595 559837 392393 500302 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.50%) |
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 4131 7051 74830 102441 157617 177496 181184 365938 379777 382032 383107 383355 384542 384798 384888 384984 385782 386625 387014 387318 388115 389157 392393 393526 396215 397876 402793 416241 419667 420094 420526 420881 424524 424812 428319 430936 431228 436510 444586 452286 454697 454973 457217 458587 470867 473235 473910 476844 482326 485262 489032 500302 513135 515199 515201 519978 523150 523906 537001 538216 540543 543510 548780 549943 550610 554647 555847 555850 556324 556858 558072 558432 559837 560302 561820 561853 566247 568581 568621 570595 573614 576100 584506 587637 591070 593883 595011 595022 595682 595755 597852 598851 603148 603549 609729 616973 622830 623815 625991 645663 649080 654417 663863 664841 674269 675025 679355 679702 682530 682902 684547 689498 701302 710832 724418 750525 793595 800579 826696 827963 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни девушка верхом"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс девушк наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс девушк наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
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.