SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378983 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378983 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387400,649845,840618,978140,340552,614619,385106,634364,533807,241378,795127,1015246,986298,448271,1028025,758320,337874,729049,528286,755166,333314,288336,512224,367333,346363,49344,940242,929701,728492,836010,157554,386470,514470,659398,152177,165045,426114,85514,377463,843620,650865,608807,875496,474674,683383,1015416,293708,377705,249738,761897,453152,322919,432249,950733,781653,938544,544341,1022296,1019237,300826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]