Query Metrics
7
Database Queries
7
Different statements
158.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.61 ms (82.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 65413 409016 411183 414064 414256 418112 418117 418135 418145 421052 421971 427292 428299 429606 434352 435568 435887 439240 439322 441069 442454 446176 448263 451654 452565 456161 459005 460038 460384 466624 468813 471105 475296 475422 478986 479319 479990 481952 482839 484065 485297 487008 491299 493553 494484 498112 498278 498294 499905 508353 508566 510906 511413 517710 518210 523393 525399 529230 534450 536320 537472 539701 540032 541484 544110 550021 554407 554775 558171 559412 565642 567604 567676 579519 580500 582440 582552 582812 584806 587281 589150 593119 595016 596864 599187 599502 602189 602846 609574 650280 657743 660375 661034 661424 662438 666160 669332 675402 692743 693675 709128 733594 735132 737052 750907 756840 758787 784662 791020 802899 803557 814338 823883 824352 824633 824867 826715 827284 827654 ] |
||||||||||||||||||||||||||||||
|
17.97 ms (11.33%) |
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 517710 518210 484065 554775 660375 602846 479990 427292 418145 498112 559412 451654 508353 429606 662438 733594 418135 439240 441069 475422 493553 446176 499905 498278 510906 529230 536320 537472 479319 558171 582552 544110 565642 582440 582812 554407 666160 657743 650280 675402 550021 567676 580500 589150 602189 609574 587281 593119 599502 452565 460384 468813 414256 418117 421971 435568 459005 435887 478986 409016 428299 456161 460038 411183 466624 482839 523393 669332 418112 414064 439322 448263 471105 475296 540032 508566 487008 541484 579519 692743 661424 567604 584806 595016 599187 596864 796642 803557 737052 802899 750907 735132 756840 758787 709128 784662 791020 421052 434352 481952 442454 491299 498294 511413 485297 494484 525399 826715 693675 661034 65413 824352 827284 824867 814338 824633 827654 823883 534450 539701 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.90%) |
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 65413 409016 411183 414064 414256 418112 418117 418135 418145 421052 421971 427292 428299 429606 434352 435568 435887 439240 439322 441069 442454 446176 448263 451654 452565 456161 459005 460038 460384 466624 468813 471105 475296 475422 478986 479319 479990 481952 482839 484065 485297 487008 491299 493553 494484 498112 498278 498294 499905 508353 508566 510906 511413 517710 518210 523393 525399 529230 534450 536320 537472 539701 540032 541484 544110 550021 554407 554775 558171 559412 565642 567604 567676 579519 580500 582440 582552 582812 584806 587281 589150 593119 595016 596864 599187 599502 602189 602846 609574 650280 657743 660375 661034 661424 662438 666160 669332 675402 692743 693675 709128 733594 735132 737052 750907 756840 758787 784662 791020 802899 803557 814338 823883 824352 824633 824867 826715 827284 827654 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy solo dildo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy соло дилд"
]
|
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.