Query Metrics
7
Database Queries
7
Different statements
210.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.37 ms (87.94%) |
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 307339 384489 394548 400143 404300 404859 405012 406720 412007 415863 425069 426691 427009 429859 430377 430635 439639 439700 439718 442447 443806 444141 445221 449879 451458 452086 453311 455453 457850 462489 463726 464047 464337 464429 465394 465957 466026 468192 468843 469983 470290 471334 471491 471605 472235 473952 474848 475169 478801 480553 482254 482346 482799 483417 484554 484704 485988 486271 489275 489285 492333 492541 493548 495666 499883 504446 505739 505836 508243 508535 512377 512402 513521 513626 514650 515313 515812 515986 517622 518214 520029 520142 520154 520710 522498 522515 523019 524350 525469 526833 527174 533965 538145 544123 555341 564137 565987 565995 566983 567028 567088 570126 572541 576266 583452 584638 586962 589656 596424 601485 604990 611310 617040 617682 623940 630781 643252 671863 733026 746167 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (7.95%) |
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 520154 464337 576266 746167 508243 430635 566983 451458 452086 489275 429859 443806 473952 430377 522498 475169 468192 522515 474848 512377 515986 394548 480553 515812 630781 468843 643252 404300 493548 471491 505739 471334 617682 733026 567028 455453 463726 492541 471605 604990 596424 412007 464429 478801 449879 482254 538145 469983 527174 470290 482346 445221 405012 520142 453311 426691 505836 485988 404859 495666 508535 515313 486271 611310 523019 586962 564137 439700 472235 504446 517622 513521 520029 466026 623940 499883 439639 457850 462489 526833 583452 544123 465394 442447 489285 524350 512402 570126 483417 439718 533965 492333 671863 307339 406720 513626 484554 415863 425069 482799 525469 565995 617040 400143 444141 601485 465957 589656 427009 464047 584638 565987 520710 555341 384489 518214 572541 484704 567088 514650 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.24%) |
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 307339 384489 394548 400143 404300 404859 405012 406720 412007 415863 425069 426691 427009 429859 430377 430635 439639 439700 439718 442447 443806 444141 445221 449879 451458 452086 453311 455453 457850 462489 463726 464047 464337 464429 465394 465957 466026 468192 468843 469983 470290 471334 471491 471605 472235 473952 474848 475169 478801 480553 482254 482346 482799 483417 484554 484704 485988 486271 489275 489285 492333 492541 493548 495666 499883 504446 505739 505836 508243 508535 512377 512402 513521 513626 514650 515313 515812 515986 517622 518214 520029 520142 520154 520710 522498 522515 523019 524350 525469 526833 527174 533965 538145 544123 555341 564137 565987 565995 566983 567028 567088 570126 572541 576266 583452 584638 586962 589656 596424 601485 604990 611310 617040 617682 623940 630781 643252 671863 733026 746167 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с мамой в спальне…"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин в спальн"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.60%) |
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.