SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403414 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403414 [ RunTime:0.004293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20274,958319,837271,59391,538033,656481,338344,251062,56406,469522,515854,716316,217310,1037236,1007618,691422,345590,680434,265425,832313,284519,390712,33758,593392,105708,739242,444155,292345,268960,236784,204449,668797,997884,604298,234357,581928,528603,138707,388427,1005086,477512,768834,182624,860843,60804,495085,82140,849970,949405,975451,413413,643313,805944,246682,51921,831977,597538,931356,222560,951310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000888s ]