Query Metrics
7
Database Queries
7
Different statements
159.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.62 ms (84.22%) |
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 31329 324568 386759 388578 397172 397182 397619 398567 411907 413139 415753 419969 420178 428108 438488 443518 445720 453244 454565 455121 456022 457431 459446 463260 469420 470834 475289 476316 477472 484063 495861 496720 503483 503974 506075 514761 516002 530097 532634 534963 537507 540383 575259 577268 584027 584031 584048 595532 597104 603198 603407 644082 663362 663417 663478 663911 663931 663971 664285 665461 665478 665833 665894 667279 667541 667559 669749 669755 705355 710916 724309 726043 733148 733505 738673 744204 744218 744466 745952 745975 749020 749598 750162 754057 754063 756809 759714 763134 765781 775140 781772 781773 781833 781841 781845 781858 792643 793649 794796 795295 800080 801091 801527 802256 802274 811883 811884 819261 823771 824354 824509 825070 826059 826595 826602 826694 827201 828006 828604 828714 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (9.48%) |
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 826602 826694 826595 823771 824509 825070 828714 477472 534963 484063 577268 584027 663911 667559 663971 663362 663478 665478 584048 644082 800080 738673 756809 750162 765781 397172 413139 801527 710916 398567 503483 469420 455121 459446 506075 454565 516002 595532 388578 781772 744466 802274 397619 443518 802256 470834 420178 463260 824354 664285 397182 827201 453244 476316 532634 475289 775140 811883 794796 724309 795295 819261 495861 540383 496720 530097 663417 665833 667279 667541 603198 793649 781833 826059 828006 828604 537507 584031 669749 665894 669755 575259 597104 781841 781845 781858 811884 781773 749598 763134 726043 744218 749020 754063 733505 745975 754057 801091 324568 438488 419969 456022 759714 457431 665461 31329 603407 411907 503974 663931 744204 792643 745952 705355 428108 415753 514761 733148 445720 386759 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.66%) |
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 31329 324568 386759 388578 397172 397182 397619 398567 411907 413139 415753 419969 420178 428108 438488 443518 445720 453244 454565 455121 456022 457431 459446 463260 469420 470834 475289 476316 477472 484063 495861 496720 503483 503974 506075 514761 516002 530097 532634 534963 537507 540383 575259 577268 584027 584031 584048 595532 597104 603198 603407 644082 663362 663417 663478 663911 663931 663971 664285 665461 665478 665833 665894 667279 667541 667559 669749 669755 705355 710916 724309 726043 733148 733505 738673 744204 744218 744466 745952 745975 749020 749598 750162 754057 754063 756809 759714 763134 765781 775140 781772 781773 781833 781841 781845 781858 792643 793649 794796 795295 800080 801091 801527 802256 802274 811883 811884 819261 823771 824354 824509 825070 826059 826595 826602 826694 827201 828006 828604 828714 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother bbw"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин bbw"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин bbw"
]
|
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.