SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556421 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556421 [ RunTime:0.002982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577304,109316,246368,955173,759150,12693,652040,718414,589179,127198,244535,647248,282266,412261,834083,619717,955112,532210,375967,808669,252429,16985,855395,41392,207300,311493,375482,250468,1013311,940682,445362,1008567,452854,610560,571988,444632,430414,678127,757786,1021405,644976,182831,976489,229223,1008074,796912,976775,815015,406895,428516,862635,980198,801063,720352,510260,1029458,334870,91690,404782,672840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]