SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538917 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538917 [ RunTime:0.003226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22180,786594,211636,361057,339762,773151,795242,410213,491272,580277,755476,332485,323096,669572,178171,525411,603289,825250,911513,965807,725257,161893,868230,353549,704623,11118,592345,1012766,839633,144089,644627,339892,155458,609524,602234,768342,869083,349273,865107,929815,821065,655052,198151,750238,498230,794999,610411,287465,363115,316741,25474,370318,23826,250741,448516,557213,745479,1047446,37175,445933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]