SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599841 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599841 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28465,452925,283826,436219,861166,734512,724483,741124,708996,780773,492167,255958,787717,911708,410757,911950,785299,145254,590202,178045,816226,433045,274296,628218,843027,255446,572923,682031,440191,417082,688054,610800,46430,1027969,740135,473430,844656,711808,282505,936845,896356,355104,227286,518721,111003,412091,465598,783019,588646,845061,87889,266063,239260,760841,568542,231090,425530,211148,429717,718906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]