SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499323 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499323 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51954,258802,702890,959317,518999,90808,185080,730033,264588,674743,907130,676064,202388,155019,500544,1034664,171890,386802,100097,578917,629320,700567,258609,286028,950407,953792,837548,218490,696633,535874,325006,251991,1029940,132627,756747,14799,393556,917155,1022752,710658,283181,255631,938656,707693,327419,976237,820068,812641,253455,407238,55008,518404,737829,158794,25387,419029,113478,274905,91992,380426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]