SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171751 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171751 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112382,163140,187117,393588,82137,584463,177805,1360,384385,331118,509497,630160,620265,264585,240213,695943,924371,200608,659249,267084,188137,768845,1010607,195226,956169,363055,506799,791426,445224,796649,1025808,588260,175157,314166,265156,89701,932926,103209,757498,357463,207899,790534,714738,432250,757413,8362,452798,855359,136064,518099,553275,861678,886792,865825,60285,904747,485475,754541,721796,541047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]