SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538508 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538508 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459282,485214,636037,881291,768417,945858,871289,537250,816021,634476,709954,549431,212694,764489,775879,350747,362004,627091,937858,977186,61474,285148,30750,844177,60206,944099,67800,177155,854102,1017462,413024,471154,78083,618993,316049,578909,353887,810231,688357,420529,900056,968542,180520,695821,8149,700144,40176,126316,704509,706439,639509,230451,270429,298655,446625,278742,785835,625049,659472,456131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]