SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900043 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900043 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724396,364895,285783,20369,255567,212543,651582,75801,458225,588570,1020734,670816,826849,893730,357149,1036310,1033867,85316,344654,968657,454574,345451,882556,333738,914854,889032,318259,30116,216085,855093,306421,603099,56929,577071,1374,227527,777014,968403,751999,469490,47474,526004,67074,631766,761486,52005,654944,487944,297652,482133,884292,207947,837066,253813,336516,367885,706710,512400,554976,857196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001830s ]