Query Metrics
7
Database Queries
7
Different statements
163.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.20 ms (76.00%) |
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 35344 383590 390040 391049 400143 400517 401059 401971 404478 404698 405947 409506 409894 415299 418928 420357 421219 423332 426399 431812 433835 444775 446148 446550 448669 448731 450195 451491 451880 453082 454200 454329 460188 460629 460669 462317 464381 464971 469475 470461 472012 472438 477581 478525 479053 479779 484508 486894 487517 489299 491673 492234 492268 494786 495507 501875 507590 512536 512952 516221 516655 518493 519093 522768 523345 524292 524560 524796 525302 526531 526536 528084 531594 538915 548278 553208 554526 554626 554790 558132 559822 561425 564717 566758 568641 569304 573941 576711 584484 584752 586503 589116 590954 591369 592440 593441 604093 615738 615751 615979 620135 622981 624090 689379 714748 750063 789665 790802 791048 791738 792554 801636 802642 802723 803086 808621 816553 816882 820871 824791 ] |
||||||||||||||||||||||||||||||
|
29.28 ms (17.92%) |
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 802642 750063 431812 401971 460188 453082 451880 472012 472438 495507 524796 418928 444775 464971 487517 492234 486894 512952 446148 791738 524560 35344 401059 415299 816553 824791 454200 460629 446550 479053 479779 516221 531594 523345 516655 477581 714748 561425 604093 615738 615751 801636 802723 808621 464381 420357 450195 448731 451491 507590 525302 462317 554626 554526 404698 426399 390040 405947 423332 816882 454329 469475 512536 524292 538915 559822 553208 566758 568641 558132 590954 620135 622981 589116 624090 790802 792554 803086 791048 400143 478525 400517 470461 489299 494786 484508 491673 501875 404478 448669 526531 433835 409894 421219 820871 526536 492268 569304 689379 564717 584752 591369 592440 615979 593441 586503 409506 518493 519093 383590 391049 460669 554790 528084 522768 548278 573941 584484 576711 789665 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.53%) |
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 35344 383590 390040 391049 400143 400517 401059 401971 404478 404698 405947 409506 409894 415299 418928 420357 421219 423332 426399 431812 433835 444775 446148 446550 448669 448731 450195 451491 451880 453082 454200 454329 460188 460629 460669 462317 464381 464971 469475 470461 472012 472438 477581 478525 479053 479779 484508 486894 487517 489299 491673 492234 492268 494786 495507 501875 507590 512536 512952 516221 516655 518493 519093 522768 523345 524292 524560 524796 525302 526531 526536 528084 531594 538915 548278 553208 554526 554626 554790 558132 559822 561425 564717 566758 568641 569304 573941 576711 584484 584752 586503 589116 590954 591369 592440 593441 604093 615738 615751 615979 620135 622981 624090 689379 714748 750063 789665 790802 791048 791738 792554 801636 802642 802723 803086 808621 816553 816882 820871 824791 ] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot milf волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot milf hairy"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot milf волосатая"
]
|
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.