SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047213 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047213 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710827,891780,536509,587563,782706,543302,558159,26176,956990,108237,331797,65513,563704,397722,120456,244039,388495,585131,1035025,178062,332392,756989,216516,46032,1029387,114996,495785,711043,255693,514603,1016066,983106,382322,11772,580936,138331,675936,981065,94059,967221,854770,73918,762008,539144,784367,877541,941107,1014495,637220,1044314,610887,787487,879296,32459,198613,591343,803511,667466,330376,904190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]