SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465812 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465812 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621504,61571,69755,604993,99092,656196,484916,546653,631639,1006522,805865,948197,448856,3515,283117,647415,374650,634593,309489,82561,440712,2411,537646,151214,86892,856084,323597,742838,564146,849988,229659,455653,549959,1008853,677351,704204,182374,823621,18523,743876,320098,866474,170716,538061,106836,854629,583006,21471,621593,272524,565961,119527,132685,820471,350,992238,683715,749385,215684,892332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]