SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538523 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538523 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048734,12295,412571,410427,481064,391448,651286,737591,101430,615813,1023343,55515,973420,568992,387939,783816,437898,728679,1033588,451101,469430,959102,421043,48806,161763,747136,278382,329480,871526,933846,696341,280562,895499,727118,598129,19159,134039,446092,803294,885287,114171,519560,601450,150440,793752,306872,766148,15540,324584,658757,269774,62723,793931,46982,800607,795796,413960,457622,753342,828890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]