SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023038 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023038 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771572,556996,401507,214066,136523,864547,750116,908606,690944,836617,458432,186194,253075,392768,313718,600431,996857,790625,508927,701290,906829,403810,298282,609230,279374,389673,966612,75412,697723,632158,753270,117041,203212,414278,368765,147945,571567,33811,387050,230710,305803,182220,635596,876046,702655,260907,1043019,39889,548163,136187,167496,1041791,933282,56016,74384,364529,227488,272011,527039,883177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]