SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 16220 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 16220 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032808,1027072,360185,850700,320814,433135,516449,540863,290074,945272,908800,142778,524894,377040,156110,972464,976293,233387,161790,513162,546253,601397,386994,838210,916381,297782,832461,34049,923814,809141,940589,1046997,78226,518392,114322,654668,441,84791,135742,150974,850986,132050,672738,439506,215664,387484,527502,873509,594305,158894,766166,202655,302528,727334,707581,9953,598870,224167,946126,154889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 16220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 16220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]