SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451480 LIMIT 1 [ RunTime:0.005774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451480 [ RunTime:0.009334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109013,59648,1014653,850150,487551,836655,383029,990773,27027,130870,349521,42807,667438,949745,242156,747945,823261,368744,571309,538043,733364,333136,163527,159206,66219,172848,251015,820934,782304,524812,516484,122060,927287,166928,301362,110011,173181,14150,1004394,290425,845112,824991,67743,217010,718025,115754,190036,183557,471048,302986,740979,318352,489560,145366,310083,879538,591470,906387,13248,535592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]