Query Metrics
7
Database Queries
7
Different statements
161.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.51 ms (84.47%) |
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 96259 209216 272725 387026 387603 390454 390587 396339 402648 403618 411454 414104 415879 415921 416539 416613 416632 416644 416718 418827 418893 419604 420394 427132 428246 432294 434645 436639 438940 439230 439378 444540 446949 447158 448079 448575 449014 449024 452274 452914 452920 453208 456190 459198 466636 470471 471092 471110 488789 490587 493317 497691 497697 499924 513183 513223 514233 515588 521682 522167 522169 522175 522231 523058 524303 538309 553964 554550 560337 566545 567054 574763 584046 584322 584968 589549 589697 590129 595189 598566 609889 617045 617604 623606 624079 625780 629602 634100 739155 740908 745104 746144 747155 751309 752711 759365 766433 781786 783036 784744 787511 788113 791206 795406 795731 796681 803628 804701 806584 806830 806937 807206 807611 808331 808997 814418 814437 814470 819256 821554 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (9.82%) |
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 617604 629602 634100 595189 598566 624079 783036 788113 804701 806830 803628 806584 740908 766433 781786 787511 795731 806937 807206 807611 751309 752711 739155 747155 609889 784744 791206 796681 448575 759365 513183 415879 515588 514233 387026 459198 427132 488789 584968 746144 745104 623606 390454 452920 584322 522167 522175 403618 819256 821554 448079 490587 449014 493317 554550 560337 566545 96259 387603 471110 272725 499924 625780 416539 447158 589697 414104 416632 416613 416718 449024 452274 453208 470471 471092 522231 538309 497691 497697 522169 513223 523058 466636 567054 574763 584046 553964 589549 617045 590129 795406 808997 808331 439378 456190 416644 439230 446949 418893 434645 436639 521682 524303 209216 390587 396339 402648 415921 438940 432294 419604 444540 411454 428246 418827 420394 814418 814437 814470 452914 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.74%) |
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 96259 209216 272725 387026 387603 390454 390587 396339 402648 403618 411454 414104 415879 415921 416539 416613 416632 416644 416718 418827 418893 419604 420394 427132 428246 432294 434645 436639 438940 439230 439378 444540 446949 447158 448079 448575 449014 449024 452274 452914 452920 453208 456190 459198 466636 470471 471092 471110 488789 490587 493317 497691 497697 499924 513183 513223 514233 515588 521682 522167 522169 522175 522231 523058 524303 538309 553964 554550 560337 566545 567054 574763 584046 584322 584968 589549 589697 590129 595189 598566 609889 617045 617604 623606 624079 625780 629602 634100 739155 740908 745104 746144 747155 751309 752711 759365 766433 781786 783036 784744 787511 788113 791206 795406 795731 796681 803628 804701 806584 806830 806937 807206 807611 808331 808997 814418 814437 814470 819256 821554 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toys dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toys дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toys дилд соло"
]
|
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.