SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284774 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284774 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433912,156234,181896,944234,281788,714494,548853,8840,787249,146548,365333,357363,730809,540522,873592,629685,245985,561428,208661,101573,905789,167100,711135,103515,787691,765247,811724,581574,853969,847896,873711,3548,1048340,378776,436835,65508,392855,952967,365174,94068,750553,513197,809729,243371,956288,189968,668835,3434,13482,517057,872343,517200,812744,909367,416808,829182,180591,2557,966715,524768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]