SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150004 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150004 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978001,1041559,848832,259684,693455,606053,899131,953116,1018314,172299,330700,584480,10901,219766,247150,640619,802050,408902,582602,442450,996546,59394,304031,780912,618175,865510,687287,1036769,472086,873280,521586,117704,900338,793377,376161,903106,136044,842969,573501,1020765,198660,969788,601128,1025313,557783,517022,693042,31656,252647,823342,378386,134055,267538,476795,28901,365022,764256,495397,913776,341037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]