Query Metrics
7
Database Queries
7
Different statements
193.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.43 ms (85.82%) |
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 145988 159511 187918 293499 313463 383238 390623 392622 397509 405690 408880 412852 413418 414094 414130 416599 416613 416686 418077 418577 418762 428216 430369 431381 436080 436639 437808 438100 439027 439056 439146 443084 443245 448057 450690 451650 452222 452789 452812 452885 452890 454511 454808 455084 455918 457544 459334 466639 469084 470405 473213 475431 478489 480502 485031 490387 490529 492029 492171 494156 494210 495467 497916 499927 502770 502789 505336 505385 505798 506086 509021 515535 515979 518185 519313 519712 521018 523273 526291 527921 532381 533922 540894 541797 542711 548185 554949 558736 563352 563866 567253 568485 572752 577520 584323 592712 593578 597534 598525 605681 606365 632153 632302 636948 648794 652249 661987 669303 674943 677240 680816 687299 705809 728775 768419 774006 794777 796204 803108 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (9.01%) |
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 669303 584323 803108 452222 187918 452789 145988 390623 509021 605681 632153 794777 728775 768419 774006 414130 554949 478489 469084 494156 438100 450690 418577 439027 490387 455918 485031 497916 558736 563352 680816 436639 437808 505798 674943 383238 405690 428216 431381 480502 499927 541797 548185 661987 592712 598525 606365 636948 796204 766889 451650 430369 443245 414094 454511 397509 416599 416686 452885 523273 526291 492029 412852 540894 454808 408880 448057 473213 506086 502770 527921 568485 652249 457544 519313 416613 490529 494210 515535 567253 597534 418077 466639 518185 519712 495467 492171 515979 563866 159511 413418 439146 443084 439056 452812 455084 502789 532381 533922 505336 542711 572752 648794 677240 687299 705809 593578 632302 293499 392622 452890 436080 459334 470405 521018 577520 313463 418762 475431 505385 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.33%) |
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 145988 159511 187918 293499 313463 383238 390623 392622 397509 405690 408880 412852 413418 414094 414130 416599 416613 416686 418077 418577 418762 428216 430369 431381 436080 436639 437808 438100 439027 439056 439146 443084 443245 448057 450690 451650 452222 452789 452812 452885 452890 454511 454808 455084 455918 457544 459334 466639 469084 470405 473213 475431 478489 480502 485031 490387 490529 492029 492171 494156 494210 495467 497916 499927 502770 502789 505336 505385 505798 506086 509021 515535 515979 518185 519313 519712 521018 523273 526291 527921 532381 533922 540894 541797 542711 548185 554949 558736 563352 563866 567253 568485 572752 577520 584323 592712 593578 597534 598525 605681 606365 632153 632302 636948 648794 652249 661987 669303 674943 677240 680816 687299 705809 728775 768419 774006 794777 796204 803108 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl anus masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк анус мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.82%) |
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.