SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476629 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476629 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490836,731745,1002936,673145,371147,240958,181498,898845,82121,304381,433083,36881,416373,616324,931646,613808,805308,665745,419546,934797,500896,850139,769451,938508,530842,671998,609040,841456,630101,144251,784991,468756,621416,994182,14673,218981,555399,486497,53519,1016938,952769,80195,64182,556349,158350,79705,428613,1007268,628124,731519,724170,696090,413920,720588,1023717,433216,590645,926524,826558,770966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]