Query Metrics
7
Database Queries
7
Different statements
151.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.44 ms (83.85%) |
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 4463 24855 146508 187516 187903 188437 197736 233029 358466 366052 386648 387422 388761 390888 391163 391492 391517 391659 391875 395891 395914 395927 395930 395955 397439 397899 397902 397937 398553 400813 411324 411370 419518 422353 424419 424430 424467 425275 443378 443725 444144 444255 454564 458711 460287 460738 462022 462949 464484 465791 466213 467497 469903 470581 470639 470959 471107 472905 473740 474659 475880 475896 475911 476275 477596 477720 479085 482627 485678 485936 486349 486894 488955 489388 490193 490888 490910 492222 495238 506214 509082 509222 509434 511832 523841 533609 537267 555063 555065 555092 555123 555135 555138 558914 560383 563151 573726 580356 581931 600314 610473 618861 620220 620252 620255 620260 620266 620268 712561 715424 718746 721454 721463 741729 754361 758152 758417 781694 788833 824585 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (10.32%) |
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 490910 470581 454564 721463 395955 388761 422353 558914 555065 555135 620220 462022 471107 470639 443725 474659 537267 490888 509434 390888 411370 424430 397439 509082 580356 788833 425275 477596 488955 391163 395927 391659 188437 476275 400813 464484 465791 366052 146508 424419 469903 482627 560383 395914 187516 391517 397937 610473 718746 620255 754361 475896 581931 391492 466213 506214 485678 489388 473740 467497 477720 475911 460287 485936 391875 444144 511832 492222 24855 233029 395891 443378 470959 555063 712561 715424 555092 600314 620260 741729 458711 397902 781694 197736 573726 486894 523841 462949 4463 187903 475880 479085 758417 397899 411324 386648 509222 563151 555123 555138 618861 620268 620252 620266 419518 424467 495238 486349 398553 472905 358466 444255 533609 490193 824585 721454 758152 387422 395930 460738 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.66%) |
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 4463 24855 146508 187516 187903 188437 197736 233029 358466 366052 386648 387422 388761 390888 391163 391492 391517 391659 391875 395891 395914 395927 395930 395955 397439 397899 397902 397937 398553 400813 411324 411370 419518 422353 424419 424430 424467 425275 443378 443725 444144 444255 454564 458711 460287 460738 462022 462949 464484 465791 466213 467497 469903 470581 470639 470959 471107 472905 473740 474659 475880 475896 475911 476275 477596 477720 479085 482627 485678 485936 486349 486894 488955 489388 490193 490888 490910 492222 495238 506214 509082 509222 509434 511832 523841 533609 537267 555063 555065 555092 555123 555135 555138 558914 560383 563151 573726 580356 581931 600314 610473 618861 620220 620252 620255 620260 620266 620268 712561 715424 718746 721454 721463 741729 754361 758152 758417 781694 788833 824585 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian blonde mature"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск беловолосая mature"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск беловолосая mature"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.93%) |
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.