Query Metrics
7
Database Queries
7
Different statements
183.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.33 ms (87.39%) |
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 118450 188335 392964 393284 393479 396154 396333 396786 398376 401076 404120 418622 425541 441092 443248 458223 458531 468430 472323 473190 478482 490859 508873 514034 521294 544861 562587 567122 576505 577401 582036 587573 595367 597111 597267 597865 604347 610271 624920 629243 629458 629604 630451 632887 642158 643619 645333 656921 669717 672388 677428 682397 689525 690450 691381 692718 695464 697311 697806 700011 700506 704255 704261 712805 716121 717984 718663 718669 721875 722261 722642 723230 728362 729337 730350 735140 737011 737140 742935 743165 746935 747398 748787 749237 749669 751441 754070 754887 756118 757368 760919 762225 766945 775710 779707 782745 784292 787332 791638 792065 798183 799974 800587 800593 803989 804306 805553 815536 816671 817667 819665 819927 820517 820809 821068 821436 821514 822216 823331 827676 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (7.48%) |
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 800587 610271 748787 393284 490859 582036 690450 700506 645333 689525 567122 597865 630451 800593 799974 743165 754070 762225 756118 728362 749669 751441 629243 723230 118450 398376 441092 393479 746935 669717 443248 595367 798183 697806 704261 478482 820517 823331 820809 827676 712805 677428 642158 643619 782745 784292 792065 803989 760919 766945 791638 722642 629604 754887 404120 401076 458531 695464 692718 730350 819665 472323 425541 597267 656921 672388 691381 716121 632887 587573 597111 737140 742935 749237 757368 629458 721875 775710 779707 787332 805553 521294 819927 821436 821514 697311 700011 624920 735140 737011 188335 458223 396333 418622 468430 544861 576505 604347 729337 392964 396786 473190 704255 396154 508873 747398 821068 577401 718669 722261 718663 804306 816671 817667 815536 822216 514034 682397 717984 562587 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.43%) |
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 118450 188335 392964 393284 393479 396154 396333 396786 398376 401076 404120 418622 425541 441092 443248 458223 458531 468430 472323 473190 478482 490859 508873 514034 521294 544861 562587 567122 576505 577401 582036 587573 595367 597111 597267 597865 604347 610271 624920 629243 629458 629604 630451 632887 642158 643619 645333 656921 669717 672388 677428 682397 689525 690450 691381 692718 695464 697311 697806 700011 700506 704255 704261 712805 716121 717984 718663 718669 721875 722261 722642 723230 728362 729337 730350 735140 737011 737140 742935 743165 746935 747398 748787 749237 749669 751441 754070 754887 756118 757368 760919 762225 766945 775710 779707 782745 784292 787332 791638 792065 798183 799974 800587 800593 803989 804306 805553 815536 816671 817667 819665 819927 820517 820809 821068 821436 821514 822216 823331 827676 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower 18 anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower 18 анал"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower 18 анал"
]
|
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.