SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403464 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403464 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680225,737906,1041191,101377,407660,701848,804037,173939,472294,324063,901732,1043116,399801,848661,1041099,110672,724433,1017060,495138,470863,689982,457522,833239,569164,735464,898693,1015304,723122,85943,133066,977074,685334,767397,569062,624189,648295,567189,970654,962163,61081,396939,140099,196656,635570,411130,64948,302434,161631,1004192,939363,246771,114072,759141,864038,940783,51392,812494,1007732,505757,350103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]