Query Metrics
7
Database Queries
7
Different statements
158.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.38 ms (81.69%) |
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 387321 388668 393076 395856 396012 397527 404742 404754 406698 407067 411201 412288 414131 414327 416364 416886 418009 419783 419867 419880 421363 421890 423424 423893 424328 426409 427259 428958 432077 433139 433312 433318 433475 438095 439925 441004 443790 443871 446080 446735 447009 447240 447400 448031 448811 451867 452131 454731 458100 458309 459804 460673 463764 464328 472320 473184 473831 477097 477210 482088 482090 483352 489281 498280 502482 509507 513859 514599 516291 517008 518403 519572 521784 521850 531231 532834 532912 534316 541587 544528 544627 545501 552120 559453 563535 565163 567166 568324 583897 590866 595369 596168 598552 605345 612856 613177 614023 617658 622331 624030 628404 642069 646884 647895 647905 651937 663308 669577 676956 679350 699610 710524 716220 727812 737127 752563 797560 811845 814220 814239 ] |
||||||||||||||||||||||||||||||
|
20.22 ms (12.77%) |
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 473184 421890 397527 393076 433139 518403 433475 544528 463764 516291 513859 679350 811845 419783 428958 447240 407067 396012 565163 395856 534316 646884 710524 404754 443790 489281 423424 552120 414327 647895 699610 448811 532912 797560 737127 459804 598552 814220 614023 605345 669577 483352 388668 498280 439925 464328 424328 502482 596168 814239 521784 617658 514599 452131 418009 416364 521850 423893 473831 411201 446080 663308 447400 433318 622331 642069 567166 583897 387321 421363 447009 458309 404742 628404 427259 568324 676956 612856 419880 441004 563535 727812 624030 482088 541587 477210 414131 433312 419867 509507 432077 532834 517008 406698 412288 472320 519572 595369 544627 647905 458100 460673 416886 651937 545501 716220 531231 613177 477097 590866 443871 446735 451867 426409 752563 559453 482090 454731 438095 448031 ] |
||||||||||||||||||||||||||||||
|
2.52 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 387321 388668 393076 395856 396012 397527 404742 404754 406698 407067 411201 412288 414131 414327 416364 416886 418009 419783 419867 419880 421363 421890 423424 423893 424328 426409 427259 428958 432077 433139 433312 433318 433475 438095 439925 441004 443790 443871 446080 446735 447009 447240 447400 448031 448811 451867 452131 454731 458100 458309 459804 460673 463764 464328 472320 473184 473831 477097 477210 482088 482090 483352 489281 498280 502482 509507 513859 514599 516291 517008 518403 519572 521784 521850 531231 532834 532912 534316 541587 544528 544627 545501 552120 559453 563535 565163 567166 568324 583897 590866 595369 596168 598552 605345 612856 613177 614023 617658 622331 624030 628404 642069 646884 647895 647905 651937 663308 669577 676956 679350 699610 710524 716220 727812 737127 752563 797560 811845 814220 814239 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm anal teen"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жмж секс втро анал teen"
]
|
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.