SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199959 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199959 [ RunTime:0.003255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596104,972622,932469,48886,1040403,477492,717201,864195,60896,283416,157217,702782,205702,239230,181457,782056,81129,100910,188560,194775,807041,726680,446206,908876,73957,1022088,450360,876300,132037,53944,460655,359372,835796,538730,898496,150075,18419,505178,842723,608034,337742,332997,93830,861704,605765,1048173,373191,360458,417565,662701,792246,760189,157148,105537,641134,1033583,842420,759885,931004,602553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]