SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443012 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443012 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000376,849468,581034,78700,101809,649719,88842,837353,201118,164122,537155,194985,928317,664854,811304,757505,789708,634954,764082,750153,376040,808406,915537,444632,48916,900805,698490,449774,384428,507225,350705,637974,254015,77274,637167,724813,1017053,597460,223240,262410,537098,452765,925252,446052,176008,665851,545518,309278,219679,572901,468803,964214,384378,560009,330347,980845,811418,510987,86661,127834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001538s ]