Query Metrics
7
Database Queries
7
Different statements
415.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.21 ms (50.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
182.47 ms (43.92%) |
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 398263 398972 407442 423971 426294 438487 441799 443518 443579 443581 443588 443629 443632 444918 445838 447238 453415 454171 454561 454565 454956 456979 459379 459446 459472 459637 459897 459959 466886 469284 469420 470410 470834 471653 476316 482952 483885 485599 485689 486553 487575 489721 495278 506075 511061 513581 517452 519754 523622 524617 526682 527842 527919 529294 532471 537354 543970 545631 550685 552569 554110 554793 560828 563734 566351 566387 568228 571131 574267 578169 582440 583287 584010 584045 585964 587298 588430 589242 592386 592690 593728 599638 600502 601660 609071 610647 615031 615919 620119 630670 640350 641807 658445 658477 667756 706029 707464 707518 714925 732782 733503 747186 750948 757724 758154 758170 761066 771642 772062 781826 781873 781875 781924 781925 784964 794622 795295 797341 802291 819353 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (3.63%) |
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 543970 582440 583287 706029 658477 707518 568228 584010 584045 610647 620119 640350 784964 797341 732782 733503 772062 758154 771642 781925 443632 456979 459959 398972 454561 470410 527919 495278 707464 443579 443629 819353 454171 469420 459446 466886 445838 447238 459379 476316 532471 526682 537354 506075 571131 578169 552569 667756 563734 588430 587298 593728 781873 802291 794622 758170 750948 795295 423971 454565 443588 459897 469284 483885 459472 658445 600502 566351 601660 615919 630670 443518 589242 524617 566387 574267 545631 599638 615031 485599 407442 438487 441799 453415 454956 459637 471653 485689 486553 487575 517452 513581 519754 523622 511061 489721 554793 550685 554110 714925 560828 641807 592690 609071 585964 592386 781924 781826 757724 781875 747186 761066 470834 529294 527842 482952 444918 398263 443581 426294 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (0.62%) |
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 398263 398972 407442 423971 426294 438487 441799 443518 443579 443581 443588 443629 443632 444918 445838 447238 453415 454171 454561 454565 454956 456979 459379 459446 459472 459637 459897 459959 466886 469284 469420 470410 470834 471653 476316 482952 483885 485599 485689 486553 487575 489721 495278 506075 511061 513581 517452 519754 523622 524617 526682 527842 527919 529294 532471 537354 543970 545631 550685 552569 554110 554793 560828 563734 566351 566387 568228 571131 574267 578169 582440 583287 584010 584045 585964 587298 588430 589242 592386 592690 593728 599638 600502 601660 609071 610647 615031 615919 620119 630670 640350 641807 658445 658477 667756 706029 707464 707518 714925 732782 733503 747186 750948 757724 758154 758170 761066 771642 772062 781826 781873 781875 781924 781925 784964 794622 795295 797341 802291 819353 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw home made"
]
|
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.