SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032981 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032981 [ RunTime:0.004468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385140,835011,141952,52133,298030,766835,462537,346538,347190,61731,204625,306708,903673,176125,799656,628318,607951,273306,626484,981075,398872,438756,699660,930725,489969,720842,941344,387365,892433,96274,703325,1009495,288089,172008,1031188,678886,99160,216274,443083,284561,814937,283605,1038309,48938,1012627,666489,735425,633396,929990,303441,401440,51960,186056,925294,997062,944843,24486,111899,627890,124483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]