Query Metrics
7
Database Queries
7
Different statements
382.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.76 ms (55.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother big cock"
]
|
||||||||||||||||||||||||||||||
|
143.80 ms (37.57%) |
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 33917 89895 365989 382073 387676 388219 388374 396706 400850 400851 400931 404706 407313 410393 417746 418084 418452 422211 422264 422813 424931 427660 428844 431341 432766 444060 451522 452100 452301 452862 457413 459639 459835 460672 460690 461186 462605 463156 463874 463960 464154 464198 464814 464975 466021 466401 466721 472344 474597 476178 476247 477123 478036 481445 482074 483412 486061 487579 488745 489871 491399 494064 496536 498089 504738 510222 513817 523852 531331 549833 557557 559684 605156 629412 635916 638533 638557 642753 654174 666582 668537 677724 703900 705558 706622 712330 715891 717918 720888 724256 725389 725571 726621 726646 728262 728443 729247 730959 731888 734373 739706 743780 743934 748231 754457 757388 759873 759929 761134 788607 792631 795337 800402 807452 815117 815299 815391 817284 820070 825114 ] |
||||||||||||||||||||||||||||||
|
17.18 ms (4.49%) |
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 720888 743934 728262 748231 496536 404706 817284 815117 820070 513817 483412 717918 605156 635916 638533 724256 731888 642753 788607 452862 422211 677724 807452 466401 725571 715891 491399 510222 396706 418452 486061 463960 477123 459835 476178 481445 461186 559684 549833 800402 726621 705558 89895 407313 418084 463874 422813 472344 654174 668537 759929 432766 478036 400850 487579 825114 815299 464975 466021 504738 431341 452100 427660 388374 629412 743780 33917 387676 417746 424931 761134 531331 712330 795337 725389 726646 523852 452301 388219 728443 729247 444060 464198 466721 459639 476247 498089 464814 482074 557557 638557 792631 703900 706622 400851 410393 462605 463156 365989 451522 474597 400931 422264 457413 464154 489871 488745 494064 382073 428844 730959 739706 460672 734373 757388 815391 460690 759873 666582 754457 ] |
||||||||||||||||||||||||||||||
|
4.60 ms (1.20%) |
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 33917 89895 365989 382073 387676 388219 388374 396706 400850 400851 400931 404706 407313 410393 417746 418084 418452 422211 422264 422813 424931 427660 428844 431341 432766 444060 451522 452100 452301 452862 457413 459639 459835 460672 460690 461186 462605 463156 463874 463960 464154 464198 464814 464975 466021 466401 466721 472344 474597 476178 476247 477123 478036 481445 482074 483412 486061 487579 488745 489871 491399 494064 496536 498089 504738 510222 513817 523852 531331 549833 557557 559684 605156 629412 635916 638533 638557 642753 654174 666582 668537 677724 703900 705558 706622 712330 715891 717918 720888 724256 725389 725571 726621 726646 728262 728443 729247 730959 731888 734373 739706 743780 743934 748231 754457 757388 759873 759929 761134 788607 792631 795337 800402 807452 815117 815299 815391 817284 820070 825114 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин большие cock"
]
|
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.