SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474644 LIMIT 1 [ RunTime:0.003861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474644 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398528,1038670,375064,198390,1015060,353485,548410,363327,206001,301215,558789,954406,325175,707860,941994,8135,639953,926157,794039,95617,884553,131329,433428,439069,556598,768775,822587,408482,818204,99808,816508,355960,934601,171916,215303,764405,275718,435345,828551,212746,593669,577463,30061,731833,142145,139485,346158,963760,620489,478597,101427,964230,651287,985165,893395,463342,765457,668276,464786,579066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]