Query Metrics
7
Database Queries
7
Different statements
167.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.86 ms (84.16%) |
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 186948 188117 191343 199188 295200 365910 382295 382562 385999 390224 390455 391392 394425 395930 397215 397221 398209 398459 398545 408240 409312 409349 409934 411353 411745 411761 412975 412983 413081 443423 452121 460762 464138 466801 469575 472677 473829 474080 474479 475842 476224 476262 479053 479063 480293 480296 485775 486470 486485 491950 497701 504850 512608 518729 520867 537830 546715 546716 546953 548182 554323 555242 555287 555428 557244 561990 563066 563173 581004 610094 629816 633115 652856 674104 680437 681312 695196 698496 714604 715572 721955 727735 728083 732852 736422 741744 741877 742786 744194 744989 746689 748656 758091 758096 766663 770113 772406 774171 780710 781753 788394 788680 794869 794895 795213 796101 797259 804013 804940 806241 815785 818833 819258 819480 823351 824268 824585 825318 826661 827857 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (9.46%) |
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 394425 295200 382562 390224 397221 397215 409349 815785 818833 823351 826661 819258 824268 825318 819480 824585 827857 472677 518729 537830 497701 546953 555287 555428 581004 555242 561990 674104 680437 695196 715572 681312 714604 652856 629816 633115 610094 781753 788680 794869 795213 796101 788394 797259 804013 804940 806241 727735 736422 744194 794895 728083 741877 746689 766663 732852 741744 744989 748656 758091 774171 742786 770113 772406 758096 698496 721955 780710 199188 443423 365910 191343 385999 395930 398459 491950 186948 188117 382295 390455 391392 398209 398545 408240 411745 411761 412975 411353 413081 409312 409934 412983 452121 476224 486470 486485 464138 480293 480296 466801 473829 474479 475842 476262 479053 504850 512608 520867 460762 469575 474080 479063 485775 557244 563066 563173 546715 546716 548182 554323 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (2.11%) |
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 186948 188117 191343 199188 295200 365910 382295 382562 385999 390224 390455 391392 394425 395930 397215 397221 398209 398459 398545 408240 409312 409349 409934 411353 411745 411761 412975 412983 413081 443423 452121 460762 464138 466801 469575 472677 473829 474080 474479 475842 476224 476262 479053 479063 480293 480296 485775 486470 486485 491950 497701 504850 512608 518729 520867 537830 546715 546716 546953 548182 554323 555242 555287 555428 557244 561990 563066 563173 581004 610094 629816 633115 652856 674104 680437 681312 695196 698496 714604 715572 721955 727735 728083 732852 736422 741744 741877 742786 744194 744989 746689 748656 758091 758096 766663 770113 772406 774171 780710 781753 788394 788680 794869 794895 795213 796101 797259 804013 804940 806241 815785 818833 819258 819480 823351 824268 824585 825318 826661 827857 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм mature"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм mature"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm mature"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
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.