Query Metrics
7
Database Queries
7
Different statements
173.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.80 ms (88.20%) |
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 26416 186782 256821 365868 382204 384760 389198 391915 410201 418843 424015 431719 433556 435001 442855 454688 455127 455696 457577 458942 460465 461256 464987 466389 469171 471006 475696 476668 484152 485295 511407 514031 517662 528572 529340 529916 529990 532407 535603 544024 548164 559270 559752 564264 564482 567816 574768 575400 577116 579259 583182 587948 588052 589140 589549 591051 592004 592382 592393 598388 602248 603961 605710 606127 607884 608188 623192 624335 634414 649024 652388 686352 704196 708933 710268 710313 712258 712306 713117 715477 716000 720529 722340 726829 735889 742104 742306 742427 744182 744238 747333 751447 752410 752496 752769 755445 756913 769369 770055 770168 770518 774725 776087 782534 787355 788796 790696 791026 799047 799159 799171 799821 803823 807134 811912 812232 814198 816126 817980 819245 ] |
||||||||||||||||||||||||||||||
|
11.51 ms (6.64%) |
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 514031 817980 819245 529990 529916 575400 583182 548164 577116 579259 649024 712258 712306 652388 686352 704196 708933 710268 713117 716000 607884 624335 591051 605710 608188 603961 606127 623192 634414 602248 776087 799821 807134 811912 787355 799171 742104 742306 744238 752496 752769 756913 799047 803823 812232 770168 742427 755445 770055 770518 744182 747333 751447 735889 769369 710313 715477 720529 722340 788796 791026 799159 442855 455696 559270 589549 458942 435001 455127 528572 814198 726829 485295 592393 484152 782534 511407 457577 529340 588052 592004 589140 592382 532407 567816 454688 466389 256821 559752 587948 774725 752410 26416 384760 391915 365868 410201 816126 535603 475696 564264 389198 424015 186782 418843 544024 574768 433556 464987 471006 517662 460465 476668 564482 598388 790696 382204 431719 469171 461256 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.48%) |
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 26416 186782 256821 365868 382204 384760 389198 391915 410201 418843 424015 431719 433556 435001 442855 454688 455127 455696 457577 458942 460465 461256 464987 466389 469171 471006 475696 476668 484152 485295 511407 514031 517662 528572 529340 529916 529990 532407 535603 544024 548164 559270 559752 564264 564482 567816 574768 575400 577116 579259 583182 587948 588052 589140 589549 591051 592004 592382 592393 598388 602248 603961 605710 606127 607884 608188 623192 624335 634414 649024 652388 686352 704196 708933 710268 710313 712258 712306 713117 715477 716000 720529 722340 726829 735889 742104 742306 742427 744182 744238 747333 751447 752410 752496 752769 755445 756913 769369 770055 770168 770518 774725 776087 782534 787355 788796 790696 791026 799047 799159 799171 799821 803823 807134 811912 812232 814198 816126 817980 819245 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo in stockings"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.