SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030320 LIMIT 1 [ RunTime:0.001097s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030320 [ RunTime:0.003813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588873,720441,878701,239618,573743,1047261,474544,608389,325469,150535,749177,241161,770799,102758,132153,637163,970334,504256,245747,498309,190180,814967,875508,825397,698862,506827,569757,648846,946213,966373,406927,346548,413352,429547,17973,11077,246499,537850,246604,59387,783897,698663,66588,291536,900883,582551,354481,893364,834932,932117,402343,622305,320325,684580,421715,882678,676112,504920,831891,630859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]