Query Metrics
7
Database Queries
7
Different statements
399.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.82 ms (57.50%) |
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 433423 455601 495254 484362 488220 496379 472849 80230 524075 509747 466240 518336 460066 475365 524570 509740 504779 446569 446191 487538 480375 466664 481389 554261 557027 563060 552799 557421 463877 467489 467708 478255 420578 424507 458285 466762 480350 479441 460862 508368 512002 510090 525035 528626 506226 518988 525697 527083 483952 500638 503922 527588 495522 439521 472138 492395 388559 449556 506082 603675 433586 449693 465092 487894 468634 567746 581959 584793 598201 466309 425130 481278 452628 460528 479793 415550 434252 452583 459572 481186 511465 522022 491167 509282 515493 524202 526799 489585 516534 520596 526579 407628 560800 483321 675677 438334 534709 473858 528552 569990 458726 457294 453434 467907 475401 526621 484907 484901 425984 473511 453548 511985 479063 545528 542284 557010 551557 605364 637401 465797 ] |
||||||||||||||||||||||||||||||
|
159.23 ms (39.84%) |
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 80230 388559 407628 415550 420578 424507 425130 425984 433423 433586 434252 438334 439521 446191 446569 449556 449693 452583 452628 453434 453548 455601 457294 458285 458726 459572 460066 460528 460862 463877 465092 465797 466240 466309 466664 466762 467489 467708 467907 468634 472138 472849 473511 473858 475365 475401 478255 479063 479441 479793 480350 480375 481186 481278 481389 483321 483952 484362 484901 484907 487538 487894 488220 489585 491167 492395 495254 495522 496379 500638 503922 504779 506082 506226 508368 509282 509740 509747 510090 511465 511985 512002 515493 516534 518336 518988 520596 522022 524075 524202 524570 525035 525697 526579 526621 526799 527083 527588 528552 528626 534709 542284 545528 551557 552799 554261 557010 557027 557421 560800 563060 567746 569990 581959 584793 598201 603675 605364 637401 675677 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (0.82%) |
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 80230 388559 407628 415550 420578 424507 425130 425984 433423 433586 434252 438334 439521 446191 446569 449556 449693 452583 452628 453434 453548 455601 457294 458285 458726 459572 460066 460528 460862 463877 465092 465797 466240 466309 466664 466762 467489 467708 467907 468634 472138 472849 473511 473858 475365 475401 478255 479063 479441 479793 480350 480375 481186 481278 481389 483321 483952 484362 484901 484907 487538 487894 488220 489585 491167 492395 495254 495522 496379 500638 503922 504779 506082 506226 508368 509282 509740 509747 510090 511465 511985 512002 515493 516534 518336 518988 520596 522022 524075 524202 524570 525035 525697 526579 526621 526799 527083 527588 528552 528626 534709 542284 545528 551557 552799 554261 557010 557027 557421 560800 563060 567746 569990 581959 584793 598201 603675 605364 637401 675677 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел секс"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra fuck"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.