SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046399 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046399 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509143,650179,461839,998495,244340,958526,250429,48098,109086,560360,942571,260585,628512,531647,434864,951314,28797,864909,110153,406672,598746,485685,663638,93148,806687,855935,893333,393029,259140,846567,819096,1046807,388659,392027,918774,461063,955021,983758,273371,766114,426328,403828,239095,423645,69852,797740,734630,130646,477518,359272,135772,157050,170019,919218,770133,464624,444652,1004042,217697,396473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]