SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510939 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510939 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72063,993086,86072,981732,423748,563982,304908,667397,974390,1017795,507633,1014422,814498,1015996,700103,126654,428735,827780,98014,144745,361183,27336,760618,551875,965040,673436,262561,431112,154890,886489,624455,6726,8200,357635,626571,458114,297800,54730,228745,955904,472691,854381,818255,276891,553504,138040,29428,850932,396617,142306,553984,992590,242134,868549,535545,357070,23381,962770,593533,473038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]