Query Metrics
7
Database Queries
7
Different statements
211.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.82 ms (87.53%) |
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 383483 393241 403087 408245 412474 415444 415831 416253 421712 425313 428281 429577 430969 440717 442148 442422 449078 450565 452497 453729 453903 456173 457255 458326 459004 459747 460359 462328 462968 463659 463963 463987 465006 466712 468850 469424 471130 472028 472654 473364 473434 475315 475840 476212 478236 479457 481195 483131 483248 484598 485561 488764 489181 489197 489705 495474 497211 497268 499160 499344 500562 504458 506100 506354 507935 509881 511066 512027 513276 515059 517386 519023 520330 520878 521687 522049 522487 522806 524585 524925 526250 526736 527242 527533 527589 527719 531513 548046 552168 552402 553970 554915 558858 560230 560571 560607 562740 563575 567088 570266 571515 574715 575065 576161 576342 576629 579660 586482 593138 595494 599532 601677 614953 620714 621992 623814 626978 664798 677025 682153 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (7.66%) |
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 415444 383483 453903 471130 457255 512027 430969 497268 393241 481195 495474 614953 567088 442148 521687 677025 519023 511066 553970 576629 463987 601677 682153 416253 500562 517386 626978 469424 570266 560607 558858 428281 520878 465006 586482 456173 476212 421712 571515 593138 509881 513276 475315 599532 484598 522806 527533 403087 442422 472654 462968 515059 552402 563575 429577 499344 562740 488764 408245 575065 460359 473364 527589 506100 526736 415831 449078 576342 468850 522487 466712 450565 483131 527242 489705 507935 489197 483248 497211 499160 527719 554915 574715 664798 440717 478236 458326 459747 463659 504458 524925 489181 531513 552168 412474 520330 472028 576161 473434 452497 621992 475840 524585 595494 579660 526250 506354 463963 479457 453729 485561 522049 560230 560571 623814 425313 462328 620714 459004 548046 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.32%) |
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 383483 393241 403087 408245 412474 415444 415831 416253 421712 425313 428281 429577 430969 440717 442148 442422 449078 450565 452497 453729 453903 456173 457255 458326 459004 459747 460359 462328 462968 463659 463963 463987 465006 466712 468850 469424 471130 472028 472654 473364 473434 475315 475840 476212 478236 479457 481195 483131 483248 484598 485561 488764 489181 489197 489705 495474 497211 497268 499160 499344 500562 504458 506100 506354 507935 509881 511066 512027 513276 515059 517386 519023 520330 520878 521687 522049 522487 522806 524585 524925 526250 526736 527242 527533 527589 527719 531513 548046 552168 552402 553970 554915 558858 560230 560571 560607 562740 563575 567088 570266 571515 574715 575065 576161 576342 576629 579660 586482 593138 595494 599532 601677 614953 620714 621992 623814 626978 664798 677025 682153 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.