Query Metrics
7
Database Queries
7
Different statements
216.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.86 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно мамк"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.95 ms |
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 742631 747052 724123 731100 765334 742719 759566 794763 794863 795916 803145 64314 342317 394670 148101 391315 508940 421833 422211 421857 572175 187990 413283 443918 453491 464349 536441 469046 550366 555009 582479 714630 560993 789691 742656 714562 4463 456298 394420 252068 377323 428907 233135 413304 443154 504664 506836 385086 123862 389431 405847 423493 425279 432641 440076 428580 441846 422277 459646 460672 472690 487389 466793 475707 446520 447022 466224 536213 539487 498616 466245 492009 694089 716279 549851 591944 802229 777728 734373 796148 761597 725584 726585 765302 757388 705640 802620 187723 188335 392785 24224 392600 426003 459200 461057 388322 397921 459070 465540 443754 474265 504038 515506 489976 419523 439572 466138 478546 457459 443278 475904 386323 383590 359441 414153 698224 554576 744184 795276 445056 ] |
||||||||||||||||||||||||||||||
| 4 | 3.78 ms |
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 4463 24224 64314 123862 148101 187723 187990 188335 233135 252068 342317 359441 377323 383590 385086 386323 388322 389431 391315 392600 392785 394420 394670 397921 405847 413283 413304 414153 419523 421833 421857 422211 422277 423493 425279 426003 428580 428907 432641 439572 440076 441846 443154 443278 443754 443918 445056 446520 447022 453491 456298 457459 459070 459200 459646 460672 461057 464349 465540 466138 466224 466245 466793 469046 472690 474265 475707 475904 478546 487389 489976 492009 498616 504038 504664 506836 508940 515506 536213 536441 539487 549851 550366 554576 555009 560993 572175 582479 591944 694089 698224 705640 714562 714630 716279 724123 725584 726585 731100 734373 742631 742656 742719 744184 747052 757388 759566 761597 765302 765334 777728 789691 794763 794863 795276 795916 796148 802229 802620 803145 ] |
||||||||||||||||||||||||||||||
| 5 | 188.85 ms |
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 4463 24224 64314 123862 148101 187723 187990 188335 233135 252068 342317 359441 377323 383590 385086 386323 388322 389431 391315 392600 392785 394420 394670 397921 405847 413283 413304 414153 419523 421833 421857 422211 422277 423493 425279 426003 428580 428907 432641 439572 440076 441846 443154 443278 443754 443918 445056 446520 447022 453491 456298 457459 459070 459200 459646 460672 461057 464349 465540 466138 466224 466245 466793 469046 472690 474265 475707 475904 478546 487389 489976 492009 498616 504038 504664 506836 508940 515506 536213 536441 539487 549851 550366 554576 555009 560993 572175 582479 591944 694089 698224 705640 714562 714630 716279 724123 725584 726585 731100 734373 742631 742656 742719 744184 747052 757388 759566 761597 765302 765334 777728 789691 794763 794863 795276 795916 796148 802229 802620 803145 ] |
||||||||||||||||||||||||||||||
| 6 | 2.14 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн мам женщин"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.32 ms |
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.