SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200681 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200681 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9433,20613,613084,560021,69543,997254,111312,350021,121011,707539,1026485,107459,972046,759990,20024,814676,514338,658,523253,40974,863027,843840,548976,276666,730590,434920,881927,527543,400455,593012,70912,635641,555886,993873,307396,906764,269102,485827,539198,935193,241029,351650,577134,52649,170675,932594,226807,808482,35884,807538,323812,437995,1017052,315531,880695,637566,528964,678137,212659,518085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]