Query Metrics
7
Database Queries
7
Different statements
629.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.16 ms (34.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 388100 400032 400775 402793 410239 421033 422108 426096 426762 435341 437861 441402 441417 442276 445383 445872 449190 449270 449461 449473 449547 451854 451878 452431 452497 452498 453702 456999 458467 459500 459531 460986 461898 464895 465066 471958 472615 473416 475977 476296 477395 477703 478797 480004 482869 485057 485064 485244 487228 488809 490447 492703 492716 492717 493453 497075 497236 497678 500142 500878 502729 510362 511911 512819 512825 513723 519536 519744 520040 520912 521698 521862 523429 524447 525395 525398 525541 525801 526834 527458 527928 531184 534816 536636 537350 542535 547779 548633 552624 553609 553957 556646 556967 558582 558755 559996 560225 562327 562979 564462 565456 576445 579501 580153 580418 583511 584983 592974 594179 595097 599117 603985 615182 670821 685836 699682 736912 753077 784155 825561 ] |
||||||||||||||||||||||||||||||
|
207.90 ms (33.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
182.35 ms (28.99%) |
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 388100 400032 400775 402793 410239 421033 422108 426096 426762 435341 437861 441402 441417 442276 445383 445872 449190 449270 449461 449473 449547 451854 451878 452431 452497 452498 453702 456999 458467 459500 459531 460986 461898 464895 465066 471958 472615 473416 475977 476296 477395 477703 478797 480004 482869 485057 485064 485244 487228 488809 490447 492703 492716 492717 493453 497075 497236 497678 500142 500878 502729 510362 511911 512819 512825 513723 519536 519744 520040 520912 521698 521862 523429 524447 525395 525398 525541 525801 526834 527458 527928 531184 534816 536636 537350 542535 547779 548633 552624 553609 553957 556646 556967 558582 558755 559996 560225 562327 562979 564462 565456 576445 579501 580153 580418 583511 584983 592974 594179 595097 599117 603985 615182 670821 685836 699682 736912 753077 784155 825561 ] |
||||||||||||||||||||||||||||||
|
18.95 ms (3.01%) |
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 753077 452498 464895 422108 449270 452431 459500 459531 400775 421033 437861 445383 460986 478797 400032 471958 473416 519744 524447 485244 493453 512819 512825 513723 523429 525541 534816 492717 500142 525801 502729 510362 519536 441417 526834 537350 410239 452497 472615 558755 599117 492703 511911 487228 497075 485057 485064 527458 536636 388100 442276 453702 449190 449473 531184 595097 465066 441402 482869 488809 490447 477703 477395 580418 736912 525398 449547 475977 449461 492716 497236 556967 565456 553609 579501 670821 685836 548633 580153 592974 594179 603985 784155 699682 426096 520912 521698 521862 527928 556646 445872 500878 562979 615182 435341 451854 458467 480004 402793 426762 456999 520040 525395 584983 825561 451878 497678 461898 476296 547779 552624 553957 560225 564462 576445 583511 542535 558582 559996 562327 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.25%) |
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.