SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52653 LIMIT 1 [ RunTime:0.001124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52653 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488531,828219,643725,293286,33591,637869,810676,414636,916327,888473,981017,695291,214643,142324,466533,394993,510234,227618,410367,135030,481547,795577,939662,309768,10029,323928,919681,901281,800907,428352,504611,178959,576158,831931,828452,866463,126944,264691,1000427,967353,417497,869382,476050,100305,33330,47865,631528,682024,250371,646288,116240,294028,673489,330471,10348,100384,123858,622844,390896,169650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]