Query Metrics
7
Database Queries
7
Different statements
191.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.07 ms (84.24%) |
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 48153 153723 382918 383478 383704 388711 388862 389596 389751 391535 398125 398237 398300 411374 411533 414062 416161 416695 420686 424519 424842 427367 427457 428303 428927 439868 441347 444428 444449 446789 448907 452897 454689 454764 457017 457035 460352 465559 465624 468266 468315 469439 471009 471028 473095 473440 475729 477228 483477 485873 488791 488793 495040 496400 498267 499931 500794 508070 509984 511493 513166 518508 522034 530099 531032 536105 536146 550151 554490 560095 568206 579079 580226 584278 587451 592035 597190 597276 601825 602113 602221 603015 604892 613689 629069 635203 658777 660851 661066 671536 686972 704288 709725 739408 740737 745919 754039 754476 754597 757857 759368 760656 766429 768823 776982 778563 778674 782534 783188 785670 787069 789209 798845 809015 814188 814464 819784 824159 825793 825856 ] |
||||||||||||||||||||||||||||||
|
20.79 ms (10.87%) |
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 454764 448907 671536 550151 579079 427457 416161 629069 757857 759368 536146 488791 388862 446789 475729 568206 778563 411374 444428 661066 782534 745919 754597 754476 776982 382918 420686 814464 473440 530099 465559 635203 597276 602221 457035 444449 508070 500794 509984 398125 398237 468266 471009 477228 498267 518508 471028 584278 580226 660851 760656 787069 739408 789209 441347 391535 411533 428927 457017 473095 424519 460352 485873 814188 658777 809015 686972 785670 522034 554490 495040 439868 398300 414062 428303 465624 469439 496400 587451 603015 602113 389596 468315 383478 427367 454689 483477 488793 819784 740737 604892 499931 536105 560095 824159 825856 531032 592035 768823 704288 783188 383704 153723 48153 388711 424842 511493 389751 825793 709725 778674 766429 754039 613689 798845 416695 513166 597190 601825 452897 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.31%) |
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 48153 153723 382918 383478 383704 388711 388862 389596 389751 391535 398125 398237 398300 411374 411533 414062 416161 416695 420686 424519 424842 427367 427457 428303 428927 439868 441347 444428 444449 446789 448907 452897 454689 454764 457017 457035 460352 465559 465624 468266 468315 469439 471009 471028 473095 473440 475729 477228 483477 485873 488791 488793 495040 496400 498267 499931 500794 508070 509984 511493 513166 518508 522034 530099 531032 536105 536146 550151 554490 560095 568206 579079 580226 584278 587451 592035 597190 597276 601825 602113 602221 603015 604892 613689 629069 635203 658777 660851 661066 671536 686972 704288 709725 739408 740737 745919 754039 754476 754597 757857 759368 760656 766429 768823 776982 778563 778674 782534 783188 785670 787069 789209 798845 809015 814188 814464 819784 824159 825793 825856 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo webcam girls"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло вебкамер девушк"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.74%) |
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.