Query Metrics
7
Database Queries
7
Different statements
380.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.44 ms (55.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая красивая"
]
|
||||||||||||||||||||||||||||||
|
141.55 ms (37.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 7950 29295 38135 38637 83894 192551 239808 260350 308684 382827 383542 385125 386793 390346 391206 392458 396605 398710 401476 404740 405854 406928 409173 415419 415658 417880 419346 419832 424284 425033 428003 431302 445067 445551 446484 447879 449135 450070 451573 451578 452825 453668 454721 454996 457748 459607 459831 462742 468818 470193 474101 474289 477496 479762 483681 488293 495588 497071 497311 499125 499709 504345 511910 514730 520803 521306 521934 525842 535648 545456 551212 558948 562126 562702 564417 573051 580702 587864 589830 590511 591530 594830 597590 600314 605515 605845 607091 609835 617759 618889 642295 642662 652596 653239 684574 693184 693209 693536 712882 713014 714449 722670 736394 741074 747147 750004 754786 760480 766777 768587 771320 775078 776191 779711 781630 793244 797235 805278 805472 809463 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (4.21%) |
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 779711 415419 425033 642295 693184 652596 741074 747147 451573 474289 488293 446484 590511 457748 521306 562126 684574 722670 600314 736394 605515 450070 431302 545456 617759 766777 573051 396605 642662 445067 504345 445551 514730 562702 520803 597590 468818 497071 525842 392458 453668 470193 809463 462742 564417 580702 459607 452825 495588 454721 551212 419832 499709 447879 449135 459831 607091 417880 714449 428003 511910 415658 499125 451578 454996 477496 404740 479762 497311 605845 594830 587864 618889 406928 38637 383542 308684 260350 385125 38135 483681 713014 398710 589830 793244 805472 750004 29295 653239 591530 405854 419346 83894 535648 775078 401476 391206 239808 521934 693209 805278 781630 776191 754786 797235 386793 474101 424284 609835 7950 382827 760480 712882 409173 693536 771320 390346 192551 558948 768587 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (1.09%) |
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 7950 29295 38135 38637 83894 192551 239808 260350 308684 382827 383542 385125 386793 390346 391206 392458 396605 398710 401476 404740 405854 406928 409173 415419 415658 417880 419346 419832 424284 425033 428003 431302 445067 445551 446484 447879 449135 450070 451573 451578 452825 453668 454721 454996 457748 459607 459831 462742 468818 470193 474101 474289 477496 479762 483681 488293 495588 497071 497311 499125 499709 504345 511910 514730 520803 521306 521934 525842 535648 545456 551212 558948 562126 562702 564417 573051 580702 587864 589830 590511 591530 594830 597590 600314 605515 605845 607091 609835 617759 618889 642295 642662 652596 653239 684574 693184 693209 693536 712882 713014 714449 722670 736394 741074 747147 750004 754786 760480 766777 768587 771320 775078 776191 779711 781630 793244 797235 805278 805472 809463 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde beautiful"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.53%) |
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.