Query Metrics
7
Database Queries
7
Different statements
379.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.15 ms (55.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
141.88 ms (37.39%) |
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 185428 185855 384420 385390 387328 390950 397855 401456 404600 405194 405203 407549 409109 409258 412068 412983 415623 418740 419124 425003 426433 431080 437875 441005 442276 443380 448088 448705 450326 454323 456291 457953 464557 466540 467273 467544 474151 477337 479860 482079 482684 487514 489410 491458 492940 494396 495772 497057 498865 498882 501732 501749 501777 503122 503887 506669 508485 513779 516972 517217 518780 519841 519886 523871 524607 526604 542944 551352 551404 552127 552198 559518 560396 561686 565946 570077 572037 572827 577320 579290 580769 581938 582024 586662 590813 596412 596908 597503 601644 606731 607007 609731 610255 621412 624731 624931 643415 648876 654149 654315 659394 659905 661099 666225 676463 702662 722751 722851 722889 727400 730352 734707 735625 738894 748331 760938 787222 791539 809361 813917 ] |
||||||||||||||||||||||||||||||
|
19.33 ms (5.10%) |
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 559518 659394 809361 501777 409109 482684 722889 482079 405203 409258 457953 503887 415623 561686 579290 607007 479860 418740 501749 384420 601644 727400 760938 477337 450326 426433 437875 464557 552127 467544 813917 523871 494396 390950 443380 624931 643415 501732 519841 454323 676463 441005 412068 467273 596908 407549 497057 498865 581938 448705 492940 666225 405194 401456 590813 519886 542944 425003 185855 387328 503122 404600 466540 572827 722751 577320 596412 722851 524607 442276 572037 606731 419124 412983 495772 586662 560396 702662 624731 498882 448088 526604 513779 489410 518780 661099 730352 580769 621412 748331 609731 517217 610255 654315 551352 397855 456291 508485 570077 582024 491458 659905 648876 654149 431080 385390 474151 516972 487514 738894 185428 791539 787222 734707 735625 552198 597503 506669 565946 551404 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (0.69%) |
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 185428 185855 384420 385390 387328 390950 397855 401456 404600 405194 405203 407549 409109 409258 412068 412983 415623 418740 419124 425003 426433 431080 437875 441005 442276 443380 448088 448705 450326 454323 456291 457953 464557 466540 467273 467544 474151 477337 479860 482079 482684 487514 489410 491458 492940 494396 495772 497057 498865 498882 501732 501749 501777 503122 503887 506669 508485 513779 516972 517217 518780 519841 519886 523871 524607 526604 542944 551352 551404 552127 552198 559518 560396 561686 565946 570077 572037 572827 577320 579290 580769 581938 582024 586662 590813 596412 596908 597503 601644 606731 607007 609731 610255 621412 624731 624931 643415 648876 654149 654315 659394 659905 661099 666225 676463 702662 722751 722851 722889 727400 730352 734707 735625 738894 748331 760938 787222 791539 809361 813917 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс массаж"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck in massage"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.40%) |
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.