SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314985 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314985 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028970,1020222,194871,821440,1045962,807887,992012,179147,107908,107539,166145,373797,865529,997018,364502,717913,847659,71095,982249,918144,760572,500502,512632,904126,533212,42421,837463,1043201,824039,789034,249118,971293,256027,114884,515967,836804,55857,107058,595173,479273,45426,851444,187705,501301,468359,128064,191287,321803,424855,1516,499138,908883,1046054,140461,946605,26557,967648,769590,172823,292374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]