Query Metrics
7
Database Queries
7
Different statements
214.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.24 ms (83.11%) |
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 385348 392423 396577 397340 399396 399869 402262 407759 408179 408695 409061 409084 409747 413078 414342 414375 414651 415128 415224 417880 417898 418867 419807 420357 420742 421516 421704 422708 423320 426411 427289 428458 429267 429741 429909 435497 435720 439194 439540 445182 446555 446856 446972 448300 449679 450371 454328 457839 457963 458780 458991 460279 462466 463977 464969 465095 468063 469274 469536 470516 471814 472004 473491 475262 476241 477731 478877 480806 482098 484298 485129 485287 486150 487294 491860 495126 498620 499862 506346 513188 516060 521256 521564 524496 525556 526042 526669 527452 531907 537922 541368 556525 563732 569987 581726 586508 586518 592500 592996 598298 607667 615838 624787 624802 633498 682562 695183 742849 776531 792171 805439 806019 814883 815559 815735 816547 818235 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
26.60 ms (12.40%) |
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 526669 805439 420357 392423 399396 421516 413078 409084 818387 819565 821409 815559 816547 449679 450371 485129 446972 465095 454328 476241 531907 513188 469274 592500 607667 586508 776531 792171 429267 385348 418867 419807 408695 407759 446555 414651 458780 435497 463977 525556 521256 414375 484298 408179 435720 409061 420742 429741 417880 818235 814883 458991 457839 468063 491860 485287 495126 537922 498620 499862 521564 569987 541368 695183 682562 556525 624787 624802 598298 615838 806019 415224 396577 448300 417898 439194 460279 477731 409747 480806 482098 471814 506346 486150 527452 633498 428458 815735 469536 478877 581726 457963 399869 402262 415128 423320 414342 421704 426411 429909 427289 422708 464969 487294 446856 475262 473491 526042 516060 524496 563732 592996 586518 742849 439540 462466 472004 445182 470516 397340 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.23%) |
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 385348 392423 396577 397340 399396 399869 402262 407759 408179 408695 409061 409084 409747 413078 414342 414375 414651 415128 415224 417880 417898 418867 419807 420357 420742 421516 421704 422708 423320 426411 427289 428458 429267 429741 429909 435497 435720 439194 439540 445182 446555 446856 446972 448300 449679 450371 454328 457839 457963 458780 458991 460279 462466 463977 464969 465095 468063 469274 469536 470516 471814 472004 473491 475262 476241 477731 478877 480806 482098 484298 485129 485287 486150 487294 491860 495126 498620 499862 506346 513188 516060 521256 521564 524496 525556 526042 526669 527452 531907 537922 541368 556525 563732 569987 581726 586508 586518 592500 592996 598298 607667 615838 624787 624802 633498 682562 695183 742849 776531 792171 805439 806019 814883 815559 815735 816547 818235 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy huge cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая огромные cock"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая огромные cock"
]
|
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.