Query Metrics
7
Database Queries
7
Different statements
211.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.34 ms (83.36%) |
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 387285 395897 400484 401810 402965 403651 409935 416415 417949 420677 420777 421619 424720 426788 433878 436444 437816 439729 443672 453646 456495 457316 459223 459406 461050 461428 462822 464149 464525 466369 466761 469885 470188 470777 479119 479750 490309 501965 504272 518148 520127 520473 523171 524513 536330 538996 542794 552862 553171 553596 554188 555546 558395 563345 566924 568776 574522 574824 576859 579465 584390 587311 590405 590627 593147 602626 606238 606558 606931 608534 611505 617108 622855 623279 623394 623427 626609 627042 649094 654300 662456 663785 666964 668309 685131 688967 690625 693648 696302 701439 705118 705317 714470 716274 717832 718274 719005 729664 729905 729933 740131 740434 759747 761185 769209 790207 793343 799602 799725 800175 801709 804701 810102 810878 811663 813831 814323 825758 ] |
||||||||||||||||||||||||||||||
|
22.73 ms (10.74%) |
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 810102 759747 617108 799725 426788 470777 421619 433878 416415 587311 608534 520473 813831 790207 523171 576859 814323 623394 623427 793343 729933 801709 466369 542794 622855 769209 729664 417949 403651 424720 461050 536330 696302 719005 627042 606238 800175 740434 761185 740131 623279 464525 400484 387285 518148 395897 401810 825758 453646 538996 549533 563345 568776 693648 668309 701439 705317 666964 584390 593147 602626 626609 775358 810878 799602 811663 717832 443672 524513 590405 459406 554188 558395 579465 662456 685131 718274 716274 729905 466761 479119 402965 469885 520127 654300 590627 437816 459223 501965 470188 552862 566924 714470 663785 688967 690625 574522 606558 606931 804701 456495 461428 439729 420777 490309 553596 649094 611505 553171 462822 479750 504272 555546 574824 705118 436444 420677 409935 457316 464149 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.53%) |
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 387285 395897 400484 401810 402965 403651 409935 416415 417949 420677 420777 421619 424720 426788 433878 436444 437816 439729 443672 453646 456495 457316 459223 459406 461050 461428 462822 464149 464525 466369 466761 469885 470188 470777 479119 479750 490309 501965 504272 518148 520127 520473 523171 524513 536330 538996 542794 552862 553171 553596 554188 555546 558395 563345 566924 568776 574522 574824 576859 579465 584390 587311 590405 590627 593147 602626 606238 606558 606931 608534 611505 617108 622855 623279 623394 623427 626609 627042 649094 654300 662456 663785 666964 668309 685131 688967 690625 693648 696302 701439 705118 705317 714470 716274 717832 718274 719005 729664 729905 729933 740131 740434 759747 761185 769209 790207 793343 799602 799725 800175 801709 804701 810102 810878 811663 813831 814323 825758 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam young sex"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер young секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер young секс"
]
|
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.