Query Metrics
7
Database Queries
7
Different statements
161.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.44 ms (85.33%) |
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 469 397536 417049 417173 417947 418401 426051 428375 436174 437723 441757 442510 446049 447281 449265 449332 450015 450020 450038 450074 450509 451770 457808 461306 464245 465989 466704 476475 479479 481001 482639 489324 490964 497609 501027 505865 509451 521196 522804 527970 528901 533736 536072 536129 543330 545712 548664 550940 551160 551203 551623 552211 555487 557295 558048 558387 558573 560480 560967 562565 564459 564802 565808 570409 570922 573286 573936 574942 575507 576357 577614 580206 581961 583157 584118 587587 588175 588879 589583 594282 595447 596985 603013 610078 616989 617606 619230 619811 621394 626609 627310 629833 630457 673092 682963 692127 693374 706411 708799 716374 718022 718060 721249 750514 753895 761688 764728 767504 773059 775384 775402 780350 784513 784712 784732 786432 791500 804783 807243 823309 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (8.28%) |
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 557295 558048 560967 616989 595447 610078 626609 627310 775384 775402 791500 804783 764728 784513 786432 750514 773059 767504 718022 784732 436174 466704 450509 417049 437723 450020 521196 469 397536 418401 482639 450038 450074 536072 555487 577614 545712 552211 562565 570409 574942 693374 716374 718060 548664 580206 587587 596985 621394 629833 619811 588175 588879 594282 617606 619230 589583 603013 630457 780350 761688 784712 753895 807243 426051 481001 417947 428375 447281 476475 417173 527970 497609 522804 441757 442510 823309 449332 446049 449265 457808 461306 479479 489324 450015 451770 465989 490964 509451 501027 528901 505865 536129 533736 464245 543330 550940 551160 551203 565808 570922 575507 576357 583157 584118 551623 564459 573286 558387 558573 560480 564802 573936 581961 721249 673092 692127 706411 682963 708799 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.88%) |
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 469 397536 417049 417173 417947 418401 426051 428375 436174 437723 441757 442510 446049 447281 449265 449332 450015 450020 450038 450074 450509 451770 457808 461306 464245 465989 466704 476475 479479 481001 482639 489324 490964 497609 501027 505865 509451 521196 522804 527970 528901 533736 536072 536129 543330 545712 548664 550940 551160 551203 551623 552211 555487 557295 558048 558387 558573 560480 560967 562565 564459 564802 565808 570409 570922 573286 573936 574942 575507 576357 577614 580206 581961 583157 584118 587587 588175 588879 589583 594282 595447 596985 603013 610078 616989 617606 619230 619811 621394 626609 627310 629833 630457 673092 682963 692127 693374 706411 708799 716374 718022 718060 721249 750514 753895 761688 764728 767504 773059 775384 775402 780350 784513 784712 784732 786432 791500 804783 807243 823309 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.07%) |
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.