SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643391 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643391 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104514,265645,1606,887483,10991,66521,172268,380924,33024,180052,210394,43753,254627,173398,436850,1019928,684988,282216,391702,1039108,105008,901772,634419,353953,643509,133887,325679,974488,545411,392428,214176,739798,161667,203587,507072,847176,150596,916620,1030428,252119,466084,1011623,334523,900506,37700,681504,306358,658693,222607,960468,887755,500656,758280,678389,1012466,1038698,614963,331537,375440,526060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]