Query Metrics
7
Database Queries
7
Different statements
177.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.99 ms (86.68%) |
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 7206 15364 16998 119987 195329 233426 362958 366053 384978 386518 389124 389178 397388 404263 405707 421590 422488 443889 444232 447999 453692 455242 462736 465835 466179 466187 466197 468879 470117 474215 475020 481296 484822 489376 491071 491888 494235 494598 503688 512649 531012 533774 543644 543726 548760 551938 552130 552523 563407 571460 587450 588822 595373 595436 595497 595515 596578 596584 596993 597500 597548 597798 597978 597982 598489 598492 598502 598527 598544 598580 598595 600147 603955 611298 617653 628804 644014 651935 661512 663231 672449 672466 673908 679541 680676 685381 685523 696331 701888 713300 717662 717719 718658 727668 731669 736058 741170 742161 744441 745075 745076 745344 752718 752727 757943 758241 758973 760466 762273 762298 773164 774642 777911 780854 788028 788381 790770 790920 803234 812346 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (7.69%) |
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 731669 617653 397388 119987 679541 598527 597500 773164 760466 788381 774642 742161 462736 685523 788028 780854 543726 595436 405707 389124 468879 7206 717719 597798 595497 673908 595515 494235 717662 596578 503688 455242 696331 701888 790920 195329 598580 466187 233426 603955 596993 727668 447999 598595 598492 812346 752718 491071 491888 494598 484822 489376 548760 598489 758241 758973 552523 597978 597982 600147 596584 628804 745344 736058 481296 595373 762273 752727 745075 16998 803234 404263 444232 470117 453692 611298 598544 386518 366053 531012 421590 533774 680676 466179 762298 790770 384978 512649 543644 15364 422488 475020 757943 672466 744441 389178 563407 685381 587450 362958 741170 661512 672449 651935 598502 718658 466197 474215 597548 777911 552130 571460 551938 713300 644014 745076 443889 663231 588822 465835 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.91%) |
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 7206 15364 16998 119987 195329 233426 362958 366053 384978 386518 389124 389178 397388 404263 405707 421590 422488 443889 444232 447999 453692 455242 462736 465835 466179 466187 466197 468879 470117 474215 475020 481296 484822 489376 491071 491888 494235 494598 503688 512649 531012 533774 543644 543726 548760 551938 552130 552523 563407 571460 587450 588822 595373 595436 595497 595515 596578 596584 596993 597500 597548 597798 597978 597982 598489 598492 598502 598527 598544 598580 598595 600147 603955 611298 617653 628804 644014 651935 661512 663231 672449 672466 673908 679541 680676 685381 685523 696331 701888 713300 717662 717719 718658 727668 731669 736058 741170 742161 744441 745075 745076 745344 752718 752727 757943 758241 758973 760466 762273 762298 773164 774642 777911 780854 788028 788381 790770 790920 803234 812346 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex russian girls"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.82%) |
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.