SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423223 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423223 [ RunTime:0.003662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587071,437745,709796,233203,190753,632445,663903,566792,376563,223777,201433,767252,475073,1028593,844013,10785,585717,391275,1045035,463549,48403,549186,815666,87388,495867,831875,297936,747824,229552,238781,361326,960182,1040761,654999,238288,37260,53827,728972,1039160,812324,127024,941142,311218,199926,475245,1044869,158403,545891,862400,91426,731478,706518,818707,572417,711525,849737,761350,88373,222978,636201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]