SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004987s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402860 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402860 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942484,587874,787423,17143,800219,1040116,449010,65144,263034,629553,527302,960284,500564,779969,253762,711410,757426,232583,531487,535242,844436,788023,325911,786037,704378,487095,971323,242540,979374,54960,999493,368807,869992,835573,836462,613101,49667,240777,653708,909737,35417,180401,1028273,569982,632913,1043362,878866,487324,881125,406014,308602,859088,970223,807860,1046088,238057,155885,140306,272377,457523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]