SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58200 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58200 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254764,435011,26844,500601,817567,571279,583620,601248,199585,371694,85934,811538,292120,192972,387541,468370,698014,174815,847475,538012,137156,619302,336618,219348,670884,357008,432173,783684,760505,778306,672963,920136,743749,713890,667232,750736,64901,263639,233312,751764,445934,610319,397995,978152,608983,685836,886368,14859,149851,272664,831390,792211,512596,108938,527626,750326,396789,766094,515247,56277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]