SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318194 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318194 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293535,386122,944095,256460,610879,396758,303047,440682,206057,144987,882079,268515,914750,506899,222171,18230,211988,173898,665912,40447,349482,513926,881480,457277,114223,58589,564522,56895,1028977,809743,992563,520437,205583,78797,1021269,816707,736073,388259,263572,447355,470426,639669,391821,397481,702518,285400,1019333,708054,771596,252132,397,448239,223533,876375,342033,204839,254494,131693,1040575,913651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000814s ]