SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398540 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398540 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584707,812080,652707,603735,972431,202548,221592,134903,354272,996194,600382,558638,347,335865,4650,9503,844825,603335,693842,604991,233962,667422,953021,568038,25568,472720,311681,903874,549497,524720,199100,888012,940518,917442,339341,799366,637991,1016528,710457,699424,835916,533978,58683,278280,674352,523081,542017,437960,489821,365160,141221,594269,660054,418982,790812,662859,377758,690495,53227,641219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]