SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019700 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019700 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147186,233654,203261,965066,283786,815705,344722,592327,200419,219005,653349,13131,307522,446011,29674,592969,134190,155249,918601,469934,953297,332546,217099,95683,625101,854988,667965,62144,494423,344373,502388,891942,1007306,616823,206472,280715,250462,1034526,373988,1000445,37800,608508,964774,750226,297153,238432,669756,883319,530467,117837,400428,155057,730787,287158,223951,429331,738017,850633,107751,279450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001256s ]