Query Metrics
7
Database Queries
7
Different statements
367.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.73 ms (57.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard секс большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
134.95 ms (36.69%) |
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 389462 406689 406900 414135 416989 420406 421418 423572 424190 427819 430394 432663 439607 443105 443832 445619 445711 445945 446877 447235 448816 452189 452497 456030 458467 460859 461055 462896 464187 464971 465148 465608 468742 469736 474862 476089 477242 479836 480708 481820 486332 487362 490511 492762 493156 497569 497950 502885 503407 503648 506287 506705 510884 516682 518021 522205 522249 524520 526188 526951 529846 530694 533767 536218 538963 540559 543556 544381 544796 547974 551222 552267 556030 556046 560195 560330 562374 565241 565247 565249 565250 565254 565259 573206 578139 583960 584720 591073 595121 597204 598042 598494 600995 601150 603313 604316 615382 625673 628379 628388 631972 632580 632594 632649 633497 633734 633749 637008 640770 642006 642016 642037 642041 647969 668540 675022 701310 790234 797541 814175 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (4.19%) |
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 493156 445945 464971 573206 465148 522205 552267 578139 647969 565241 565247 632594 628379 628388 416989 423572 560330 565250 497569 487362 633734 432663 536218 565249 544796 510884 469736 452189 468742 480708 556046 461055 668540 481820 503407 421418 603313 445711 604316 526951 447235 526188 506287 503648 584720 430394 625673 497950 562374 601150 640770 790234 439607 389462 642006 583960 631972 633749 464187 530694 642037 598494 560195 632580 600995 642041 424190 465608 406689 406900 477242 538963 675022 642016 492762 529846 565254 543556 814175 443832 524520 540559 615382 448816 420406 544381 547974 502885 797541 446877 595121 445619 462896 443105 479836 522249 533767 598042 490511 452497 591073 427819 460859 518021 516682 414135 474862 506705 476089 551222 597204 637008 486332 565259 633497 701310 556030 632649 456030 458467 ] |
||||||||||||||||||||||||||||||
|
2.54 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 389462 406689 406900 414135 416989 420406 421418 423572 424190 427819 430394 432663 439607 443105 443832 445619 445711 445945 446877 447235 448816 452189 452497 456030 458467 460859 461055 462896 464187 464971 465148 465608 468742 469736 474862 476089 477242 479836 480708 481820 486332 487362 490511 492762 493156 497569 497950 502885 503407 503648 506287 506705 510884 516682 518021 522205 522249 524520 526188 526951 529846 530694 533767 536218 538963 540559 543556 544381 544796 547974 551222 552267 556030 556046 560195 560330 562374 565241 565247 565249 565250 565254 565259 573206 578139 583960 584720 591073 595121 597204 598042 598494 600995 601150 603313 604316 615382 625673 628379 628388 631972 632580 632594 632649 633497 633734 633749 637008 640770 642006 642016 642037 642041 647969 668540 675022 701310 790234 797541 814175 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard fuck gape"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard секс большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.43%) |
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.