Query Metrics
7
Database Queries
7
Different statements
173.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.10 ms (83.11%) |
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 396168 451832 453121 460212 464385 465234 468065 474916 477335 481844 484418 487435 488120 489893 491497 498047 504759 512433 515184 516472 516970 517784 518768 519087 519769 519993 520008 520346 520728 521526 523780 524542 525525 525745 526248 527124 527243 527414 534320 537686 542550 547730 551454 552874 553054 555081 556835 557083 558046 558523 559120 560648 561296 562487 563211 563929 564636 564740 565170 565786 566703 567139 568357 569559 575144 576058 576089 578008 578396 580151 586485 587377 589716 590601 590989 591118 591141 591783 591784 595449 595489 596365 597503 598118 598807 598838 599392 599483 599514 600149 600570 600987 601886 602003 603077 604085 608395 608416 608560 612348 615979 618525 620546 621449 622223 624833 624859 625414 625913 627097 637030 653213 653463 654464 659035 659905 676472 677698 677973 679076 ] |
||||||||||||||||||||||||||||||
|
19.79 ms (11.42%) |
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 608395 521526 519087 653463 555081 557083 563211 604085 526248 484418 520728 527243 453121 474916 481844 591118 527414 598838 625913 653213 615979 600987 602003 551454 565170 598118 580151 637030 477335 659035 677973 654464 518768 523780 464385 519993 520008 525525 465234 468065 517784 516970 519769 488120 566703 618525 553054 562487 595449 504759 563929 677698 586485 587377 591141 600149 460212 512433 625414 515184 567139 547730 558523 564636 556835 565786 624833 624859 591783 600570 558046 598807 622223 621449 608416 627097 559120 537686 487435 491497 676472 542550 597503 608560 578008 552874 568357 576058 569559 560648 596365 590601 590989 564740 451832 612348 575144 534320 527124 601886 396168 589716 516472 599392 576089 599514 561296 659905 591784 599483 489893 520346 525745 524542 578396 679076 620546 595489 603077 498047 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.42%) |
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 396168 451832 453121 460212 464385 465234 468065 474916 477335 481844 484418 487435 488120 489893 491497 498047 504759 512433 515184 516472 516970 517784 518768 519087 519769 519993 520008 520346 520728 521526 523780 524542 525525 525745 526248 527124 527243 527414 534320 537686 542550 547730 551454 552874 553054 555081 556835 557083 558046 558523 559120 560648 561296 562487 563211 563929 564636 564740 565170 565786 566703 567139 568357 569559 575144 576058 576089 578008 578396 580151 586485 587377 589716 590601 590989 591118 591141 591783 591784 595449 595489 596365 597503 598118 598807 598838 599392 599483 599514 600149 600570 600987 601886 602003 603077 604085 608395 608416 608560 612348 615979 618525 620546 621449 622223 624833 624859 625414 625913 627097 637030 653213 653463 654464 659035 659905 676472 677698 677973 679076 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой член в шортах"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член в шорт"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член в шорт"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.90%) |
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.