SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283623 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283623 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512379,745046,573977,733667,415456,422374,803387,870244,457862,512087,859894,612158,412872,935852,899853,596887,398494,592022,507919,576071,491073,858737,278947,448157,755413,374670,531512,1033851,14961,144334,733937,251228,432723,959699,651430,813862,449552,517942,581268,1026595,137569,603309,26717,615049,956838,575464,945533,735155,468224,85227,807479,596300,413197,77941,795164,352804,422711,768593,934139,413473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]