SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195813 LIMIT 1 [ RunTime:0.000791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195813 [ RunTime:0.006699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356930,1045597,850238,408471,384924,54117,322192,924863,469559,83050,518345,1042667,781629,718306,115939,682124,636279,536677,44665,1046532,867773,478541,890865,760290,306289,1022994,711036,641530,906947,238456,528900,344149,809619,717757,416271,80452,960811,248656,748300,793524,164655,790547,564080,136727,233782,301856,286302,798815,799285,149634,763427,728316,660491,955950,1020032,618997,217586,375523,1010167,941584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001729s ]