GET https://search.jues.net/search/embeds/9?q=russian%20tattoo%20girl

Query Metrics

7 Database Queries
7 Different statements
217.09 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
195.40 ms
(90.01%)
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
  185353
  414957
  421552
  426444
  427132
  433910
  438911
  444873
  448903
  449821
  456649
  460388
  466471
  471508
  471596
  473678
  475974
  477452
  480113
  480329
  480947
  485670
  489378
  502952
  503470
  506494
  510541
  516941
  517349
  518988
  521991
  522587
  522641
  525377
  527084
  527422
  529111
  543330
  548712
  553327
  556425
  557349
  558950
  566969
  569855
  572073
  572511
  576268
  581514
  582530
  590615
  594162
  596306
  597130
  598943
  601940
  602729
  612605
  619277
  620011
  626859
  654458
  658091
  660558
  663255
  678544
  679179
  683282
  686537
  698233
  704021
  704152
  720785
  729315
  734954
  736858
  736947
  740590
  741206
  745277
  753382
  753816
  754262
  754584
  754630
  754696
  754759
  754841
  754894
  755979
  757796
  765101
  766370
  767307
  771210
  771762
  777928
  778241
  778351
  781226
  783209
  789308
  790233
  791181
  791701
  792027
  793057
  793975
  794048
  799089
  800245
  801114
  808830
  809756
  809920
  809943
  810904
  816156
  818028
  820110
]
12.56 ms
(5.79%)
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
  601940
  444873
  471596
  471508
  426444
  473678
  427132
  449821
  460388
  502952
  485670
  516941
  525377
  518988
  529111
  527084
  438911
  557349
  590615
  620011
  480947
  480113
  456649
  466471
  414957
  433910
  477452
  521991
  506494
  489378
  522641
  543330
  548712
  576268
  556425
  572511
  581514
  596306
  421552
  480329
  503470
  527422
  510541
  517349
  522587
  598943
  809943
  791181
  810904
  793057
  818028
  820110
  816156
  553327
  572073
  582530
  566969
  683282
  660558
  679179
  686537
  704021
  704152
  720785
  654458
  663255
  678544
  698233
  597130
  619277
  626859
  778241
  789308
  791701
  792027
  800245
  777928
  790233
  801114
  808830
  809920
  740590
  753816
  754630
  754894
  755979
  767307
  793975
  729315
  741206
  745277
  753382
  757796
  765101
  766370
  771210
  771762
  734954
  754262
  754759
  754841
  736858
  736947
  754584
  754696
  602729
  612605
  778351
  781226
  783209
  794048
  799089
  809756
  185353
  658091
  558950
  569855
  594162
  448903
  475974
]
2.54 ms
(1.17%)
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
  185353
  414957
  421552
  426444
  427132
  433910
  438911
  444873
  448903
  449821
  456649
  460388
  466471
  471508
  471596
  473678
  475974
  477452
  480113
  480329
  480947
  485670
  489378
  502952
  503470
  506494
  510541
  516941
  517349
  518988
  521991
  522587
  522641
  525377
  527084
  527422
  529111
  543330
  548712
  553327
  556425
  557349
  558950
  566969
  569855
  572073
  572511
  576268
  581514
  582530
  590615
  594162
  596306
  597130
  598943
  601940
  602729
  612605
  619277
  620011
  626859
  654458
  658091
  660558
  663255
  678544
  679179
  683282
  686537
  698233
  704021
  704152
  720785
  729315
  734954
  736858
  736947
  740590
  741206
  745277
  753382
  753816
  754262
  754584
  754630
  754696
  754759
  754841
  754894
  755979
  757796
  765101
  766370
  767307
  771210
  771762
  777928
  778241
  778351
  781226
  783209
  789308
  790233
  791181
  791701
  792027
  793057
  793975
  794048
  799089
  800245
  801114
  808830
  809756
  809920
  809943
  810904
  816156
  818028
  820110
]
1.90 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian tattoo girl"
]
1.64 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск татуированные девушк"
]
1.53 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск татуированные девушк"
]
1.52 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.