Query Metrics
7
Database Queries
7
Different statements
363.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.90 ms (59.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бюстгалтер нижн бел секс"
]
|
||||||||||||||||||||||||||||||
|
124.41 ms (34.23%) |
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 54085 61051 218669 357830 399500 404216 406074 408429 412150 412662 413534 414675 416382 417473 420620 421326 423662 423762 424190 427210 429594 429899 433687 435213 438331 439542 440887 443107 444131 444916 444994 446007 447095 448445 449398 450570 451519 454436 455476 456140 456258 456589 456726 457617 457630 457680 458916 460807 461146 463284 463737 464299 464528 464724 465757 468743 470611 471613 474361 475703 476468 476962 478020 478673 481372 482291 482334 482845 483216 484144 486360 487666 489720 490015 491103 491326 491493 494400 498469 499349 500414 500596 500736 501433 501948 502884 506464 509384 509509 510135 512378 516235 518104 520264 520549 520709 521883 522534 523511 524237 525793 527164 529480 534239 543611 546783 551216 557205 560644 560836 561086 562891 563871 564980 567427 568677 571201 574301 579224 588620 ] |
||||||||||||||||||||||||||||||
|
15.94 ms (4.38%) |
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 476468 438331 518104 523511 500736 512378 489720 524237 483216 510135 456140 406074 412150 54085 429899 451519 543611 464724 408429 399500 579224 551216 456589 404216 546783 494400 491103 482845 470611 499349 429594 456258 475703 414675 423662 446007 563871 61051 471613 421326 444131 465757 520549 458916 500596 218669 357830 424190 564980 427210 464528 439542 501433 444916 490015 457630 455476 413534 460807 468743 449398 416382 450570 474361 420620 502884 491326 498469 522534 500414 478673 521883 529480 448445 571201 440887 482291 435213 447095 444994 527164 423762 454436 491493 560644 560836 574301 561086 567427 433687 463737 457617 412662 456726 501948 509509 506464 486360 516235 520709 525793 534239 484144 457680 461146 464299 478020 481372 509384 482334 557205 562891 568677 588620 476962 443107 417473 520264 487666 463284 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.87%) |
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 54085 61051 218669 357830 399500 404216 406074 408429 412150 412662 413534 414675 416382 417473 420620 421326 423662 423762 424190 427210 429594 429899 433687 435213 438331 439542 440887 443107 444131 444916 444994 446007 447095 448445 449398 450570 451519 454436 455476 456140 456258 456589 456726 457617 457630 457680 458916 460807 461146 463284 463737 464299 464528 464724 465757 468743 470611 471613 474361 475703 476468 476962 478020 478673 481372 482291 482334 482845 483216 484144 486360 487666 489720 490015 491103 491326 491493 494400 498469 499349 500414 500596 500736 501433 501948 502884 506464 509384 509509 510135 512378 516235 518104 520264 520549 520709 521883 522534 523511 524237 525793 527164 529480 534239 543611 546783 551216 557205 560644 560836 561086 562891 563871 564980 567427 568677 571201 574301 579224 588620 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra fuck"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.