SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428054 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428054 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75970,543462,276033,971663,4449,133326,85349,643086,455615,5970,578073,350052,897366,562664,417587,650121,1037974,550971,406601,242478,963081,1007034,228352,727089,310172,102158,512553,435626,867850,127130,625923,237532,838344,707099,718193,85772,659247,790858,522562,197807,95884,451819,250606,619123,244582,598724,473121,34004,647961,738769,758757,990105,854893,945297,405416,216482,703930,692467,361915,648286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]