SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559212 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559212 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646304,169427,763430,357820,157676,113780,189641,581150,838545,953665,1026253,758285,759412,965448,771606,802135,891060,353817,1021063,979080,745976,1010161,409456,397939,478832,121518,676585,675856,451798,140253,448158,305842,327257,49400,289942,43618,731880,714035,310254,845818,500563,711721,637446,799018,934603,406243,475640,621274,926442,949392,239375,496150,343867,790093,498334,986114,237040,811442,812333,961436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]