SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3682 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3682 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531731,381830,1036323,740983,547392,561418,197864,619726,588346,88315,646290,608895,54143,846168,518131,557095,798704,291581,704965,418113,256932,679124,1035379,545018,434814,722544,744766,333359,510094,432783,277065,118445,219551,350478,917870,388996,362318,949320,526598,81736,143313,522228,900747,6300,455085,204167,211315,265647,31135,835112,876637,707661,322958,488451,645313,355043,346117,895913,740613,737763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]