SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495063 LIMIT 1 [ RunTime:0.001767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495063 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902966,1017079,1032671,633641,119085,667155,858982,669304,789810,1002912,596631,679110,369588,1042938,737750,640231,1023207,231267,383733,876899,701467,207165,792857,907766,618944,21189,222006,558821,895691,862348,533253,54524,948926,1020828,528628,498163,988762,698765,235283,498748,889757,697443,156881,926771,158080,893703,466824,813571,50017,514293,819655,713059,449374,472015,763970,67750,965359,370795,546028,398427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001164s ]