SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295001 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295001 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278948,1046882,1019821,425611,882487,242677,561365,166077,645433,129551,893317,561592,770218,743407,154089,979397,254892,425875,921078,502143,20623,150329,888748,72748,431198,419606,823375,496584,82493,455684,341512,33588,335204,705139,340374,860779,64776,647747,535140,589645,268401,168229,957707,955153,806239,184561,268583,819083,613165,447974,99216,112166,736169,42037,29193,703352,477480,532181,311389,368801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001122s ]