SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981317 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981317 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313960,81245,868422,755405,1044912,64874,859961,478680,930156,2427,712426,592986,496027,276463,766072,777213,655883,24250,531412,776379,1047086,426029,88780,712151,681910,971408,4719,205856,107631,192072,575646,600801,144386,73176,142109,1036216,80973,414251,479969,951053,394706,116374,515291,474977,566144,670458,644793,909786,496309,778190,861832,508338,212939,831409,354564,769930,800830,753154,31526,123907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]