SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545527 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545527 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249735,172569,617159,371834,876603,722761,120831,695421,138846,851571,681146,138054,810709,685538,130775,322566,263899,817125,678151,290931,1042045,570570,923315,219529,113739,932440,114885,427752,555994,675631,908563,691702,500309,898280,67772,236883,326645,227708,682385,1048121,644433,760896,609133,312074,559512,608747,973905,469512,617602,616175,263944,88385,309990,812858,947785,580232,34631,717692,860398,426922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]