SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367254 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367254 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884043,180891,338692,932681,40377,998442,33117,908722,910590,636666,973100,625336,163020,658934,1020228,573841,820041,91259,484547,329486,732289,136474,927246,383179,832513,816915,194706,398107,24787,943626,976592,41581,620987,776371,105097,902802,500787,344778,233419,49613,399040,307766,856495,93599,652106,377768,580149,580142,910874,959410,575468,751782,245287,402805,988144,1018135,751400,785301,950685,426765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]