SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201428 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201428 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751736,864294,910193,837598,791881,197085,438419,661436,619338,860809,374789,192147,949183,299736,677862,491054,413749,40027,946653,560956,154171,359552,782395,856749,749532,433483,252137,845482,214448,178310,137128,441907,940715,679036,732006,851503,392888,214844,796561,226521,691559,853993,893635,722720,708192,1031124,338079,693823,528098,57810,920462,739523,160,1035765,68164,226303,569014,829719,704668,475799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]