Query Metrics
7
Database Queries
7
Different statements
243.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.03 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.91 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower naked"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.85 ms |
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 444098 448177 519116 521956 486152 620754 442643 408659 421325 427561 451121 454415 457182 457643 500194 513992 459970 564822 715869 548265 624537 635998 638165 411352 445581 470918 394488 453427 447431 468959 518581 527360 487628 517934 490018 439158 437663 516205 474087 549362 572631 584366 577582 571034 810765 792612 467066 439611 442864 453806 470449 497225 501374 513824 422633 457469 504414 490916 552498 581665 618622 431832 474394 465051 409035 457420 465222 527038 454364 454923 482304 555681 596309 444344 418361 442946 476706 546511 549830 613463 593185 462949 504908 512927 522191 509135 574200 460443 523492 510668 ] |
||||||||||||||||||||||||||||||
| 4 | 3.27 ms |
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 394488 408659 409035 411352 418361 421325 422633 427561 431832 437663 439158 439611 442643 442864 442946 444098 444344 445581 447431 448177 451121 453427 453806 454364 454415 454923 457182 457420 457469 457643 459970 460443 462949 465051 465222 467066 468959 470449 470918 474087 474394 476706 482304 486152 487628 490018 490916 497225 500194 501374 504414 504908 509135 510668 512927 513824 513992 516205 517934 518581 519116 521956 522191 523492 527038 527360 546511 548265 549362 549830 552498 555681 564822 571034 572631 574200 577582 581665 584366 593185 596309 613463 618622 620754 624537 635998 638165 715869 792612 810765 ] |
||||||||||||||||||||||||||||||
| 5 | 212.38 ms |
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 394488 408659 409035 411352 418361 421325 422633 427561 431832 437663 439158 439611 442643 442864 442946 444098 444344 445581 447431 448177 451121 453427 453806 454364 454415 454923 457182 457420 457469 457643 459970 460443 462949 465051 465222 467066 468959 470449 470918 474087 474394 476706 482304 486152 487628 490018 490916 497225 500194 501374 504414 504908 509135 510668 512927 513824 513992 516205 517934 518581 519116 521956 522191 523492 527038 527360 546511 548265 549362 549830 552498 555681 564822 571034 572631 574200 577582 581665 584366 593185 596309 613463 618622 620754 624537 635998 638165 715869 792612 810765 ] |
||||||||||||||||||||||||||||||
| 6 | 2.13 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower голые"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.79 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower голые"
]
|
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.