Query Metrics
7
Database Queries
7
Different statements
188.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.02 ms (85.02%) |
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 386207 391326 403357 406068 407809 413968 414870 415509 423106 424297 424933 425370 425504 427314 440650 450738 453022 453093 453292 454721 455390 456081 457012 457014 458369 458988 460346 461713 463248 464942 466557 470525 475069 477211 478268 482602 484067 485353 486437 486782 486882 488087 488101 488313 489270 491302 498254 499037 500259 508512 508519 510474 511596 511840 512067 512089 512590 514077 515236 517374 520360 521029 522561 527139 527732 541550 551186 551619 555083 561303 564076 566520 568541 569042 572211 574940 577468 580982 581229 586102 586986 587489 588374 594024 594992 597665 597956 598944 598980 599617 599956 601604 602104 610587 612375 612614 612933 617087 619484 621226 626389 650375 650863 652999 680588 686188 697718 716497 720687 755652 756803 773539 775487 795522 800016 802602 803444 803454 811993 824456 ] |
||||||||||||||||||||||||||||||
|
18.87 ms (10.02%) |
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 617087 621226 599956 586102 586986 594024 597956 756803 773539 619484 716497 775487 803454 811993 414870 423106 424297 475069 477211 478268 450738 455390 514077 485353 486437 511596 520360 521029 541550 488101 440650 482602 572211 561303 577468 594992 598980 599617 612614 602104 527732 720687 650375 697718 680588 597665 612375 407809 491302 511840 498254 527139 500259 508512 512067 580982 568541 650863 566520 588374 598944 601604 610587 755652 612933 626389 463248 517374 466557 569042 581229 686188 652999 574940 587489 795522 802602 803444 800016 508519 386207 391326 403357 406068 425504 413968 415509 425370 424933 427314 824456 454721 458988 470525 453022 453093 453292 457012 457014 460346 486782 488087 456081 458369 461713 486882 510474 512089 515236 512590 522561 499037 464942 484067 488313 489270 551186 551619 555083 564076 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.15%) |
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 386207 391326 403357 406068 407809 413968 414870 415509 423106 424297 424933 425370 425504 427314 440650 450738 453022 453093 453292 454721 455390 456081 457012 457014 458369 458988 460346 461713 463248 464942 466557 470525 475069 477211 478268 482602 484067 485353 486437 486782 486882 488087 488101 488313 489270 491302 498254 499037 500259 508512 508519 510474 511596 511840 512067 512089 512590 514077 515236 517374 520360 521029 522561 527139 527732 541550 551186 551619 555083 561303 564076 566520 568541 569042 572211 574940 577468 580982 581229 586102 586986 587489 588374 594024 594992 597665 597956 598944 598980 599617 599956 601604 602104 610587 612375 612614 612933 617087 619484 621226 626389 650375 650863 652999 680588 686188 697718 716497 720687 755652 756803 773539 775487 795522 800016 802602 803444 803454 811993 824456 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facial sperm"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"facial сперм"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"facial сперм"
]
|
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.