SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543968 LIMIT 1 [ RunTime:0.000613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543968 [ RunTime:0.003810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185263,750150,327594,998100,703149,492014,964341,329895,1038395,703243,349519,282780,367285,302091,125083,631192,596159,481480,628122,475912,124710,805756,527154,285631,154183,791623,92630,961954,645999,899861,405853,911073,614842,987627,747271,513052,492570,51226,955771,937335,910243,542176,95143,798988,692246,778948,477116,1044003,83670,971749,89836,617460,565535,137390,740046,264910,957956,542318,270216,688765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]