Query Metrics
7
Database Queries
7
Different statements
374.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.71 ms (58.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел white"
]
|
||||||||||||||||||||||||||||||
|
131.73 ms (35.18%) |
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 6690 383285 395541 400005 415105 419214 430495 431471 437294 437309 445874 449206 449231 450587 452183 452563 456556 457633 459539 460872 461710 462258 463581 464246 467690 467805 474789 479253 480607 481573 483021 484153 484226 484723 485391 485510 489964 490185 491347 491904 492551 493277 493968 494013 499330 499969 500069 504117 504270 504823 505877 505933 507012 507329 507771 509391 509819 510219 511955 513725 513923 514151 514203 514417 514422 514873 515651 516786 517978 518041 518174 518548 518824 518956 520222 521082 521664 523130 524684 525565 526060 526396 526600 529096 529549 533188 534484 534615 535258 535636 535893 536153 536367 537102 537166 539613 543077 544172 546428 552522 576863 641488 777304 788706 799717 815236 815496 815519 819188 821100 821156 821410 821991 822180 822551 822933 823083 823528 828250 828569 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (4.41%) |
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 452563 415105 516786 518824 521664 493968 526600 504823 507771 490185 514151 523130 431471 430495 437309 445874 449231 459539 460872 484723 449206 461710 462258 452183 457633 509391 514873 507329 510219 464246 467690 463581 467805 479253 437294 480607 481573 450587 456556 499969 509819 513725 515651 517978 518548 526396 484226 507012 511955 514417 518041 518174 524684 525565 491347 493277 514422 526060 491904 492551 494013 500069 504270 505877 513923 529096 529549 383285 395541 6690 400005 419214 815236 822551 821410 821991 822933 815496 823083 815519 819188 821100 821156 822180 823528 828250 828569 483021 485391 484153 489964 504117 521082 534484 535636 539613 520222 535258 535893 536153 536367 505933 518956 534615 537102 499330 514203 533188 537166 474789 485510 546428 552522 543077 544172 576863 641488 788706 799717 777304 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (0.86%) |
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 6690 383285 395541 400005 415105 419214 430495 431471 437294 437309 445874 449206 449231 450587 452183 452563 456556 457633 459539 460872 461710 462258 463581 464246 467690 467805 474789 479253 480607 481573 483021 484153 484226 484723 485391 485510 489964 490185 491347 491904 492551 493277 493968 494013 499330 499969 500069 504117 504270 504823 505877 505933 507012 507329 507771 509391 509819 510219 511955 513725 513923 514151 514203 514417 514422 514873 515651 516786 517978 518041 518174 518548 518824 518956 520222 521082 521664 523130 524684 525565 526060 526396 526600 529096 529549 533188 534484 534615 535258 535636 535893 536153 536367 537102 537166 539613 543077 544172 546428 552522 576863 641488 777304 788706 799717 815236 815496 815519 819188 821100 821156 821410 821991 822180 822551 822933 823083 823528 828250 828569 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties white"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел white"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.40%) |
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.