SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243390 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243390 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457829,177647,501609,992314,223851,766064,121975,964424,601343,610219,1017574,965600,1002640,356992,473854,827063,35045,65307,34498,192706,330688,1005281,1035980,107560,859228,440996,778497,841772,420036,1041527,687236,74410,877216,205894,98724,62199,704436,285796,392357,756455,562559,202006,829274,103633,385141,1000008,1041124,931884,261125,87340,13650,414912,238195,290294,472270,401667,236669,1039627,424254,256295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]