SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199811 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199811 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787752,104093,1015636,464690,325643,355041,160806,777449,945975,1034218,566105,573733,142898,131534,1009181,136316,314623,64379,22482,933323,836894,56374,834338,206401,172008,501850,513391,611263,778492,611997,295047,373478,189071,636659,108486,522510,325560,740531,425286,23665,592269,741232,39385,785973,659633,890038,1019519,654352,563295,660212,886089,908211,643994,799602,366120,383799,111674,715984,336976,137690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]