Query Metrics
7
Database Queries
7
Different statements
209.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.66 ms (84.63%) |
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 282264 384811 396778 399659 405561 414975 415444 416253 416420 421712 423321 423684 424329 425996 426432 428281 430969 437451 437655 442148 443320 444780 445808 446204 447896 450435 450565 451642 452229 452497 453713 453890 454636 454858 454965 455797 456713 457554 458879 459158 460036 460436 462968 464619 465861 466165 466268 466712 467988 468450 469277 469424 469862 470310 471812 472654 473772 474108 475167 476071 477653 479928 481315 482242 484598 486801 486860 489014 490852 491146 491166 492415 492614 494798 499784 500249 500562 506562 508478 509217 509712 509869 509881 509904 511066 511310 511823 512471 512893 513276 513983 514640 515059 517151 517383 517386 518091 518521 519023 519300 520330 520878 521376 521687 521739 522049 522297 522543 522806 523030 523505 524915 529070 531513 532980 538145 538212 548555 583139 589041 ] |
||||||||||||||||||||||||||||||
|
22.13 ms (10.54%) |
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 514640 521739 529070 490852 282264 459158 492415 456713 469277 444780 479928 460436 521376 519300 447896 464619 509712 509904 523030 524915 442148 414975 471812 522297 466268 486860 512471 500562 454636 466165 423684 508478 583139 443320 384811 416253 421712 426432 445808 451642 454858 465861 469862 472654 474108 462968 538145 532980 499784 515059 460036 489014 548555 405561 453713 453890 477653 430969 466712 482242 458879 467988 470310 475167 428281 437655 468450 437451 450565 476071 481315 509217 509881 513276 538212 486801 491146 492614 500249 517151 518091 523505 494798 511310 511823 512893 513983 517383 589041 473772 424329 517386 522806 520330 446204 452497 484598 509869 531513 519023 506562 491166 520878 511066 469424 521687 518521 522543 522049 396778 399659 423321 415444 416420 425996 452229 454965 455797 450435 457554 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.26%) |
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 282264 384811 396778 399659 405561 414975 415444 416253 416420 421712 423321 423684 424329 425996 426432 428281 430969 437451 437655 442148 443320 444780 445808 446204 447896 450435 450565 451642 452229 452497 453713 453890 454636 454858 454965 455797 456713 457554 458879 459158 460036 460436 462968 464619 465861 466165 466268 466712 467988 468450 469277 469424 469862 470310 471812 472654 473772 474108 475167 476071 477653 479928 481315 482242 484598 486801 486860 489014 490852 491146 491166 492415 492614 494798 499784 500249 500562 506562 508478 509217 509712 509869 509881 509904 511066 511310 511823 512471 512893 513276 513983 514640 515059 517151 517383 517386 518091 518521 519023 519300 520330 520878 521376 521687 521739 522049 522297 522543 522806 523030 523505 524915 529070 531513 532980 538145 538212 548555 583139 589041 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra white"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
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.