SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417896 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417896 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007531,471889,643303,180866,104140,208252,810732,111350,730230,302068,208981,447809,854696,989926,589609,900163,235045,543865,922208,389399,857516,59432,74631,285756,176113,608716,320349,453450,560127,1036374,681469,1029759,285533,413222,422707,14020,678655,165495,370704,46001,859874,122073,640808,691577,486001,80889,449010,939471,169041,361868,558399,670280,451660,615043,649242,460393,882034,79760,980256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]