SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426083 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426083 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82988,125462,195009,625151,278962,127886,210732,639206,286379,590703,610045,871210,181558,762917,665613,13949,792117,21726,40581,117767,201734,393246,297885,659586,849385,368965,768746,511810,331100,809875,914009,1028257,101906,789685,238991,354762,168566,302738,599146,878236,203385,522093,771014,538796,493253,227656,493062,391748,286862,80552,133435,231664,777510,12383,824868,749970,560807,988777,923556,127274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]