SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400013 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400013 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122639,117690,845991,762832,1020692,238306,747061,160033,900737,612028,38815,142943,944243,667952,509753,78231,46891,780096,951277,442346,514386,370321,339746,743403,256132,508809,499772,518994,804491,996877,955855,256230,689962,898518,573322,691748,1015789,632078,849187,94222,958705,447917,397952,229243,141803,669786,954617,443546,624640,371754,560821,745692,23343,200867,288789,665224,432056,182130,418102,203005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]