Query Metrics
7
Database Queries
7
Different statements
367.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.24 ms (56.39%) |
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 415087 416367 417006 418656 419033 419196 419928 426145 426680 429202 429287 429289 437407 437638 438288 442865 445061 446742 450966 452722 454856 455422 456571 461351 464194 464516 465404 467647 468462 468591 471332 471727 471990 473020 473971 474590 474613 475342 476508 477015 477053 477949 480070 480933 482478 483032 484009 485792 486266 486661 486940 486957 487038 489160 491694 493323 493433 494781 495607 500266 501915 503159 503207 503383 509493 509866 510478 513305 515817 515997 516410 516424 520463 523632 524525 526094 526992 527315 543153 543727 546073 546292 548265 548636 551634 552606 552622 555807 557400 559239 560185 560663 561156 564803 566038 566102 569559 569827 572314 572822 575443 578026 578834 584560 586549 587791 590423 591072 594007 600132 600510 601897 614408 652945 729871 736951 747580 757122 791224 ] |
||||||||||||||||||||||||||||||
|
136.50 ms (37.15%) |
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 415087 416367 417006 418656 419033 419196 419928 426145 426680 429202 429287 429289 437407 437638 438288 442865 445061 446742 450966 452722 454856 455422 456571 461351 464194 464516 465404 467647 468462 468591 471332 471727 471990 473020 473971 474590 474613 475342 476508 477015 477053 477949 480070 480933 482478 483032 484009 485792 486266 486661 486940 486957 487038 489160 491694 493323 493433 494781 495607 500266 501915 503159 503207 503383 509493 509866 510478 513305 515817 515997 516410 516424 520463 523632 524525 526094 526992 527315 543153 543727 546073 546292 548265 548636 551634 552606 552622 555807 557400 559239 560185 560663 561156 564803 566038 566102 569559 569827 572314 572822 575443 578026 578834 584560 586549 587791 590423 591072 594007 600132 600510 601897 614408 652945 729871 736951 747580 757122 791224 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (4.66%) |
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 566038 566102 569559 652945 548265 552622 560663 569827 578834 584560 587791 600132 590423 591072 600510 586549 594007 524525 473020 456571 450966 527315 520463 543153 791224 747580 417006 429289 437407 418656 419928 416367 445061 429202 487038 471332 471990 476508 477949 489160 452722 461351 468591 471727 486266 494781 474613 551634 559239 575443 548636 564803 560185 572314 578026 415087 419196 475342 477053 464194 474590 480070 426145 437638 446742 464516 467647 473971 480933 426680 429287 438288 442865 465404 468462 477015 478371 419033 455422 501915 503159 515817 526992 486957 491694 493433 503207 503383 509866 513305 516410 484009 485792 486940 493323 509493 515997 526094 486661 495607 516424 523632 555807 557400 483032 546073 482478 561156 500266 572822 543727 601897 552606 614408 757122 729871 736951 546292 510478 454856 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov small tits"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.41%) |
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.