SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980415 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980415 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902086,704242,211986,484581,110325,946055,506564,734664,235095,661124,367791,398376,396915,623913,110041,923162,350789,932497,532364,396770,184900,203768,15856,351477,651309,961471,447531,25402,989643,1026738,967415,1001330,578972,368467,1004436,957237,946102,1038908,773862,16463,891829,813246,247467,683771,11732,441878,675224,924426,869901,867287,1047472,754254,96707,485519,397417,789981,182832,231793,909407,390119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]