SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103291 LIMIT 1 [ RunTime:0.001038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103291 [ RunTime:0.003604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998165,404515,875487,264261,895297,62014,14826,839432,1012515,441387,725727,451690,992967,985078,798748,365877,61685,925671,284053,91536,520030,534970,892061,38953,799653,219853,638153,266546,268068,990387,207373,144535,299602,314887,96153,903249,980797,806553,923615,21146,329364,177871,704233,262636,174424,727066,429480,505255,450478,2393,671378,608717,43543,833896,5459,75110,314113,171897,288540,306151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006512s ]