Query Metrics
7
Database Queries
7
Different statements
194.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.16 ms (83.39%) |
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 183044 328534 360015 381933 399759 412911 419648 421409 443514 445081 447265 447640 448827 450831 452477 452633 457889 459781 460062 461596 461989 465368 465985 467762 473124 473729 474155 474897 476341 476428 476559 476937 478715 479015 480834 484725 485581 486622 487052 490427 491351 491500 492099 493266 495328 495660 495768 495806 496474 498391 499731 501204 503075 503418 503720 503798 504024 507881 510118 510424 511489 511694 511724 513160 513825 513993 514814 516281 519427 520343 520679 520686 520909 521564 523030 523828 524436 525387 526452 526984 528022 528557 533232 535453 538281 547800 547864 549590 552983 560373 561484 562965 563066 563159 564842 565320 565577 565739 567383 569575 572033 573056 580913 582535 584180 584516 584776 588620 589486 592367 592483 592745 594151 594933 596501 606304 623420 626965 669202 812043 ] |
||||||||||||||||||||||||||||||
|
20.25 ms (10.41%) |
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 510424 535453 484725 486622 487052 495328 524436 399759 547864 549590 563066 569575 582535 584180 573056 592745 564842 565320 565577 592367 596501 445081 474155 461596 514814 511489 623420 525387 381933 520679 521564 560373 565739 473729 461989 503798 495806 511694 490427 503075 519427 183044 328534 447640 476428 498391 513160 528557 588620 419648 443514 452477 473124 474897 421409 457889 460062 503720 526452 485581 496474 511724 513825 513993 447265 450831 572033 495768 499731 561484 584516 491500 448827 452633 504024 526984 480834 552983 669202 584776 589486 606304 812043 476937 459781 412911 478715 479015 516281 520686 491351 493266 510118 501204 538281 523828 520909 533232 528022 580913 563159 592483 626965 476559 495660 492099 520343 523030 503418 562965 567383 547800 594933 594151 360015 465985 476341 465368 467762 507881 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие губы пизда"
]
|
||||||||||||||||||||||||||||||
|
3.09 ms (1.59%) |
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 183044 328534 360015 381933 399759 412911 419648 421409 443514 445081 447265 447640 448827 450831 452477 452633 457889 459781 460062 461596 461989 465368 465985 467762 473124 473729 474155 474897 476341 476428 476559 476937 478715 479015 480834 484725 485581 486622 487052 490427 491351 491500 492099 493266 495328 495660 495768 495806 496474 498391 499731 501204 503075 503418 503720 503798 504024 507881 510118 510424 511489 511694 511724 513160 513825 513993 514814 516281 519427 520343 520679 520686 520909 521564 523030 523828 524436 525387 526452 526984 528022 528557 533232 535453 538281 547800 547864 549590 552983 560373 561484 562965 563066 563159 564842 565320 565577 565739 567383 569575 572033 573056 580913 582535 584180 584516 584776 588620 589486 592367 592483 592745 594151 594933 596501 606304 623420 626965 669202 812043 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие губ вагин"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 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.