Query Metrics
7
Database Queries
7
Different statements
217.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.99 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car mature"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.18 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 543605 543612 566148 573914 589761 598941 588309 599740 615735 151445 797186 798939 474519 522914 524948 526545 525662 488132 571199 577349 554413 626760 606533 603247 427832 504769 815462 817507 449425 480412 542194 576623 615909 585744 491021 751224 469736 532357 638298 457645 818251 816506 815948 651356 696310 469113 822000 412083 406820 657782 558089 599217 509151 541822 489769 511559 521572 549708 555977 476613 476621 516433 485405 504970 567468 541804 606292 605288 486415 495275 519387 555986 487758 480394 531608 453340 525626 555991 417811 540476 657775 634794 430976 550475 615800 ] |
||||||||||||||||||||||||||||||
| 4 | 2.50 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 151445 406820 412083 417811 427832 430976 449425 453340 457645 469113 469736 474519 476613 476621 480394 480412 485405 486415 487758 488132 489769 491021 495275 504769 504970 509151 511559 516433 519387 521572 522914 524948 525626 525662 526545 531608 532357 540476 541804 541822 542194 543605 543612 549708 550475 554413 555977 555986 555991 558089 566148 567468 571199 573914 576623 577349 585744 588309 589761 598941 599217 599740 603247 605288 606292 606533 615735 615800 615909 626760 634794 638298 651356 657775 657782 696310 751224 797186 798939 815462 815948 816506 817507 818251 822000 ] |
||||||||||||||||||||||||||||||
| 5 | 193.89 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 151445 406820 412083 417811 427832 430976 449425 453340 457645 469113 469736 474519 476613 476621 480394 480412 485405 486415 487758 488132 489769 491021 495275 504769 504970 509151 511559 516433 519387 521572 522914 524948 525626 525662 526545 531608 532357 540476 541804 541822 542194 543605 543612 549708 550475 554413 555977 555986 555991 558089 566148 567468 571199 573914 576623 577349 585744 588309 589761 598941 599217 599740 603247 605288 606292 606533 615735 615800 615909 626760 634794 638298 651356 657775 657782 696310 751224 797186 798939 815462 815948 816506 817507 818251 822000 ] |
||||||||||||||||||||||||||||||
| 6 | 1.55 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин mature"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.27 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин mature"
]
|
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.