Query Metrics
7
Database Queries
7
Different statements
213.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.67 ms (84.72%) |
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 233353 237293 350425 383338 384262 384752 387899 388291 390747 391583 400935 401053 401804 402151 408249 408464 411710 411985 413053 413827 415541 415570 418969 422255 425524 427543 432735 437176 437784 441022 441251 444542 447494 451716 452767 453156 457971 458327 460141 472531 477908 478484 478832 486556 504261 512973 529846 537199 538031 540334 544381 547974 550379 552047 555158 555793 556030 556427 559040 560426 560429 561991 563234 565254 568580 574451 574490 575020 584234 587885 592462 597101 598042 600856 601381 609147 612856 613845 614718 614867 619520 621438 628363 628396 628397 628398 630187 630524 633114 633497 633733 637427 644192 662376 698124 701310 726520 726529 726532 726546 727022 746852 747597 764333 770462 772113 776521 779346 781761 785438 790882 794933 796129 797264 803081 803776 804099 807334 816776 817398 ] |
||||||||||||||||||||||||||||||
|
20.03 ms (9.39%) |
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 633733 633114 512973 529846 565254 568580 472531 478832 427543 384262 237293 350425 408464 411985 817398 538031 584234 550379 552047 555793 600856 614718 779346 726520 772113 413053 453156 460141 418969 401804 441251 597101 803776 477908 698124 544381 547974 609147 614867 444542 630187 598042 601381 441022 413827 408249 411710 816776 574451 587885 644192 781761 804099 807334 794933 803081 726529 747597 764333 770462 797264 233353 560429 556427 612856 486556 727022 437176 457971 458327 628396 387899 402151 613845 628398 628397 633497 701310 390747 537199 556030 630524 400935 415570 478484 555158 540334 621438 746852 452767 384752 383338 388291 437784 575020 560426 574490 790882 726546 451716 391583 447494 504261 637427 628363 401053 415541 422255 425524 432735 559040 563234 662376 561991 592462 776521 726532 785438 796129 619520 ] |
||||||||||||||||||||||||||||||
|
4.37 ms (2.05%) |
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 233353 237293 350425 383338 384262 384752 387899 388291 390747 391583 400935 401053 401804 402151 408249 408464 411710 411985 413053 413827 415541 415570 418969 422255 425524 427543 432735 437176 437784 441022 441251 444542 447494 451716 452767 453156 457971 458327 460141 472531 477908 478484 478832 486556 504261 512973 529846 537199 538031 540334 544381 547974 550379 552047 555158 555793 556030 556427 559040 560426 560429 561991 563234 565254 568580 574451 574490 575020 584234 587885 592462 597101 598042 600856 601381 609147 612856 613845 614718 614867 619520 621438 628363 628396 628397 628398 630187 630524 633114 633497 633733 637427 644192 662376 698124 701310 726520 726529 726532 726546 727022 746852 747597 764333 770462 772113 776521 779346 781761 785438 790882 794933 796129 797264 803081 803776 804099 807334 816776 817398 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hard young"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck hard young"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hard young"
]
|
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.