SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317541 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317541 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532877,714932,10092,276069,102267,244232,942957,240861,903178,87385,625539,662842,222726,557108,67142,905682,501051,892395,540448,721724,471974,878376,1000125,361839,211218,1046901,292006,225568,1030240,995097,208338,906932,971563,234863,261789,698001,558022,72404,745238,968339,403892,361027,151332,892484,223907,606813,502481,89467,410308,825700,414721,427839,520337,1134,548012,899708,792623,62469,166116,730559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]