Query Metrics
7
Database Queries
7
Different statements
153.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.02 ms (86.20%) |
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 391208 396330 406304 409828 421058 423655 426368 443786 452956 478572 484392 499105 506328 510750 514733 530643 530766 531183 531206 531393 532679 532804 532989 533043 533870 536287 536344 540944 543669 543757 544439 545399 549514 550199 550949 552070 555805 565346 570395 571230 581355 583905 583947 583958 593873 596082 596464 599908 599950 599953 600251 603242 603263 604890 605564 606501 606565 607108 607594 617414 629899 630668 630915 635486 638369 639753 640534 641130 641705 643074 643122 643725 644280 645853 648832 653907 660424 664305 666728 668479 670958 674105 676622 678032 679441 691996 692506 702679 715543 725612 728233 728444 732944 737521 741269 743771 748249 748621 756386 775803 775848 775866 775888 775963 784151 789998 790248 792356 798411 798948 802794 805274 808730 809525 810757 815413 815479 818519 819623 823920 ] |
||||||||||||||||||||||||||||||
|
11.53 ms (7.53%) |
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 643122 599953 600251 640534 775866 805274 741269 756386 617414 641130 644280 775848 775963 396330 409828 506328 484392 543757 668479 666728 670958 715543 645853 653907 550949 583958 630668 638369 605564 643074 775888 802794 748621 732944 725612 606565 426368 819623 823920 815479 818519 570395 581355 691996 692506 679441 583947 603242 635486 643725 607108 593873 789998 808730 809525 810757 775803 798411 748249 784151 728233 728444 743771 603263 792356 555805 532679 606501 596082 531393 544439 664305 607594 641705 596464 798948 737521 443786 391208 406304 423655 815413 478572 452956 499105 531206 532804 536287 530766 532989 533870 536344 531183 533043 530643 540944 550199 571230 545399 549514 583905 565346 648832 676622 660424 678032 604890 599908 599950 630915 639753 790248 629899 702679 421058 510750 514733 552070 543669 674105 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.82%) |
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 391208 396330 406304 409828 421058 423655 426368 443786 452956 478572 484392 499105 506328 510750 514733 530643 530766 531183 531206 531393 532679 532804 532989 533043 533870 536287 536344 540944 543669 543757 544439 545399 549514 550199 550949 552070 555805 565346 570395 571230 581355 583905 583947 583958 593873 596082 596464 599908 599950 599953 600251 603242 603263 604890 605564 606501 606565 607108 607594 617414 629899 630668 630915 635486 638369 639753 640534 641130 641705 643074 643122 643725 644280 645853 648832 653907 660424 664305 666728 668479 670958 674105 676622 678032 679441 691996 692506 702679 715543 725612 728233 728444 732944 737521 741269 743771 748249 748621 756386 775803 775848 775866 775888 775963 784151 789998 790248 792356 798411 798948 802794 805274 808730 809525 810757 815413 815479 818519 819623 823920 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang mother"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.